Hi Marcol,
May I thank you for your help with the “Crossing points in two columns of data spreadsheet”
That is great.
The use of nested “If “ & “And” & conditional colour formatting very helpful.
To identify the Maximum & Minimum values (which I have labelled “ Peak” & “Through”)
I have adapted your formulas and used them in Columns E & F
See my attached modified Spreadsheet “Crossing Points”.
Are my attempts at Maximum & Minimum formula in columns E & F correct?
Thank you again
Best regards,
Derek
Bookmarks