What is the best way to do the following...
You have a list of numbers, let's say vertically in Excel
Next to it you have calculation like formula of B2 = A2/A1
You copy this formula down as far as your list goes.
Now... some entries in your list are blank. If it's only one entry at a time (non-contiguous blanks) it's easy to put an IF clause around this in entries past B2, for example: B3's formula would be IF(ISBLANK(A2),A3/A1,A3/A2)
However, the IFs required to handle any number of contiguous blanks becomes overly complex. Is there another way to say: do this operation on the most recent non-blank cell in column/row A?
Thanks in advance,
Vesc
You have a list of numbers, let's say vertically in Excel
Next to it you have calculation like formula of B2 = A2/A1
You copy this formula down as far as your list goes.
Now... some entries in your list are blank. If it's only one entry at a time (non-contiguous blanks) it's easy to put an IF clause around this in entries past B2, for example: B3's formula would be IF(ISBLANK(A2),A3/A1,A3/A2)
However, the IFs required to handle any number of contiguous blanks becomes overly complex. Is there another way to say: do this operation on the most recent non-blank cell in column/row A?
Thanks in advance,
Vesc