Find Empty cell enter value then continue to next

[CrashOD]

Find First Empty cell in range A:A (say does end A10) and count only the none Empty cells and enter value to B1.
Then continues down (Say Ends A22) and count only the none Empty cells and enter value to B2.
Ect. Till end of book.
So for this B1 would have 9 since A10 is empty and B2 would have 11 since A11 - A21 have data.

Thanks so much!

 

[shaowu459]

=IF(B4<>"", '[2022 - ECT - Real Estate - Copy.xls]RPT 1'!A("B4"+2,1), "")
NAME ERROR.

try this one:

=IF(B3<>"",INDEX( '[2022 - ECT - Real Estate - Copy.xls]RPT 1'!A:A,B3+3), "")

!A(B3+3) is not a recognised cell reference in excel.

 

[CrashOD]

thanks worked for two cells but now just showing me the code.

I changed the format to the same as the ones that are working. still no luck.

 

[shaowu459]

thanks worked for two cells but now just showing me the code.

I changed the format to the same as the ones that are working. still no luck.

after set the format, select column A, Ctrl+H, enter = in the first textbox and enter = in the bottom textbox, click replace all.

 

[CrashOD]

Thank you very much. I have other Excel worksheets that kept just showing me the code and I could not figure out why but I never thought about doing a replace. I would end up just redoing the whole entire workbook again and hopes that the command wouldn't show. Lol so I wasted hours upon hours and days redoing books when I get adjusted that. Lol.

All right now all I got to do is get the first code that you helped me with to get the total of the non blank cells. To show if a letter D is above the blank row. Once I end up figuring that out I can modify the code first the letter F or P is above it for the other columns.

 

[CrashOD]

=LET(t,FREQUENCY(IF('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005="D",ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005)),IF('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005="",ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005))),FILTER(t,t))
brings value if letter D
so how do i get it to look a B3 and if B3 is empty it runs =LET(t,FREQUENCY(IF('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005="F",ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005)),IF('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005="",ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005))),FILTER(t,t))

i tried
=LET(t,FREQUENCY(IF(B3<>"",'[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005,ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005)),IF('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005="",ROW('[2022 - ECT - Real Estate - Copy.xls]RPT 1'!D2:D1005))),FILTER(t,t))
i get a #calc! error and when copy code all the way down shows 0