How to exclude columns in =Filter
Hi
I'm trying to make a chart that is pulling from another sheet based on specific criteria.
So far it worked with
=FILTER(Ledger!A:G,Ledger!D:D=MainLedger!A2,"")
But I would like to exclude columns D & E in the final results because it just repeats the number and name that I already have at the top as a sort of title.
All the tutorials and I've seen only really show how to skip columns when you're making a chart in the same sheet and I guess I'm struggling where to specify that it should be pulling from another sheet. So far I've tried and failed with:
=FILTER(SEQUENCE(7),ISERROR(XMATCH(SEQUENCE(7),{4,5},0))) (from a youtube video)
I've tried pasting it in various places in my original formula but it didn't work.
I also tried some =DROP formulas
And using {} to specify columns that I want
I keep getting various errors or the formula just stays as plain text in the cell.
Please be patient with me.
[link] [comments]
Want to read more?
Check out the full article on the original site