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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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?
 
Back
Top