Hi Guru's

first thing, I was just wondering I have a formula that goes through a list I have and pulls out every date that matches that criteria, however this only goes down the row, do I just need to change the row to column to make it work???

the formula is - =IFERROR(INDEX($A:$A,SMALL(IF($C:$C='D2,ROW('$A:$A )),COLUMN(A1))),"")

second thing is, if the data in the column is blank, how would I tweak the formula so that it would skip that column and move onto the next column and pull through that data and once its searched through all the columns and pulled through the data, then to move onto the next row?

Hope its not confusing.

Any help or ideas would be greatly appreciated.

Many thanks in advanced.