Use filter and the filter value is on cell E1
I have a table with data, area from A2 to D100
I need to apply filters and the filter condition is the value of filtered cells, to be equal to the value of cell E1
Tried to enter the =E1 with or without brackets - quotes in filter value but it does not work.
Please help.
Thanks
In which column are the values that match with the value in E1?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis Xronia polla.
Column C but I'd like to find out how to adjust it to future needs.
thanks
Χρόνια Πολλά με υγεία!
Take a look to the sample. Is this what you mean?
And for excel 2003!
I searched and found how to change it to work!
Good for me.
thank you Fotis for all.
Cheers
Fotis, my bad but it does not work with non numerical values.
Maybe you could adjust it to do so?
Thanks anyway
Last edited by nvembos; 12-27-2012 at 07:26 AM. Reason: Found solution!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks