Forum Discussion
Filter function
I am trying to extract data for a Schedule of Claim, from a data sheet which goes up to cell BS1233 (so quite large). The data inclues items organised into, eg: Column K - category of claim (A-K...
This is doable with FILTER. What are the names of the columns you'd like to exclude?
Patrick2788 Thanks for your response, really I want to exclude most of the columns, and just filter positively to show the columns I want - I have uploaded a file - do you know if this is possible?
Can you please list the columns you want to keep? Thanks.
I think you can run with this. This is the idea:
My sample data is in columns A to R
=FILTER($A$2:$R$5,(COLUMN(A1:R1)=16)+(COLUMN(A1:R1)=4)+(COLUMN(A1:R1)=18)+(COLUMN(A1:R1)=9))
Excel will re-order the columns pulled back (e.g. 4, 9, 16, 18). It ignores my ordering.