1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Determine the maximum alphanumeric value in a range

    From David Cuthill@21:1/5 to All on Fri Sep 8 12:54:41 2023
    I have a column of alphanumeric data and want to determine the maximum value in the range but only for values within the range that have a prefix of "EP".

    I have been able to develop this which gives me the maximum alphanumeric but cannot figure out how to filter for only the EP prefix. The data is currently in the static column of I6 to I26 but the lower range could extend beyond row 26 in future.

    =LOOKUP(2,1/(COUNTIF(I6:I26,">"&I6:I26)=0),I6:I26)

    any guidance would be appreciated. Thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)