hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,224
- Office Version
- 2010
- Platform
- Windows
- Mobile
I have B2:B10 which are dynamic cells & keeps on UPDATING (based on time criteria)
Corresponding MAXIMUM & MINIMUM values required in E2:E10 & F2:F10
Code required to accomplish.
I am using Excel 2007.
Thanks in adv.
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 73px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
Corresponding MAXIMUM & MINIMUM values required in E2:E10 & F2:F10
Code required to accomplish.
I am using Excel 2007.
Thanks in adv.
Sheet1
B | C | D | E | F | |
1 | MAXIMUM | MINIMUM | |||
2 | 458.45 | 458.45 | 451.23 | ||
3 | 470.26 | 470.38 | 459.22 | ||
4 | 280.01 | 285.98 | 260.01 | ||
5 | 500 | 510.05 | 492.06 | ||
6 | 9999 | 10000 | 9874.2 | ||
7 | 2222 | 2255 | 2220 | ||
8 | 1111 | 1181 | 1111 | ||
9 | 1090 | 1090 | 1090 | ||
10 | 7755.33 | 775.33 | 7755.3 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 73px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>