![]() |
|
#1
|
|||
|
|||
![]()
Thank you for the assistance
here is what I have come up with ...what do you think 1. Copy data to a new sheet and remove unneeded columns 2. Create a helper column and insert this code in the first cell of the helper column. 3. =(Mod(Minute(cell#), xx)) where "xx" = the number of minutes to filter by eg.. 5 or 10 or …. 4. Copy the formula down to the last row 5. Select all of the data rows 6. Select filter from the data menu 7. From the drop down arrows on the helper column select number filters > does not equal 8. In the box next to the "does not equal" enter “0” and select OK 9. Right click in the middle of the data and select delete rows. 10. You will now be left with only the rows containing the minutes selected. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
roderh | Excel Programming | 2 | 09-06-2015 08:54 PM |
Automatically Delete Slides based on current time | Pacman52 | PowerPoint | 2 | 07-16-2015 05:30 AM |
![]() |
dharani suresh | Excel Programming | 5 | 04-29-2014 03:25 AM |
Looking for an add-in or a way to send automatic replies based off a list | brady | Outlook | 0 | 04-19-2013 01:21 PM |
![]() |
akraw | Word | 3 | 03-26-2011 08:29 PM |