finding the earliest date in an array of cells

B

Buck

I have one column with various dates.....lets say B2:B20. The next column
(C2:c20) with values such as 1, 4, 8, etc. I am trying to calculate the
earliest date with a value in the same row that is > 0. So if B5 has the
earliest date, but the value of C5 is 0, I do not want that date.
 
G

Glenn

Buck said:
I have one column with various dates.....lets say B2:B20. The next column
(C2:c20) with values such as 1, 4, 8, etc. I am trying to calculate the
earliest date with a value in the same row that is > 0. So if B5 has the
earliest date, but the value of C5 is 0, I do not want that date.
Click to expand...


Array formula (commit with CTRL+SHIFT+ENTER):

=MIN(IF(C2:C20>0,B2:B20,""))

Make sure to format the cell as date.
 
G

Glenn

Buck said:
I have one column with various dates.....lets say B2:B20. The next column
(C2:c20) with values such as 1, 4, 8, etc. I am trying to calculate the
earliest date with a value in the same row that is > 0. So if B5 has the
earliest date, but the value of C5 is 0, I do not want that date.
Click to expand...


Array formula (commit with CTRL+SHIFT+ENTER):

=MIN(IF(C2:C20>0,B2:B20,""))

Make sure to format the cell as date.
 
G

Gary''s Student

=MIN(IF(C2:C20<>"",B2:B20,""))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
 
G

Gary''s Student

=MIN(IF(C2:C20<>"",B2:B20,""))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
 

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 find the earliest date when using an IF function? 5
Looking for the earliest/latest date in a column 3
Min Year in an Array 3
Finding the earliest date from a range of cells 2
finding earliest date within a range by employee 4
How do I find the earliest dates in a range of dates? 3
Find the earliest date in a range of dates? 2
Finding min date value with hidden zeros with vlookup 4

Top