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?
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?
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.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks Mike.
Just found the way to upload the sheet.
Last edited by R.Gaard; 07-25-2014 at 04:18 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?
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks