Hi Everyone
I am trying to combine these formulas into one.
=IF(ISERROR(OFFSET($W$3,MATCH(SMALL($Z$3:$Z$1000,ROW()-ROW($AM$3)+1),$Z$3:$Z$1000,0)-1,0)),"",OFFSET($W$3,MATCH(SMALL($Z$3:$Z$1000,ROW()-ROW($AM$3)+1),$Z$3:$Z$1000,0)-1,0))
{=IFERROR(INDEX($AM$3:$AM$1000,SMALL(IF(ISTEXT($AM$3:$AM$1000),ROW($AM$3:$AM$1000)-ROW($AN$3)+1),ROWS($AM$3:$AM3))),"")}
The first formula looks to see if there is a yes in the column (W) and then if so returns the offset email address in another column (Z).
The second formula then strips the empty cells from the results so the email addresses are one after the other in the column.
Many Thanks
Scott
Bookmarks