mdfreeman New Member Apr 15, 2014 #1 I am dreaming of being able to paste a string of numbers (separated by commas, semi colons or the pipe) into a standard filter. My simple attempts haven't works. Is it possible? What is the correct deliminator? Thank you in advance for the help.
I am dreaming of being able to paste a string of numbers (separated by commas, semi colons or the pipe) into a standard filter. My simple attempts haven't works. Is it possible? What is the correct deliminator? Thank you in advance for the help.
Somendra Misra Excel Ninja Apr 15, 2014 #2 Hi mdfreeman, Just a thought- if you have a list of of numbers to be filter down than you can use advanced filter to get the data. Regards,
Hi mdfreeman, Just a thought- if you have a list of of numbers to be filter down than you can use advanced filter to get the data. Regards,
mdfreeman New Member Apr 15, 2014 #3 Thank you. Interesting. I have never used this feature. Quick testing of isn't working but I will play more.
Thank you. Interesting. I have never used this feature. Quick testing of isn't working but I will play more.
Somendra Misra Excel Ninja Apr 15, 2014 #4 @mdfreeman See the sample file for more details. Regards, Attachments Advanced filter.xlsx 34.3 KB · Views: 4
mdfreeman New Member Apr 15, 2014 #5 Thank you for taking the time to put the file together. Advanced filters makes perfect sense now. Still, it would be nice to be able to drop multiple items into the simple filters
Thank you for taking the time to put the file together. Advanced filters makes perfect sense now. Still, it would be nice to be able to drop multiple items into the simple filters