S
smiling_smiler
Hi Guru's
first thing, I was just wondering I have a formula that goes through
list I have and pulls out every date that matches that criteria, howeve
this only goes down the row, do I just need to change the row to colum
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 twea
the formula so that it would skip that column and move onto the nex
column and pull through that data and once its searched through all th
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
first thing, I was just wondering I have a formula that goes through
list I have and pulls out every date that matches that criteria, howeve
this only goes down the row, do I just need to change the row to colum
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 twea
the formula so that it would skip that column and move onto the nex
column and pull through that data and once its searched through all th
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