Forum Discussion
EXCEL FORMULAS
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=IF(ISTEXT(A4),"",COUNT($A$4:A4))I can't see your screenshot. I'm not sure what you exactly want to do but if you want to return the result shown in my screenshot then you can try the above formula.
- Oliver, just testing to see if you get this. It stated my previous messages could not go through.