Hi!

return the top 3 values.....used the =sum(small(data)

How do you equate the top 3 with small?

Where is this data? If you want the top 3 are there any duplicates (ties)?
If so, how do you want to handle that?

Biff

"Mary Etta" <Mary wrote in message
...
I am trying to return the top 3 values from a column in a worksheet to
another worksheet I am able to return the lowest value using index, match
and
then have been able to used the =sum(small(data),{2} for the 2nd and {3}
for
the 3rd. However this is only for the one cell I am ranking and want to
return the entire row values as well. There are approx 10 other columns
of
data in the row I am wanting to return, any ideas?