I want to return the results from a filter function formula into ongoing columns rather than down rows - this is because I have a large list of over a 2000 rows of data that I want to look them up in another table and return all the possible values for one code. i.e. I have hierachical data that is coded and I want to see the unique codes for a level of code up. My formula is currently:
=FILTER('ACNY 2024'!L2:L15979,'ACNY 2024'!I2:I15979='Parish make up'!AX2)
Or can I do an xlookup that returns multiple answers but the number of answers will vary between 1 and 13? Many thanks
