Forum Discussion
Solved
Filter and Sequence Function
Dear Experts, I have a Data like below:- The Column"D" can have the values from 1..5 but in Sequence only, I need to filter only the ones where this txNumber is starting from...
In that last column use the following and fill down:
=IF((D2>1)+(D3>1),"grp-"&COUNTIF(D$1:D3,2)-1,"")
I will try attaching again but sometimes this forum will filter files (especially .xlsm & .xlsb)
Thanks m_tarler with your logic yes atleast it colors the required date into a specific color so can be grouped, can we modify some more logic so that in the last column with the criteria you mentioned it will group them into grps 0,1,2,?
Thanks,
Br,
Anupam
In that last column use the following and fill down:
=IF((D2>1)+(D3>1),"grp-"&COUNTIF(D$1:D3,2)-1,"")
I will try attaching again but sometimes this forum will filter files (especially .xlsm & .xlsb)
