Windows 10
Excel 2019
I have the below formula which looks at the range E2:E100 and if it finds each cell in the range has the Number 1 it returns the text "M", if it finds each cell in the range has the Number 2 it returns the text "S". If it finds a mix of the numbers 1 and 2 it returns the text "M+S".
In the E Column there will always be only the Numbers 1 and 2.
I would like to remove the range limitation of E2:E100 and have the formula look down all of Column E and where it finds unique data in Column B, then look down the whole of Column E and if it finds each cell in the range has the Number 1 it returns the text "M", if it finds each cell in the range has the Number 2 it returns the text "S". If it finds a mix of the numbers 1 and 2 it returns the text "M+S".
An example would be:
I also have the VBA code below that looks at Column E and for each unique range in Column E, it alternately colours each range from Column A to Column J.
I wonder if, as an alternate or better way to run the above formula, it could be incorporated into the below
function. I am unsure if it is better to do it this way or just use the formula on its own.
Bookmarks