Creating a list from a large set of data

[oldraper]

hi there, i have spent hours reading lots of other topics with similar questions, but i can' seem to find a way of applying it to my needs correctly.

I have a large list of in rows with multiple column headings: ie. Name, date, amount. I need to generate a separate list whereby the rows that correspond to a given criteria are extracted and listed sequentially.

I have attached a simple example to demonsrate what i mean.

in the attached spreadsheet, i have a column of colours, and a column of objects- RED book, BLUE hat, etc.

I'd like the criteria that i type in the green cell (a choice of colour), to generate a list of all the items that match that colour, and be displayed in the orange cells. So, if the green cell says BLUE, the list should pick out the BLUE dog, BLUE hat etc.

I have been going round in circles, and getting lost trying to follow complicated youtube videos. if anyone can help and simplify it, i would be very appreciative!
Kind regards

[canapone]

Hi,

please see the file attached.

All the formula are array formula to be confirmed with control+shift+enter as in M2

Please Login or Register  to view this content.

Regards