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

Tagged with

#financial modeling with spreadsheets
#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#Excel alternatives
#FILTER
#exclude columns
#chart
#sheet
#Ledger
#criteria
#MainLedger
#formula
#SEQUENCE
#ISERROR
#XMATCH
#DROP