Using LARGE function in incontiguous cells
Hi
You can use a named range for each category and the use the name as
reference in your formula.
Select alle catetory1 cells and goto InsertNames Define Enter: Cat1 as
name.
=Large(Cat1,1)
Hopes this helps.
....
Per
"Maki" skrev i meddelelsen
...
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
|