Dear all friends,

Thanks for helping me so far.

I was just thinking if it is possible to auto number the autofilter
result.

For Eg,

Sr. No Answer Name
<Blank Yes X
<Blank No X
<Blank Yes X
<Blank Yes X
<Blank No X

If I auto filter the above range on "Answer" then is it possible to
get incremental values (Default: 1) in Column "Sr. No" depending upon
the result rows displayed by autofilter

For Eg,
When I select "Yes"

Sr. No Answer Name
1 Yes X
2 Yes X
3 Yes X

And When I select "No"

Sr. No Answer Name
1 No X
2 No X

Please let me know if it is possible and if yes then any suggestions
for how.

With Regards,

Ashish