PDA

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



dj44
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

19186

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

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

dj44
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

Paul_Hossler
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