Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter the smallest amount in row
Hello:
I would like to have a code that enters the smallest number on a row to the rest of the row. So lets say I use the range from A1 to H10. I want that for row 1 if it has in A1 the value 253 and in B1 the value 219 and in C1 the value 198, so the rest of that row (until H1) should have the value 198. And when I'll enter the value 153 in D1, then all the rest after D1 should update to 153 and so on. This should occur in each row in the range. I usually enter the amounts from left to right in the range. Thanks for any help. Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the smallest amount | Excel Discussion (Misc queries) | |||
ENTER NEGATIVE AMOUNT | Excel Discussion (Misc queries) | |||
when I enter an amount in the A column move the row to another she | Excel Worksheet Functions | |||
How do I see the amount in words (I will enter amount in numbers) | Excel Programming | |||
How do I enter a negative dollar amount? | Excel Discussion (Misc queries) |