If a criteria isn't met, move to the next line....

[Guest]

I have got a Vlookup formula:
=IF('Copied Data'!$A2=Names!$B$1,(VLOOKUP(Names!$B$1,'Copied
Data'!$A$2:$K$1110,COLUMN(A:K),0)),"")
If the criteria is met it shows the correct data, if it isn't met I have got
it to show a blank. The Trouble with this is that it I have lots of blank
rows on my spreadsheet.
How would I alter the formula so that there a no blank rows, so that all the
data is together.
Thanks for any help.
martin

 

[robert111]

one quick but clumsy way round this is to do what you have already don
and then run a pivot table on the 2 columns, this will skip blanks...

tom 3
ann
sue 5
fred 7
bill
dick 1

pivot will return only tom sue fred and dic

 

[Guest]

Hi robert, thanks for the response. I have already tried pivot tables but
unfortunantly I need to do other things with the data which a pivot table
can't do. Any other ideas?