Hi Johan,
You don't mention in what form you need the names (in a string, in a column,
etc.) but I would transpose my data into another sheet, then you can use a
simple autofilter to see rows with X in column B.
Post if this solution meets your needs and if you want additional help on
transposing and filtering!
Regards,
Stefi
€žjohanvdv€ť ezt Ă*rta:
it works if I put a CONCATENATE around it but:
- I can only concatenate 5 strings
- I have A LOT of columns, it would become a VERY large formula
Is't there a shorter, better way ?
|