In downloading bank account activity the "Reference" column has blanks or check numbers. I'm trying to scan that column and where the blank cells are in that column insert "Debit". And if the cell is NOT EMPTY (ie. there's a check number) do nothing (leave the check number and go on to the next cell in the column.) Please help me devise a formula. Thanks!
Thank you so much. Here is a screenshot of data. In this case the check number is the first data in the reference column. I'm missing something. I don't understand taking the formula down across the new column. Usually I can copy a formula, select all of the cells below that formula populated cell, and it adjusts and applies to all selected cells. But not in this case. What am I missing, please?
@Moonlander Try to 'Save as' the file in excel format (.xlsx) as suggested in the warning message and then copy the formula again. If you also look at cell B3 (in your screenshot) it's showing the same chkRef as appearing in B2 and it may be because of the format.
Alternatively you may share the file for modification at my end.