N
Neon520
Hi Everyone,
I have a small problem with the design of my worksheet about "Previous
Balance"
Here is the set up:
ROW1| | |Previous Bal.| $$$| <<< let's say: $25.00
ROW2|Date|Fee|Unit |Bal. |
ROW3|01/01/08|$2.00|5.00|=$10.00+$25.00(prev. bal.)|
ROW4|01/02/08|$3.00|3.00|=$9.00+$35.00(the row above)|
The problem I'm having is when I enable autofilter feature in Excel and
since the formula for the first row (01/01/08) need to pick up the Prev.
Balance from ROW1 and skip ROW2 as the header row, but the rest of the
formula need to pick up the balance in the row above it. When I do a sorting
in AutoFilter, the Formula will always mess up.
Can anyone suggest a different design, maybe, to avoid this sorting dilemma
with the formula?
Hope I explain myself correct. Thanks in advance.
Neon520
I have a small problem with the design of my worksheet about "Previous
Balance"
Here is the set up:
ROW1| | |Previous Bal.| $$$| <<< let's say: $25.00
ROW2|Date|Fee|Unit |Bal. |
ROW3|01/01/08|$2.00|5.00|=$10.00+$25.00(prev. bal.)|
ROW4|01/02/08|$3.00|3.00|=$9.00+$35.00(the row above)|
The problem I'm having is when I enable autofilter feature in Excel and
since the formula for the first row (01/01/08) need to pick up the Prev.
Balance from ROW1 and skip ROW2 as the header row, but the rest of the
formula need to pick up the balance in the row above it. When I do a sorting
in AutoFilter, the Formula will always mess up.
Can anyone suggest a different design, maybe, to avoid this sorting dilemma
with the formula?
Hope I explain myself correct. Thanks in advance.
Neon520