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)
