1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/ZielinsQa
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article