Forum

Ok, I have had a play around and attached is the result. A big thanks to Riny for the solution. Attached is the file with the Riny CF using =E$2=MED...

Riny, Perfect and much cleaner than the work around I did. Looking at the formula I was almost there but nowhere close enough. A big thanks.

Riny, Sorry for the confusion, I was referencing the B column as a whole and the Row 2 as a whole but can see how that might be taken as B2. That ...