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 text in column A of a spreadsheet. The dates have blank cells below them and then reach a text component (total for transaction 1, 2, 3 etc) before another date is seen. Each change of date should have the corresponding date autopopulate below it until it reaches the next text in a cell. I am trying to copy the dates, based upon the last date changed but it isn't working. How do i get it to ignore all text in any cell and just populate the dates. The other issue I had was that the date was showing as 1900, even though the date format for the cell is selected.
Appreciate any ideas to reslove this.
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?
