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.
