hey,
Could someone help me with a search function.
In one workbook i have
Sally Red
Peter Blue
Darren Red
Ben Red
Ollie Pink
alan Blue
is there a function that will put all those that liked a colour into a column?
i.e
Red Blue
Sally Peter
Darren Alan
Ben
thanks
Could someone help me with a search function.
In one workbook i have
Sally Red
Peter Blue
Darren Red
Ben Red
Ollie Pink
alan Blue
is there a function that will put all those that liked a colour into a column?
i.e
Red Blue
Sally Peter
Darren Alan
Ben
thanks