How to find the address of an arbitrary empty cell?

Question

css

Given a table of arbitrary sizes (not a row or a column).
We need a formula for finding an arbitrary empty cell in it.
The difficulty lies in the fact that this must be done without iterators and without macros and scripts (VBA), which means that the cycle cannot be done, or I do not know all the functionality of Excel

=IF(ISBLANK(INDIRECT(ADDRESS(ROW(A1)+RANDOMBETWEEN(0,ROW(A1:N14)-1),COLUMN(A1)+RANDOMBETWEEN(0,COLUMN(A1:N14)-1),4)) );ADDRESS(ROW(A1)+RANDOMBETWEEN(0;ROW(A1:N14)-1);COLUMN(A1)+RANDOMBETWEEN(0;COLUMN(A1:N14)-1);4); "busy")

This formula checks a random cell, if it is not free, it writes "busy". This doesn't work, and it's impossible to loop without an error because the iterator is disabled

Answer 1

From round small labels you make large tabs and insert text there.
Will ride with any slider.

Answer 2

In Google tables, you can use FLATTEN () + MATCH () - expand into a flat array and look for an empty cell there, and then, if necessary, translate the position into an address or coordinates. In Excel 365, something similar was also recently introduced.