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...
=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
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.
Hi Andrew, yes i've received this message. No other messages have been delivered since my last post however.