Selecting empty cells

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Is there a function that will select only the empty cells
in a range, say in a column? As always, thanks a lot.

Mike
 
Hi Mike
what are you trying to do with that information? Depending on this a
formula could be easily achieved. e.g.
=MIN(IF(ISBLANK(A1:A100),ROW(A1:A100))

will return the row number from the first blank cell (entered as array
formula)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
want to track time while paste value in multiple column of same roe 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA range selection question 24
Insert selected cell value into next cell in range that is empty 6
Find cell address of last cell in a column with text 8
help with Conditional formatting pairs of cells 1

Back
Top