Hi,

I have four columns of data and these cells will all have unique entrys from
A1 to L20. However, this information may change round so that some times not
all the possible entries will be used. From this information then, I'd like
to create an IF statement that identifies whether (for example) A1 is present
in any of the four cells. If it is I'd like the cell to show T but if not I'd
like the cell to show A.

I'd be greatful if anyone could point me in the right direction as I'm sure
there's an answer somewhere!

Hannah