#### raymaster98

##### Board Regular

- Joined
- Oct 28, 2009

- Messages
- 212

Please forgive me, but I have made a similar post before on this topic, but I cannot seem to edit the formula to make it work today. In rows 3-5000 of column BP, I have formulas that return a list of patient names from another data source. There are many blank cells between each name. In cell CD3, I am looking for a formula to return the first non blank value (patient name) in that column. Then, I need to drag the formula down so that cell CD4 will return the second non blank cell (patient name) and so on. BTW, I need the solution to be automated (via formula) instead of a filter to "skip blanks". If it helps, I have pasted the formula that worked before on another workbook. Thanks, Kenny

=IF(INDEX($Z$2:$Z$10000,MATCH(<st1:stockticker w:st="on">TRUE</st1:stockticker>,$Z$2:$Z$10000<>"",0))=AM$2,IF(ROWS(AP$2:AP2)<=COUNTIF($AB$2:$AB$10000,"<>"),INDEX($AB$2:$AB$10000,SMALL(IF($AB$2:$AB$10000<>"",<st1:stockticker w:st="on">ROW</st1:stockticker>($AB$2:$AB$10000)-<st1:stockticker w:st="on">ROW</st1:stockticker>($AB$2)+1) ,ROWS(AP$2:AP2))),""))

with curly braces on each end