Forum Discussion
I have data of an irregular curve and I need to get the maximum value out of Excel.
Maybe as below? This method should match the smooth curve in the case shown. Note though that the smooth curve shape may depend on chart scaling (see ref in attachment).
Maybe as below? This method should match the smooth curve in the case shown. Note though that the smooth curve shape may depend on chart scaling (see ref in attachment).
Hi Lori_m
Your solution has two formulae which are not built into Excel xlfn._xlws.FILTER(_xlfn.ANCHORARRAY(C21);(_xlfn.ANCHORARRAY(C21)<=1)*(_xlfn.ANCHORARRAY(C21)>0);NOD())
How can a use you spreadsheet with my data?
Kind regards.
juanrq
Formulae which lori_m suggested shall work in Excel 365, 2021 or 2024. If only you don't edit file first in Google Sheets and after try to open in Excel (ANCHORARRAY says about that).
