CODEWITHSUNDEEP
excelexcel-formula
Fighter Jet
Fighter Jet

Reputation: 407

Excel Formula: Minimum value of an array containing strings

Example:

=MIN({"510";"515";"503";"";"";""})

How to get the min value of this array from non-empty items. Item 503 to be the minimum here and is the answer.

Upvotes: 1

Views: 373

Answers (2)

Harun24hr
Harun24hr

Reputation: 36870

You may try-

=MIN(IFERROR(--{"510","515","503","","",""},""))

-- enforce strings to convert numbers if they are digits only. IFERROR will convert errors for empty string to nulls so that MIN function ignore those.

Note: comma , and semicolon ; depends on regional settings.

enter image description here

Upvotes: 2

Monofuse
Monofuse

Reputation: 827

If your string will only contain number, you could do:

=MIN(NUMBERVALUE(A1:E1))

Upvotes: 2

Related Questions