Picking Highest numbers out of List

JBF · #1 03-08-2018, 04:29 PM

Quote:

Originally Posted by ArviLaanemets

Let's say, you numbers are in range A2:A21.
Into second column enter the formula (p.e. into cell B2)

Code:

=(SUM($A3)=0)

NB! The formula refers to next row in column A!
Copy the formula down into range B2:B21.

Into any cell where you want the end result, enter the formula

Code:

=SUMIF($B$2:$B$21,TRUE,$A$2:$A$21)

ArviLaanemets,
Thanks for the post. Your formula works, but I guess I should have been more specific... your method while it works, really won't work for what I need, it will clutter up she sheet making it confusing.

I have attached a sample spreadsheet to illustrate. My numbers go from 1 to 75 across the top starting at B1. picks start at A6 and will go down many rows... 100 or so.

is there a way to accomplish the same results that your formula returned, but a different way or with a Macro?

Thanks again for you efforts.
JBF

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picking value from a certain cell under certain conditions	kao	Excel	1	09-07-2017 09:34 AM
Average of highest 7 out of nine quizzes	wallace990	Excel	2	05-16-2017 01:51 PM
Fetch highest number	am_gup123	Excel	2	03-23-2017 01:56 AM
Highest & lowest Numbers	ibrahimaa	Excel	3	04-23-2012 07:52 PM
Page number picking up heading numbering?!	Ulodesk	Word	0	09-24-2009 01:56 PM