Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Excel 2007 [Square Brackets] used to represent a Cell. They do not exist
in the data of the cell. I have a column spreadsheet that has 15K records. IN column "G" all records have a date/tame like [2008-12-03 09:54:08.100]. What I need to do is search through that column to the end of the file and find any gaps that may be 5 minutes or longer and highlight that row. So the above, I need to search 09:54 and see if the next row has 09:59 or greater. If so highlight the row, if not move down one row and do the same check. I'm looking to see if the row below is equal to or greater than a 5 minute difference from the cell above. Does this make any sense? I am aware I will most likely need to do this in code. I am using Excel 2007, and am somewhat familiar with modules, but have not worked with them for a few years. Seems like I need a do until End of file and a for each loop, but just a little lost on the details. Just got Excel 2007, so it's new. I also need to be careful to work with this workbook and this tab as there will be many in the book. Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to find the correct program to download an .xls attachment | Excel Discussion (Misc queries) | |||
Can you find me a cash out program for a restaurant / bar? | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
How do I activate the trial exel 2003 program if it does't find c. | New Users to Excel | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |