Forum Discussion
Abader Onsy
Oct 02, 2017Copper Contributor
I need help writing a complex formula
it's like a college certificate i write the person and his degree in all subject in the blue table i want Excel to write that the person who have..... from 0 to ...
SergeiBaklan
Oct 02, 2017Diamond Contributor
Hi,
I'd define that ranking somewhere, perhaps in another sheet (here is in columns F and G) and use simple LOOKUP on them