Hi Friends,
I am trying to get the matching values of a filtered set using subtotal. I can't get the index - match to work with subtotal it does not use the filtered set.
I have put an example where I want to get the name from the value of subtotal for greater than 2 and equal to 2.
I wanted result is yellow highlighted with red text. Also, Need to show only unique value in B5.
Thanks,
Sekar G
Bookmarks