Why do you want to do that?

Basically, the answer would be no but if you explain why there might be some
other formula that might do what you want.

--
Biff
Microsoft Excel MVP


"Xcel" wrote in message
...
volko small favour for me, can we do this with out row and rows functions.

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Xcel" wrote in message
...
Thanks volko,
Thank you very much for your help.

"T. Valko" wrote:

No, it doesn't have to be in ascending order. I just demonstrated it
like
that thinking it would be easier to follow.

See this screencap:

http://img413.imageshack.us/img413/1220/file2ww9.jpg

This uses the exact same formula with the data in random order.

--
Biff
Microsoft Excel MVP


"Xcel" wrote in message
...
hi valko thanks for your help,
but i didn't solve my problem exactly, according to you solution the
series
must be in descending order. i didn't have the series in any order
format.please help me.
i was thankful to you forever.

"T. Valko" wrote:

See this screencap:

http://img513.imageshack.us/img513/7177/file1lw1.jpg

The formula used is an array formula. Array formulas need to be
entered
using the key combination of CTRL,SHIFT,ENTER (not just ENTER).

--
Biff
Microsoft Excel MVP


"Xcel" <Xcel @discussions.microsoft.com wrote in message
...
i picked top10 values with the help of the large formula from an
array
of
values, on that i wrote match function, with the help of the
match
function
values i wrote index for getting respective name for the
value.its
working
propely when the values are not repeated if any value repeated
large
working
properly but match was giving the first match value only,for that
i
need
individual match values. pls anyone help me.
1 san
10 raj
9 cami
12 jhon

Regards,
Santhosh.