Yes i am using 365 ProPlus and this filter formula works. Never heard of/used that before.
That said, I can't figure out why your formula uses Query!F$2:F12
This was just an oversight when i made the sample WB. Normally i do use table references but when i was trying to get my formula to work i thought that might be causing the error for some reason.
I have entered the following formula and it looks to be working beautifully.
Could you give me a brief explanation about the indexing column you mentioned. I did add this in and all is well but i'm not sure i understand how this makes it more efficient.
Also wouldn't my data need to be already sorted for this column to work? Normally i get an excel export from our ERP i copy the data and paste values into this sheet, the data is not sorted in any way at this point. Honestly if i have to remake that column formula once it's been sorted it wouldn't be the end of the world.
One last thing, excel seems to have added the need for the "@" symbol when doing table references, sometimes it looks like [@[REFERENCE]] and sometimes its [@REFERENCE] sometimes this gets added and sometimes it does not. Could you explain the purpose of this and why it needs to be added?
Thank you for all the help, it's much appreciated.
Bookmarks