Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## Recreate Excel formula to locate smallest number in a table

ReluctantProgrammer
Level 1

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile

ReluctantProgrammer
Level 1

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile
ReluctantProgrammer
Level 1

01-07-2021

Looking for code to re-create this Excel formula which identifies the lowest number in a table column and places it in a different field.

="Single Unit:" &CHAR(10)& IF(COUNT(AB17:AB23)>0,TEXT(ROUNDDOWN(MIN(AB17:AB23),0),"0") & " tons",IF(COUNT(AB24:AB27)>0,TEXT(ROUNDDOWN(MAX(Z17:Z23),0),"0") & " tons",IF(AND(ISNUMBER(G28),ISNUMBER(G29),ISNUMBER(G30),ISNUMBER(G31),MIN(G28:G31)<1),"LL","n/a")))

#### Accepted Solutions (1)

Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

371 posts

107 solutions
View profile

Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

371 posts

107 solutions
View profile
Kosta_Prokopiu1
Employee

01-07-2021

If you make your table in a fitting way then it should be very easy:

And here the result:

Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

185 solutions
View profile

Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts