Find value minimum & maximum if

K

Kishan

Well-known Member
Joined
Mar 15, 2011
Messages
1,648
Office Version
  1. 2010
Platform
  1. Windows
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</SPAN></SPAN>
B</SPAN></SPAN>
C</SPAN></SPAN>
D</SPAN></SPAN>
E</SPAN></SPAN>
F</SPAN></SPAN>
G</SPAN></SPAN>
H</SPAN></SPAN>
I</SPAN></SPAN>
J</SPAN></SPAN>
K</SPAN></SPAN>
L</SPAN></SPAN>
M</SPAN></SPAN>
N</SPAN></SPAN>
O</SPAN></SPAN>
P</SPAN></SPAN>
Q</SPAN></SPAN>
R</SPAN></SPAN>
S</SPAN></SPAN>
T</SPAN></SPAN>
U</SPAN></SPAN>
1</SPAN></SPAN>
Datas</SPAN></SPAN>
Empty</SPAN>
Min</SPAN></SPAN>
Max</SPAN>
2</SPAN></SPAN>
4</SPAN></SPAN>
24</SPAN></SPAN>
9</SPAN></SPAN>
5</SPAN></SPAN>
13</SPAN></SPAN>
13</SPAN></SPAN>
15</SPAN></SPAN>
1</SPAN>
7</SPAN></SPAN>
10</SPAN></SPAN>
3</SPAN></SPAN>
9</SPAN></SPAN>
12</SPAN></SPAN>
16</SPAN></SPAN>
7</SPAN></SPAN>
8</SPAN></SPAN>
5</SPAN></SPAN>
4</SPAN></SPAN>
8</SPAN></SPAN>
24</SPAN></SPAN>
3</SPAN></SPAN>
5</SPAN></SPAN>
1</SPAN>
10</SPAN></SPAN>
6</SPAN></SPAN>
14</SPAN></SPAN>
14</SPAN></SPAN>
16</SPAN></SPAN>
2</SPAN></SPAN>
8</SPAN></SPAN>
1</SPAN>
4</SPAN></SPAN>
10</SPAN></SPAN>
2</SPAN></SPAN>
17</SPAN></SPAN>
8</SPAN></SPAN>
1</SPAN>
6</SPAN></SPAN>
5</SPAN></SPAN>
10</SPAN></SPAN>
14</SPAN></SPAN>
4</SPAN></SPAN>
6</SPAN></SPAN>
26</SPAN></SPAN>
1</SPAN>
7</SPAN></SPAN>
15</SPAN></SPAN>
1</SPAN>
17</SPAN></SPAN>
3</SPAN></SPAN>
9</SPAN></SPAN>
2</SPAN></SPAN>
5</SPAN></SPAN>
11</SPAN></SPAN>
3</SPAN></SPAN>
18</SPAN></SPAN>
9</SPAN></SPAN>
10</SPAN></SPAN>
7</SPAN></SPAN>
6</SPAN></SPAN>
3</SPAN></SPAN>
9</SPAN></SPAN>
5</SPAN></SPAN>
7</SPAN></SPAN>
27</SPAN></SPAN>
2</SPAN></SPAN>
8</SPAN></SPAN>
16</SPAN></SPAN>
2</SPAN></SPAN>
18</SPAN></SPAN>
1</SPAN>
1</SPAN>
3</SPAN></SPAN>
6</SPAN></SPAN>
12</SPAN></SPAN>
4</SPAN></SPAN>
19</SPAN></SPAN>
10</SPAN></SPAN>
11</SPAN></SPAN>
8</SPAN></SPAN>
7</SPAN></SPAN>
7</SPAN></SPAN>
12</SPAN></SPAN>
6</SPAN></SPAN>
1</SPAN>
28</SPAN></SPAN>
3</SPAN></SPAN>
9</SPAN></SPAN>
17</SPAN></SPAN>
3</SPAN></SPAN>
19</SPAN></SPAN>
2</SPAN></SPAN>
2</SPAN></SPAN>
4</SPAN></SPAN>
7</SPAN></SPAN>
1</SPAN>
5</SPAN></SPAN>
20</SPAN></SPAN>
11</SPAN></SPAN>
12</SPAN></SPAN>
9</SPAN></SPAN>
1</SPAN>
9</SPAN></SPAN>
17</SPAN></SPAN>
7</SPAN></SPAN>
9</SPAN></SPAN>
29</SPAN></SPAN>
4</SPAN></SPAN>
1</SPAN>
1</SPAN>
4</SPAN></SPAN>
20</SPAN></SPAN>
3</SPAN></SPAN>
3</SPAN></SPAN>
5</SPAN></SPAN>
8</SPAN></SPAN>
14</SPAN></SPAN>
6</SPAN></SPAN>
21</SPAN></SPAN>
1</SPAN>
13</SPAN></SPAN>
10</SPAN></SPAN>
9</SPAN></SPAN>
1</SPAN></SPAN>
10</SPAN></SPAN>
8</SPAN></SPAN>
6</SPAN></SPAN>
5</SPAN></SPAN>
7</SPAN></SPAN>
9</SPAN></SPAN>
9</SPAN></SPAN>
12</SPAN></SPAN>
28</SPAN></SPAN>
1</SPAN>
11</SPAN></SPAN>
13</SPAN></SPAN>
5</SPAN></SPAN>
2</SPAN></SPAN>
4</SPAN></SPAN>
29</SPAN></SPAN>
1</SPAN>
3</SPAN></SPAN>
1</SPAN>
17</SPAN></SPAN>
5</SPAN></SPAN>
29</SPAN></SPAN>
9</SPAN></SPAN>
7</SPAN></SPAN>
1</SPAN>
8</SPAN></SPAN>
1</SPAN>
10</SPAN></SPAN>
13</SPAN></SPAN>
29</SPAN></SPAN>
2</SPAN></SPAN>
12</SPAN></SPAN>
14</SPAN></SPAN>
6</SPAN></SPAN>
3</SPAN></SPAN>
5</SPAN></SPAN>
1</SPAN>
2</SPAN></SPAN>
4</SPAN></SPAN>
2</SPAN></SPAN>
18</SPAN></SPAN>
5</SPAN></SPAN>
29</SPAN></SPAN>
10</SPAN></SPAN>
8</SPAN></SPAN>
2</SPAN></SPAN>
9</SPAN></SPAN>
2</SPAN></SPAN>
11</SPAN></SPAN>
14</SPAN></SPAN>
1</SPAN>
3</SPAN></SPAN>
13</SPAN></SPAN>
15</SPAN></SPAN>
7</SPAN></SPAN>
4</SPAN></SPAN>
1</SPAN>
2</SPAN></SPAN>
3</SPAN></SPAN>
5</SPAN></SPAN>
3</SPAN></SPAN>
19</SPAN></SPAN>
7</SPAN></SPAN>
11</SPAN></SPAN>
11</SPAN></SPAN>
9</SPAN></SPAN>
3</SPAN></SPAN>
10</SPAN></SPAN>
3</SPAN></SPAN>
1</SPAN>
15</SPAN></SPAN>
31</SPAN></SPAN>
4</SPAN></SPAN>
14</SPAN></SPAN>
16</SPAN></SPAN>
1</SPAN>
5</SPAN></SPAN>
2</SPAN></SPAN>
3</SPAN></SPAN>
4</SPAN></SPAN>
6</SPAN></SPAN>
4</SPAN></SPAN>
20</SPAN></SPAN>
4</SPAN></SPAN>
10</SPAN></SPAN>
12</SPAN></SPAN>
10</SPAN></SPAN>
4</SPAN></SPAN>
1</SPAN>
4</SPAN></SPAN>
2</SPAN></SPAN>
16</SPAN></SPAN>
32</SPAN></SPAN>
12</SPAN></SPAN>
15</SPAN></SPAN>
17</SPAN></SPAN>
2</SPAN></SPAN>
6</SPAN></SPAN>
3</SPAN></SPAN>
4</SPAN></SPAN>
1</SPAN>
7</SPAN></SPAN>
1</SPAN>
21</SPAN></SPAN>



