Hi all.
in each row I have 3 columns which might or might not contain the single character R.
In another column I need to return an R if one (and only one) of those 3 columns has an R in it. If there are none at all I leave the cell blank, if there are 2 R's in the row I need to flag an error, eg the character E.
I've struggled with this awhile, but am getting confused (it happens a lot).
Can you help please?
Thanx as always
KK
Bookmarks