I tried it .. and working almost fine.. but if the E column is not sorted then answer is incorrect. See the problem in screenshot.Juniad
Yes ... I tested it in F-column!
Modify F1 to A1 as below ...
for cell A2=IF(E1=E2,A1+1,1)
below with original ...
View attachment 64892
Almost there.. Thanks a lotTRY to use this
Code:=COUNTIF($E$2:E2,E2)
Actually my answer not yet revealed. Serial no should be in sequence if rows are not filter .. and if rows are filter based on Site Column then, if there are multiple sites filtered then each site should have own series even they are not in sort order.... almost there
Juniad .. in which part You have needed something else than with un/filtered cases?
Is there any more details which would take care?