Forum Discussion
Solved
EXCEL FORMULAS
I have a spreadsheet that I am trying to write a formula for and I can't seem to get it right. I was wondering if someone in the community could assist. Here is what I have. I have dates and te...
OliverScheurich thanks for reaching out Oliver. The dates are changing at the right moment but the blanks below each new date do not complete with the new date.
For example:
In Cell A6 I have the date 6/1/2023. The formula populated all of the dates in blank cells below that date and copied the text where it came after the populated dates. It recognized the next new date but then populated the original date 6/1/2023 below that date, and so on. See example below.
6/1/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 Total for transaction 10 7/12/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 Total for transaction 11 7/14/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 Total for transaction 12 6/30/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 6/1/2023 =IF(ISNUMBER(A6),A6,IF(ISBLANK(A6),B5,A6))This formula returns the intended results in my sheet starting with cell A6. Can you attach a screenshot which shows your worksheet along with the applied formula without sensitive data?
- Cant see screenshot when I paste it into the response. Can you see it? Looks like your formula is working for the dates. I also have numbers in another column. Can I use the same formula or does it need to be different? The data is below. Date in column A and Document in column B. You will note that Document number starts on the same line as date. I need to populate all of the cells with their corresponding number, so date 6/1/2023 has number one in Column B. It needs to copy down to row 8, 2nd number begins at row 10 as it shouldnt copy "Total for Transaction" into column B as this works in column A. The sequence repeats.
Date Document
6/1/2023 1
Total for transaction 1
7/1/2023 2
Total for transaction 2
8/1/2023 3
Total for transaction 3
9/1/2023 4
Total for transaction 4
