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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - highest value in a Row, that begins with "21" or "28" (https://www.excelbanter.com/excel-programming/290669-highest-value-row-begins-21-28-a.html)

Fritz Zwiefelhofer

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

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.

Frank Kabel

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

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

Fritz Zwiefelhofer wrote:
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.

All times are GMT +1. The time now is 10:49 AM.