CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Christian
Christian

Reputation: 3

Find Each Instance - Return Column Header in Excel

enter image description here

How do I return the first time I emailed each customer by date? For example, I want B3 to read "20-May-13" C3 to read "02-Oct-15" and D3 to read "26-May-16".

Thanks!

Upvotes: 0

Views: 41

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use this formula in B3, then copy over and down:

=IFERROR(INDEX($G$2:$K$2,AGGREGATE(15,6,(COLUMN($G3:$K3)-COLUMN($G3)+1)/($G3:$K3=1),COLUMN(A:A))),"")

enter image description here

If your column header is a true date then you can use this formula:

=IFERROR(AGGREGATE(15,6,$G$2:$K$2/($G3:$K3=1),COLUMN(A:A)),"")

Upvotes: 1

Related Questions