Show Top 3 Values

B

Bagia

Hello,

I have a worksheet with several records(rows) and each record contains
several columns (5) with values. What I would like to do is to display the
top 3 values from that record. How would I set that up?

Sample Data:
For Row 1
ColA: 100
ColB: 150
ColC: 250
ColD:115
ColE:250

Top 3 Values would be from the list above would be: 250, 250, and 150. I
don't want to manually do this for 1500 records. Is there a way to write a
function for this?

Thanks in Advance.
 
T

Toppers

In column F

=LARGE($A1:$E1,1)

in G

=LARGE($A1:$E1,2)

in H

=LARGE($A1:$E1,3)

HTH
 
B

Bagia

That works well Toppers. I'm going to take a step further and wanted to see
if I can have a function that will sum up the top 3 values from the row. Is
there a function for that?

So instead of creating a function for each column to get highest, 2nd
highest, and 3rd highest, just have the system sum up the to three values in
one column say column F?

Thanks in advance.
 
T

T. Valko

=SUM(LARGE(A1:E1,{1,2,3}))

Or, say you wanted to sum the largest 50 from column A:

Array entered:

=SUM(LARGE(A:A,ROW(INDIRECT("1:50"))))

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top