multiple cell addesses

[Ehtau]

I have a large spreadsheet with about 2,000 blank cells. I need the addresses for all of the cells. For Example: in the screenshot below, I would like a formula that would return: B2,B6,B9,C5,C6,C10,D5,D10....etc. Is this possible?

 

[deciog]

Ehtau

My contribution

Decio

 

[deciog]

Ehtau

Correcting the formula to show correct address

Decio

 

[Ehtau]

Perfect! Thank you.

 

[bosco_yip]

One formula way for multi-column blank cells address.

1] In K2, array formula (CSE formula) copy down :

=IFERROR(ADDRESS(MID(SMALL(IF($B$2:$I$20=0,ROW($2:$20)/1%+{2,3,4,5,6,7,8,9}*10001),ROW(B1)),2,2),RIGHT(SMALL(IF($B$2:$I$20=0,ROW($2:$20)/1%+{2,3,4,5,6,7,8,9}*10001),ROW(B1)),2)),"")

2] Please refer to attachment

Regards
Bosco