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)
one option is to use conditional formatting on that column with a formula like:
=(D1>1)+(D2>1)
and choose a unique fill color
and then filter by that color
(see attached)
alternatively you could do the same thing using a helper column and then filter by that column
(in the attached I filtered out the zero values)
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)
