MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I want a summary sheet without the bad data


Posted by adam on May 21, 2001 9:37 AM

I have data set up like this


A B C
Adam Test Go
- - -
- - -
Bill Test Run
- - -


I want to have a new sheet that displays

A B C
Adam Test Go
Bill Test Run

Thanks,

Adam


Posted by Kevin James on May 21, 2001 10:50 AM

Hi Adam,

I've gotten stung too often not to ask first:
Is your "bad data" truly dashes?

If that is the case, why not just sort your data on the first column?

Kevin

Posted by Dave Hawley on May 21, 2001 11:49 PM


Hi Adam

Sorting would be my first option too. If however you cannot sort and your dashes are blanks.

Select the Columns, then push F5 click Special select Contstants and click Ok. Now copy and paste.

DaveOzGrid Business Applications