Forum Discussion

ahmedelmessery9's avatar
ahmedelmessery9
Copper Contributor
May 19, 2022
Solved

I have data of an irregular curve and I need to get the maximum value out of Excel.

excel
  • lori_m's avatar
    lori_m
    May 20, 2022

    ahmedelmessery9 

    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).

     

     

lori_m's avatar
lori_m
Iron Contributor
May 20, 2022

ahmedelmessery9 

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).

 

 

  • juanrq's avatar
    juanrq
    Copper Contributor
    Nov 09, 2024

    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

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 10, 2024

      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).

Resources