Reflects the filtered value in desired cell.

[Saurabh Joshi]

This is my sheet below...

S. No. Name Sport
1 Saurabh Cricket
2 Saurabh Badminton
3 Suresh Cricket
4 Suresh Hockey
5 Ram Hockey


Query:
I put a filter on the above data. and i filter the data according to the name.
I want that when i put filter on name then the filtered name is automatically reflects to a cell.
Suppose i set filter to "saurabh", then in the desired cell it will show name "saurabh". but if i change filter data to "suresh" then value on that cell change to "suresh".

 

[NARAYANK991]

Hi ,

If you filter on a name which exists in your data , then it is obvious that the first row will contain that name somewhere in some cell.

In your desired cell , just put in a formula to refer to this cell in your data. It will display the name.

Narayan

 

[bosco_yip]

Assume your data in range A4:C9 with Filter and your desired cell in B2,

then in B2 enter formula :

=INDEX($B$5:$B$1000,SUBTOTAL(105,$A$5:$A$1000))

Regards
Bosco