Using the Filter Function & Finding the Cell Reference

[jgarza0422]

Hello,
I was wondering if there is a way when using the filter function to also use the reference cell feature to go back to the original source location from the filter data?

 

[Joe4]

Could you walk us through an example of exactly what you are trying to do, showing us your data and formulas?

Also, I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)