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)
Try this in E2 and copy down:
=IF(AND(D2<>1,D2=N(D1)+1),"Re-Tx","New-TX")
Thanks Riny_van_Eekelen , not like that.. let me elaborate more, So in last column create a grouping logic like,
the 1st sequence (from 1... any num >1) = grp-0, and another such set = grp-1 and so on.
Br,
Anupam