<TBODY>
</TBODY>

Please help</SPAN></SPAN>

Thanks In Advance,</SPAN></SPAN>
Kishan</SPAN></SPAN>
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Hello To All,</SPAN></SPAN>

This is my attempt to post data in there original format.</SPAN>
ABCDEFGHIJKLMNOPQRSTU
1DatasEmptyMinMax
24249513131517103912167854 824
3511061414162814102178165 1014
4626171511739251131891076 39
57272816218113612419101187 712
6128391731922471520111291 917
7929411420335814621113109 110
8657991228111135242913117 529
9718110132921214635124218 529
1082921114131315741235319 711
11931031153141416152346420 410
121041421632121517263417121

<TBODY>
</TBODY>

</SPAN>

Thanks In Advance,</SPAN></SPAN>
Kishan</SPAN></SPAN>
 
Upvote 0
Sheet1

*ABCDEFGHIJKLMNOPQRSTU
1Datas Empty *****************Min Max
24249513131517103912167854*824
3511061414162814102178165*1014
4626171511739251131891076*39
57272816218113612419101187*712
6128391731922471520111291*917
7929411420335814621113109*110
8657991228111135242913117*529
9718110132921214635124218*529
1082921114131315741235319*711
11931031153141416152346420*410
121041421632121517263417121***

<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>

Spreadsheet Formulas
CellFormula
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
 
Upvote 0
Thank you Robert Mika, for your help formula is giving ideal result.<o:p></o:p>
Regards,<o:p></o:p>
Kishan<o:p></o:p>
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Help i can't found the xpath to continue
Replies
3
Views
184
ptcsite46
P
E
  • Question
Adding a custom message.
Replies
1
Views
426
Micron
M
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
819
gvsumich
G
M
  • Question
VBA to open website and download a file
Replies
0
Views
1K
Martin sherk
M
B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
179
bh24524
B

Forum statistics

Threads
1,214,792
Messages
6,121,612
Members
449,038
Latest member
apwr

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top