| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
Is there a function to give us the highest value in a list of tex
Agreed! Definitely nicer! :)
In article , Ron Rosenfeld wrote: On 10 Nov 2005 11:51:54 -0800, "Harlan Grove" wrote: Domenic wrote... Here's another way... If Z is higher than Y, try... =INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1: A10),1), COUNTIF(A1:A10,"<"&A1:A10),0)) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. If A is higher than B, try... =INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1: A10),1), COUNTIF(A1:A10,"<"&A1:A10),0)) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. ... Since any instance of the 'highest' value would be as good as any other, both formulas could be reduced to =LOOKUP(2,1/(COUNTIF(A1:A30,""&A1:A30)=0),A1:A30) and =LOOKUP(2,1/(COUNTIF(A1:A30,"<"&A1:A30)=0),A1:A30) respectively, neither of which require array entry. Nicer. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| Find in list function | New Users to Excel | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| i need a function to find the highest value in a list | Excel Worksheet Functions | |||
Threaded Mode
