george4884
New Member
- Joined
- Mar 16, 2014
- Messages
- 6
Hi All,
I'm struggling with this situation described below:
If the day/time on Column B and Column C falls outside the criteria shown below, then I need to insert a row before the next non blank cell, and insert the word "QUERY" in Column D.
Criteria:
Monday - Friday, 08:00 until 17:00
Saturday, 08:00 until 13:00
Sunday, 08:00 until 11:00
I have made a dummy data below to illustrate how my spreadsheet looks like. My original spreadsheet >5000 rows of data.
Original data before modification:
<tbody>
</tbody>
This is how I want it to be modified:
<tbody>
</tbody>
Hope someone could help me on this...
File format: Ms Excel 97-2003 (*.xls), Windows 7/8
Thanks!
I'm struggling with this situation described below:
If the day/time on Column B and Column C falls outside the criteria shown below, then I need to insert a row before the next non blank cell, and insert the word "QUERY" in Column D.
Criteria:
Monday - Friday, 08:00 until 17:00
Saturday, 08:00 until 13:00
Sunday, 08:00 until 11:00
I have made a dummy data below to illustrate how my spreadsheet looks like. My original spreadsheet >5000 rows of data.
Original data before modification:
Column A | Column B | Column C | Column D |
11000345 | 8/3/2014 | 07:30 | WGFH2 |
IJLKS | |||
KJB4HL | |||
KJBKLB | |||
11000346 | 8/3/2014 | 08:50 | FEHWJ |
11000347 | 9/3/2014 | 11:24 | GHJHO |
KSBJLK | |||
11000348 | 9/3/2014 | 18:13 | DFHYK |
KJLBK5 | |||
KLJBLK | |||
KKLJ90 | |||
11000349 | 9/3/2014 | 19:30 | KJBFJ |
SGEBE | |||
DGGT | |||
11000350 | 10/3/2014 | 06:45 | KLNKJ |
11000351 | 10/3/2014 | 07:38 | JHSBN |
RHTYH | |||
11000352 | 10/3/2014 | 08:15 | KJSN9 |
HRH53 | |||
DTHT4 | |||
11000353 | 10/3/2014 | 17:31 | JGLIO |
SGEBE | |||
DFHYK |
<tbody>
</tbody>
This is how I want it to be modified:
Column A | Column B | Column C | Column D |
11000345 | 8/3/2014 | 07:30 | WGFH2 |
IJLKS | |||
KJB4HL | |||
KJBKLB | |||
QUERY | |||
11000346 | 8/3/2014 | 08:50 | FEHWJ |
11000347 | 9/3/2014 | 10:24 | GHJHO |
KSBJLK | |||
11000348 | 9/3/2014 | 18:13 | DFHYK |
KJLBK5 | |||
KLJBLK | |||
KKLJ90 | |||
QUERY | |||
11000349 | 9/3/2014 | 19:30 | KJBFJ |
SGEBE | |||
DGGT | |||
QUERY | |||
11000350 | 10/3/2014 | 06:45 | KLNKJ |
QUERY | |||
11000351 | 10/3/2014 | 07:38 | JHSBN |
RHTYH | |||
QUERY | |||
11000352 | 10/3/2014 | 08:15 | KJSN9 |
HRH53 | |||
DTHT4 | |||
11000353 | 10/3/2014 | 17:31 | JGLIO |
SGEBE | |||
DFHYK | |||
QUERY |
<tbody>
</tbody>
Hope someone could help me on this...
File format: Ms Excel 97-2003 (*.xls), Windows 7/8
Thanks!