Hi there,

I have a table 154 rows (name) by 31 columns (criteria).

There are 220 possible criteria, but one name cannot have more than 30.

I would like to list the names each criteria uses.

For example, criteria #1 might be used by 7 different names, and this can be
found simply with "=COUNTIF(range,"criteria #1")". What this does not give
is the names that are used, merely the number of names that use it.

I suspect I will need a macro, but have no idea how to start. Any ideas
please?

Thanks,

Ewan.