Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SMALL(?)
Hi, I have a question about this function:
Well it's not exactly that function it's the opposite one (BIG?) I don't know its name, because in my Excel it's called K.ESIMO.MAYOR. I have a table with numbers and names and I want the name of the biggest number, the second biggest, etc... How do I get this through formulas? numbers may be repeated, but just one would be enough. With K.ESIMO.MAYOR I can get the biggest number, but now how do I use this in another formula to get the name? I'm not good with references so can you help me out? Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SMALL IF | Excel Discussion (Misc queries) | |||
Help on {=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1))} | New Users to Excel | |||
ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
Using Small | Excel Worksheet Functions | |||
Small | Excel Discussion (Misc queries) |