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...
Abiola1I have cleaned down the spreadsheet somewhat as it is quite large, but hopefully there is enough left on the attached to demonstrate what I am trying to achieve on the draft Schedule of claim, where I am just wanting to extract and reproduce some of the entries but not all - sort of a pivot table (layed out in columns) hybrid with a filter (extracting only the relevant entries). What do you think?