Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using LARGE function in incontiguous cells
Hi.
I'm wondering a way to highlight the highest score in incontiguous cells. For instance, in the example below, each person has a score in three categories and I would like to highlight the top score in each category. I'd looked at LARGE function but it seems to only take continuous cells as an array. John 1 67 2 74 3 159 Richard 1 76 2 85 3 190 David 1 56 2 62 3 129 Sue 1 69 2 77 3 163 Any way to get around this? I'd also like to highlight 2nd and 3rd scores in each category but that's probably easy once I know how to do the highest, I suppose? Thank you. -- Maki @ Canberra.AU |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large function result as reference for offset function | Excel Discussion (Misc queries) | |||
Large If function | Excel Discussion (Misc queries) | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
large function help please? | Excel Worksheet Functions | |||
IF Function too Large | Excel Discussion (Misc queries) |