J
Jeff
I want to place a formula in a cell to find the first cell
it can with data.
For example, I have each day of a month listed in rows A1
to A31 as 7/1/2003...7/31/2003. On weekdays data will
populate in column B but weekends and holdays cells in B
will be empty. In column C I want to place the value in
cell B from the line above. So if I am in cell C5 it
should read -(B4) but if A5 were a holiday or weekend B5
would be blank and therefore cell C5 should be blank.
I would like a formula to automatically look for the first
cell in column B5 ABOVE it that has data and place it in.
SO for example 7/7/03 is on row 7 needs to pull data from
B3 and place in C7, I have tried statements with if and
find but can not sem to figure out what would work.
If anyone knows I would appreciate it.
it can with data.
For example, I have each day of a month listed in rows A1
to A31 as 7/1/2003...7/31/2003. On weekdays data will
populate in column B but weekends and holdays cells in B
will be empty. In column C I want to place the value in
cell B from the line above. So if I am in cell C5 it
should read -(B4) but if A5 were a holiday or weekend B5
would be blank and therefore cell C5 should be blank.
I would like a formula to automatically look for the first
cell in column B5 ABOVE it that has data and place it in.
SO for example 7/7/03 is on row 7 needs to pull data from
B3 and place in C7, I have tried statements with if and
find but can not sem to figure out what would work.
If anyone knows I would appreciate it.