Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel formula/function help?
Ex. If I have 50 columns of data and each column has lets say 10 rows to numerical data, and each column has a sum. What formula or function can I use to create a list of the top 10 columns in terms of the highest sum value?
Im not sure if the Large formula is the correct function. I would like top return the top 10 column in sum value.
Thanks.
1 Answer
- expletive_xomLv 75 years ago
yeah, the LARGE() function will work.
so if A1 to A10 have numbers and A11 will have the SUM()...and that carries out to column AX or cell AX11 has the last SUM()
then in A13 you can use
=LARGE($A$11:$AX$11,ROW(A1))
and drag it down 10 rows (or 50 rows if you want)
you will get the top 10.
it should just work....
i guess B13 would have the MATCH() function so you know what column# to look for
=MATCH(A13,$A$11:$AX$11,0)
but then you have to figure out how to handle the dreaded tie...everyone has an opinion
