View Full Version : Advanced Auto Filter Long Text Strings From List Table

05-15-2017, 06:18 PM
Evening folks,

I thought I'd start another thread because the other one might be confusing,

So I've been working on doing the advanced filtering thing but unfortunately I've got stuck, it only works on simple examples when I put in these long strings somethings gone wrong with the filtering.

Can someone please take a look at my attached Excel Workbook I have created the filter table but unfortunately is not filtering the data


I have set everything up correctly as shown by the example but I don't know what to do

its a tenacious case

thank you for your advice

05-15-2017, 07:40 PM
You need to put "ID" in F2 on 'FilterData'

05-15-2017, 08:02 PM
Hello Paul,

typical faux pas as usual :grinhalo:

Oh dear well it's been one of those Mondays and I've been beside myself.
Excel's been really a pain today.
And I tried everything, I changed the code like 10 times because I thought there was something wrong with the code, with the comma in the beginging of the cell.
Well I suppose i better call it a evening after today's long day battling with the long string things.

I'll keep this open just in case something else goes awry
Thanks for the great tip
And have a good evening all

05-16-2017, 08:25 AM
The field header in the Critera has to match the field header in the data, so without "ID" as a column header, there was nothing to match