I have range EF5:EF130
I have formulas in place to find highest in section EF5:EF30, EF31:EF60 and EF61:EF90
I need to be able to find the next highest number in EF5:EF130 that IS NOT the same as the above 3.
Example:
Points Awarded to all teams is in EF5:EF130
Cell EE194 is highest points in section EF5:EF30
Cell EE195 is highest points in section EF31:EF60
Cell EE196 is highest points in section EF61:EF90
Cell EE197 is next highest points in range EF5:EF130 but cannot be the same as the first three
I'm stuck -- any help would be much appreciated.
Bookmarks