Formel for top 3

**R.Gaard** · 07-25-2014, 03:48 PM

I need a formula to make a top 3
Top 3 is in R3, R5 and R7. I need a formula that takes the 3 highest values in row 9 and then take the names in the same column and write them in R3, R5 or R7.

Does it make sense?

**mikeTRON** · 07-25-2014, 03:59 PM

The large formula does what you want.

http://chandoo.org/excel-formulas/large.shtml

=Large(YourList,2)

I cant assist with bringing you the name associated with the number because you didnt post a sample dataset.

**R.Gaard** · 07-25-2014, 04:04 PM

Thanks Mike.

Just found the way to upload the sheet.

**mikeTRON** · 07-25-2014, 04:27 PM

yikes, that seems awfully difficult to deal with, why not have a standardized dataset in the background then reporting on this tab?

Anyway, How do you find the top 3 largest when you have 7 ties for the largest?

**R.Gaard** · 07-25-2014, 04:32 PM

I dont know what you mean..

If there are ties, I want all names of those who are ties in the same cell. If its possible.

**mikeTRON** · 07-28-2014, 11:44 AM

It is possible, but the data layout is horrible and will mean way more work than if you standardized it in a tidy manner in the background.

Typically it is best to have a data tab, then some sort of reporting on top of that data. This keeps things much easier to manipulate and report on. With this, you could use a pivot table using excel's native features to do exactly what you want in under 15 seconds. The current layout creates much more overhead for you and any clever formulas you want.

**R.Gaard** · 07-28-2014, 05:03 PM

okay. I have no idea how to do that. Im not use to work that much inside excel. I mostly use it for importing to economic programs and other simple formel and calculations.