Lemice kindly gave me the following formula:
=MAX(IF(B$2:B$10=1,C$2:C$10),IF(B$2:B$10=2,C$2:C$10))
which will give me the Maximum value in Column C if Column B cell = 1 or 2,
I have tried this formula and it hasn't given me the exact results I want.
If Column B = 1 and the max value is 10 and then if Column B = 2 and the max value is 12, I need a formula that will recognise both Maximum values; so I can then place my "L" in the corresponding cells for both Maximum values.
Eg: Col B Col C Col D
1 12 L
2 11 L
1 10
2 9
1 12 L
To place the "L", Lemice offered another formul:
=IF(AND($C$2=$E$2,OR($B$2=2,$B$2=1)),"L","")
Sorry for any confusion on my previous post regarding this and I hope that there is some type of formula that can do this.
Thank you for any help given.
Bookmarks