Hello!
It looks a very simple problem but i can't figure it out...
So i ask for your help.
Is there a way of "sum the POPULATION of the 3 highest AREAS" ?
Population in column A
Areas in column B
Thank you!
Hello!
It looks a very simple problem but i can't figure it out...
So i ask for your help.
Is there a way of "sum the POPULATION of the 3 highest AREAS" ?
Population in column A
Areas in column B
Thank you!
If the areas were all distinct values, that is, no duplicates, you should be able to use
Formula:Please Login or Register to view this content.
If there were duplicate areas and you wanted only the first largest 3, then you'd need the more exotic
Formula:Please Login or Register to view this content.
The ROW(A2:A8)/2^10 term subtracts small monotonically increasing fractional values from the presumed integer values in column A, which ensures all resulting values are distinct, and duplicate values in rows with lower row numbers would be used first. Adjust the denominator, 2^10, as needed.
Thank you! The solution provided Worked like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks