MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need to find a quicker way to delete excess data

Posted by Brent on July 09, 2001 11:47 AM

I have some data from an experiment in .05 second incriments. However, I only need .5 second incriments and i need a way to delete all the excess information in between each .5 second incriment, which includes a row of information for each .05 second. I have tried filters but can't seem to get them to work. Please help immediately. Thank you.

Posted by Barrie Davidson on July 09, 2001 12:04 PM

Brent, how about using the following formula to filter your data (assumes your time values are in cell A2):

Copy this formula down to the bottom of your data and then filter on values not equal to zero.

Hope this helps you out.