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? Thx
https://www.ablebits.com/office-addins-blog/max-function-excel-highest-value/ https://www.techonthenet.com/excel/formulas/min.php
Yeah, I know that bit, it was finding them automatically which was my issue, I'm attempting to calculate the last two wave peaks and troughs which arrive at random times and size.
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?
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.
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.
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.
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.