Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter 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. I need the Min in the whole list starting from A1 to H10. So when I start, and the whole chart is empty all values are zero. Then when I enter the first amount in A1 (lets say 10), then the whole row should be the same since it is the lowest in the row (other than zero). Then when I enter the next number in B1 (lest say 8), then the rest of the cells from C1 to H1 should have the 8. And when I enter a smaller amount in c1 the rest of the row should lower as well. This can't be done with a formaula, as the formula would get ereased when I enter an amount in that cell. The same should happen when I delete one amount, then thwe whole row should update with the smallest amount of that row, including the cell that was just deleted. Thanks for any help. Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter the smallest amount in row | Excel Programming | |||
Find the smallest amount | Excel Discussion (Misc queries) | |||
ENTER NEGATIVE AMOUNT | Excel Discussion (Misc queries) | |||
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) |