highest value in a Row, that begins with "21" or "28"

  • Thread starter Thread starter Fritz Zwiefelhofer
  • Start date Start date
F

Fritz Zwiefelhofer

hello !

I have an ExcelSheet,
in Row "A:A" with numbers beginning at "21xxxx"
also are there numbers beginning at "28xxxx"

in one cell, I want to get the highest value, beginning with "21"
in another, I want to get the highest value, beginning with "28"


who can help me ??

thanks
Fritz Z.
 
Hi Fritz
one way: enter the following array formula (CTRL+SHIFT+ENTER):
=MAX(IF(LEFT(A1:A1000,2)="21",A1:A1000,0))
and
=MAX(IF(LEFT(A1:A1000,2)="28",A1:A1000,0))

Frank
 
Back
Top