ExcelBanter - Excel Formulas

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/183641-excel-formulas.html)

Bradbell

Excel Formulas

What formula would I use to find the highest alphabetical character in a row?

Jim Thomlinson

Excel Formulas

Define Highest. The value closest to a or to z???
--
HTH...

Jim Thomlinson

"Bradbell" wrote:

What formula would I use to find the highest alphabetical character in a row?

Bradbell

Excel Formulas

Highest meaning the closest to Z

"Jim Thomlinson" wrote:

Define Highest. The value closest to a or to z???
--
HTH...

Jim Thomlinson

"Bradbell" wrote:

What formula would I use to find the highest alphabetical character in a row?

Gord Dibben

Excel Formulas

Characters in row 1

In A2 enter =CODE(A1)

Copy/drag across.

In A3 enter =MAX(2:2)

Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 09:35:04 -0700, Bradbell
wrote:

Highest meaning the closest to Z

"Jim Thomlinson" wrote:

Define Highest. The value closest to a or to z???
--
HTH...

Jim Thomlinson

"Bradbell" wrote:

What formula would I use to find the highest alphabetical character in a row?

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