If entire column is blank, then

I'm assuming this is the thread that you are referring to.

I'll try to do this without seeing a sample.

Try this:
=IFERROR(1/(1/MIN(IF((B2:B8="SAT")+(B2:B8="PART"),C2:C8))),"") Ctrl Shift Enter

.
Here is a macro approach for copying terms in Col A, from row 2:20. Adjust range as required.

Please Login or Register  to view this content.

Or using Aggregate

Formula:

Please Login or Register  to view this content.

(this is an update to thread https://www.excelforum.com/excel-for...me-column.html)

Originally Posted by 63falcondude

I'm assuming this is the thread that you are referring to.

I'll try to do this without seeing a sample.

Try this:
=IFERROR(1/(1/MIN(IF((B2:B8="SAT")+(B2:B8="PART"),C2:C8))),"") Ctrl Shift Enter

I've edited to add a sample. Maybe you can help with my ultimate goal of getting a valid start date from either tab. The only way I've been able to do that is by building a formula on the Main tab to pull a date from the Chart2 tab, which is highlighted in yellow, and then build another formula to pull the Start Date, shown in red in cell G2 from all the results. As you will see, since Chart2 has no dates that meet the criteria of "PSAT" it returns "01/00/00" Which my start date formula reads as the earliest date. I'd prefer if I didn't have to transfer the date from the Chart2 tab, but I haven't been able to figure out how. I could probably change the data in cell E2 to an =IF(D2="0","","PSAT"), but given this record will be used by many people I can forsee too many formulas relying on each other getting messed up without my knowledge later down the road.

Originally Posted by Logit

.
Here is a macro approach for copying terms in Col A, from row 2:20. Adjust range as required.

I would love to be able to use a macro approach, but our firewall will not allow me to send it out.

Hi
Try this

Formula:

Please Login or Register  to view this content.

See the file

That appears to work, although I'm very unfamiliar with the aggregate formula. Always something new to learn with spreadsheets. Thank you.

You are welcome.

Thank you for the rep.