Picking Highest numbers out of List

ArviLaanemets · #1 03-09-2018, 02:03 AM

There was a typo in formulas in previous post attachment. Here is correct one.

JBF · #2 03-09-2018, 03:28 PM

Quote:

Originally Posted by ArviLaanemets

There was a typo in formulas in previous post attachment. Here is correct one.

Ok, that works. Thank you for helping me with this!!

JBF · #3 03-10-2018, 06:35 PM

Quote:

Originally Posted by ArviLaanemets

There was a typo in formulas in previous post attachment. Here is correct one.

ArviLaanemets,
Do you think you could come up with a way where on Sheet1 instead of the numbers counting up or increment before the zero hits, just having the highest number returned.

I have updated the Random spreadsheet and uploaded it. I added sheet4, basically a copy of sheet1, with modifications and details. I outlined what I would like on that sheet.. I hope it makes sense to you..

Thank you for your 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