Excel formula question.

themickey

themickey

I have a long row of numbers in a spreadsheet, the series of numbers are interspersed with blank cells throughout.
Columns/rows are random in lengths.

What is the formula to:

Calculate the highest/MAX value in the last series of numbers?
Calculate the lowest/MIN value in the last series of numbers?

Calculate the highest/MAX value in the 2nd to last series of numbers?
Calculate the lowest/MIN value in the 2nd to last series of numbers?
upload_2022-10-13_3-55-48.png


Thx
 
Last edited:
You say highest/max value .... max value is highest

Then last series of numbers ... is that series#9 or all on that same line series 7, 8, 9

Second to last series# 8

Same for lowest/min

???

It's fairly simple to do, with some additional clarity.

BTW one last one - in your graphic you refer to column, don't you mean row?
 
Last edited:
How are you dividing your series? If can set a max series size, and just make new series as needed, it should be trivial to Calc max/min.
 
minmike said:
How are you dividing your series? If can set a max series size, and just make new series as needed, it should be trivial to Calc max/min.
More...
The series size and location are all random.
I think I may have found an answer in MrExcel forum, too early to tell yet as I'm still in bed, sun hasn't risen yet. :)
The ASX today will be crap again, so no trading, not that I would in this current mkt environment, so will have all day to try and nut the problem out.
 
Last edited:
SunTrader said:
BTW one last one - in your graphic you refer to column, don't you mean row?
More...
Yes, correct, should call them rows, the yellow cells are formula cells.
SunTrader said:
AJ7 and AK7 are not centered. :)
But how you do locating an answer?
More...
I spent all day yesterday working on this algo, it's a new project.
Most of the time was spent constructing the foundation of it, today (it's 2am here) I hope to begin and sort out the best way of tackling Peaks and Troughs identification.
So this entails the time of Peaks and Troughs of numerous stocks.
The sizes/prices. Max/Minimums.
The cell identifications possibly using 'Address' function in Excel.
Haven't quite got to the stage of working the specific formula but have been thinking about it. I think the final result will be three or four formulas stitched together.
 
themickey said:
Yes, correct, should call them rows, the yellow cells are formula cells.

I spent all day yesterday working on this algo, it's a new project.
Most of the time was spent constructing the foundation of it, today (it's 2am here) I hope to begin and sort out the best way of tackling Peaks and Troughs identification.
So this entails the time of Peaks and Troughs of numerous stocks.
The sizes/prices. Max/Minimums.
The cell identifications possibly using 'Address' function in Excel.
Haven't quite got to the stage of working the specific formula but have been thinking about it. I think the final result will be three or four formulas stitched together.
More...

It would be much easier to understand if you would update your example using correct terminology (columns/rows/series), and then manually work through an example.
 
You must log in or register to reply here.
Back
Top