# Find value minimum & maximum if

#### Kishan

##### Well-known Member
Hello To All,</SPAN></SPAN>

I want to find min And max value of the rows, for example in row 2 cells A2:R2 showed 3 values in green which are 24, 10, & 8 they have 1 below in row 3 which is shown in red so far min or row 2 I need 8 and max of row 2 I need 24, is it possible to find with formula.</SPAN></SPAN>

 A B C D E F G H I J K L M N O P Q R S T U 1 Datas Empty Min Max 2 4 24 9 5 13 13 15 1 7 10 3 9 12 16 7 8 5 4 8 24 3 5 1 10 6 14 14 16 2 8 1 4 10 2 17 8 1 6 5 10 14 4 6 26 1 7 15 1 17 3 9 2 5 11 3 18 9 10 7 6 3 9 5 7 27 2 8 16 2 18 1 1 3 6 12 4 19 10 11 8 7 7 12 6 1 28 3 9 17 3 19 2 2 4 7 1 5 20 11 12 9 1 9 17 7 9 29 4 1 1 4 20 3 3 5 8 14 6 21 1 13 10 9 1 10 8 6 5 7 9 9 12 28 1 11 13 5 2 4 29 1 3 1 17 5 29 9 7 1 8 1 10 13 29 2 12 14 6 3 5 1 2 4 2 18 5 29 10 8 2 9 2 11 14 1 3 13 15 7 4 1 2 3 5 3 19 7 11 11 9 3 10 3 1 15 31 4 14 16 1 5 2 3 4 6 4 20 4 10 12 10 4 1 4 2 16 32 12 15 17 2 6 3 4 1 7 1 21

<TBODY>
</TBODY>

Kishan</SPAN></SPAN>

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hello To All,</SPAN></SPAN>

This is my attempt to post data in there original format.</SPAN>
 A B C D E F G H I J K L M N O P Q R S T U 1 Datas Empty Min Max 2 4 24 9 5 13 13 15 1 7 10 3 9 12 16 7 8 5 4 8 24 3 5 1 10 6 14 14 16 2 8 1 4 10 2 17 8 1 6 5 10 14 4 6 26 1 7 15 1 17 3 9 2 5 11 3 18 9 10 7 6 3 9 5 7 27 2 8 16 2 18 1 1 3 6 12 4 19 10 11 8 7 7 12 6 1 28 3 9 17 3 19 2 2 4 7 1 5 20 11 12 9 1 9 17 7 9 29 4 1 1 4 20 3 3 5 8 14 6 21 1 13 10 9 1 10 8 6 5 7 9 9 12 28 1 11 13 5 2 4 29 1 3 1 17 5 29 9 7 1 8 1 10 13 29 2 12 14 6 3 5 1 2 4 2 18 5 29 10 8 2 9 2 11 14 1 3 13 15 7 4 1 2 3 5 3 19 7 11 11 9 3 10 3 1 15 31 4 14 16 1 5 2 3 4 6 4 20 4 10 12 10 4 1 4 2 16 32 12 15 17 2 6 3 4 1 7 1 21

<TBODY>
</TBODY>

</SPAN>

Kishan</SPAN></SPAN>

Sheet1

 * A B C D E F G H I J K L M N O P Q R S T U 1 Datas Empty * * * * * * * * * * * * * * * * * Min Max 2 4 24 9 5 13 13 15 1 7 10 3 9 12 16 7 8 5 4 * 8 24 3 5 1 10 6 14 14 16 2 8 1 4 10 2 17 8 1 6 5 * 10 14 4 6 26 1 7 15 1 17 3 9 2 5 11 3 18 9 10 7 6 * 3 9 5 7 27 2 8 16 2 18 1 1 3 6 12 4 19 10 11 8 7 * 7 12 6 1 28 3 9 17 3 19 2 2 4 7 1 5 20 11 12 9 1 * 9 17 7 9 29 4 1 1 4 20 3 3 5 8 14 6 21 1 13 10 9 * 1 10 8 6 5 7 9 9 12 28 1 11 13 5 2 4 29 1 3 1 17 * 5 29 9 7 1 8 1 10 13 29 2 12 14 6 3 5 1 2 4 2 18 * 5 29 10 8 2 9 2 11 14 1 3 13 15 7 4 1 2 3 5 3 19 * 7 11 11 9 3 10 3 1 15 31 4 14 16 1 5 2 3 4 6 4 20 * 4 10 12 10 4 1 4 2 16 32 12 15 17 2 6 3 4 1 7 1 21 * * *

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

 Cell Formula T2 {=MIN(IF(\$A3:\$R3=1,\$A2:\$R2))} U2 {=MAX(IF(\$A3:\$R3=1,\$A2:\$R2))} T3 {=MIN(IF(\$A4:\$R4=1,\$A3:\$R3))} U3 {=MAX(IF(\$A4:\$R4=1,\$A3:\$R3))}

<tbody>
</tbody>
Formula Array:
Produce enclosing
{ } by entering
formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thank you Robert Mika, for your help formula is giving ideal result.<o></o>
Regards,<o></o>
Kishan<o></o>

You are welcome. Thanks for feedback.

Replies
1
Views
380
Replies
0
Views
768
Replies
0
Views
981
Replies
3
Views
247
Replies
0
Views
301

1,212,144
Messages
6,106,218
Members
448,006
Latest member
oreo2996

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back