How to auto update the sl.no while selecting the respective column data in the filter list

Dears,

gd afternoon everybody. I could not update the sl.nos of the column automatically though the formula a1+1 so an assigned, while selecting the respective column in the filter list.

an early solution is solicited.

Kaleem...

Here the sample

after sorting, If i filtered the list and select type A, then Sl.No. 1, 3, 5, 7 should change as 1, 2, 3, 4 so on.

Dear

I could get the result, which i expected, for your ready reference
i am attaching the file. In that, after sorting and filtering the sl.no should start with 1 for selected
and filtered constituency only. Further, If i selected the both constituencies, the next constituency sl.no
should start again with 1 only.

I think you got my point.