I have a range of cells B2 to B30 with a choice of 2 different text values - 'Rads' or 'UFH'. In cell C3 I need a formula to look at the cell range B2 to B30 - if all the cells say Rads then C3 will say Rads, if they say UFH then C3 will say UFH but if B2 to B30 say both Rads and UFH then C3 say both.
Im sure it is a very simple formula but help will be appriciated.
Thanks
Jon
Bookmarks