swaink
Active Member
- Joined
- Feb 15, 2002
- Messages
- 432
I am attempting to check some data to see if everything an agent dealt with was picked at the same time and am comparing the agent code with the destination postcode and pick time.
In the example below there are the three columns Agent, Postcode, Time.
In a further column I want to put a result such as "Grouped" or "Ungrouped".
Where agent = GG11 the postcodes are all the same and the times are all the same therefore the result would be "Grouped"
Where agent = BR06 the postcodes are the same but the times are different therefore the result should be "UnGrouped"
All help appreciated
Regards
Kevin
In the example below there are the three columns Agent, Postcode, Time.
In a further column I want to put a result such as "Grouped" or "Ungrouped".
Where agent = GG11 the postcodes are all the same and the times are all the same therefore the result would be "Grouped"
Where agent = BR06 the postcodes are the same but the times are different therefore the result should be "UnGrouped"
All help appreciated
Regards
Kevin
Colorama Check.xls | ||||||
---|---|---|---|---|---|---|
AC | AD | AE | AF | |||
5 | Agent | Postcode | Time | |||
6 | CD07 | CR02TA | 09:27:01 | |||
7 | GG11 | G332QZ | 11:39:01 | |||
8 | GG11 | G332QZ | 11:39:01 | |||
9 | GG11 | G332QZ | 11:39:01 | |||
10 | GG11 | G332QZ | 11:39:01 | |||
11 | GG11 | G332QZ | 11:39:01 | |||
12 | GG11 | G332QZ | 11:39:01 | |||
13 | NA09 | CF729EE | 11:59:01 | |||
14 | BR06 | BS374NG | 08:47:01 | |||
15 | BR06 | BS374NG | 08:47:01 | |||
16 | BR06 | BS374NG | 10:06:01 | |||
17 | BR06 | BS374NG | 13:28:01 | |||
18 | CF21 | CM61AQ | 11:02:01 | |||
19 | CF21 | CM61AQ | 11:02:01 | |||
20 | YV34 | DT40LX | 08:49:01 | |||
21 | YV18 | DT49PQ | 10:33:01 | |||
22 | PS09 | BB67QL | 08:58:01 | |||
Sheet1 |