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):
=IF(INT(A2/0.5)=A2/0.5,A2,0)

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

Hope this helps you out.

Regards,
Barrie