how do you ignore blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a formula that results in the earliest date but a blank
cell results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to this formula to ignore blank cells
 
This is the idea. Modify this array formula to suit your needs. An array
formula must be entered/edited using control+shift+enter vs just enter

=MIN(IF(A1:A10>0,A1:A10))
 
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

how do you ignore blank cells in formulas 2
Formula help 2
Help me with this 4
Excel Concatenate with line breaks but ignore blank cells 3
ignoring blank cells 17
How To Have A Cell Be Blank If... 2
ignore cells that are blank 4
Ignore blank celss in left function 2

Back
Top