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

4 Replies

  • 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