Hi all,

Column A specifies a room type: corridor, office, toilet etc.
Column B specifies the floor finish chosen for that room: carpet, vinyl,
tiles etc.

There is a seperate worksheet where the floor finishes are summarised.
After each flooring type I wish to add a list of all the rooms within which a
particular floor finish has been specified, i.e. list out the rooms where
carpet has been selected. Ideally this would be listed in one cell.

Any ideas?


Thanking-you in advance,

Cheers,

Neil