how to get the last date ordered for clients throw pivot

hanyhalem

New Member
Joined
Jan 23, 2011
Messages
28
below some client invoices date and I need to find how to get the last date ordered for every client:
you will need to convert from text to columns - delimited - other (space):
Date client Invoice number item code qty
4/1/2014 cl12 5/12/2135 601 4
5/1/2014 cl18 5/12/2144 601 10
9/1/2014 cl4 5/12/2166 601 4
11/1/2014 cl14 5/12/2171 601 48
11/1/2014 cl10 5/12/2172 252 3
12/1/2014 cl18 5/12/2180 601 3
16/1/2014 cl16 5/12/2198 1851 1
20/1/2014 cl11 5/12/2216 23 1
22/1/2014 cl5 5/12/2227 601 2
1/2/2014 cl15 5/12/2273 601 2
3/2/2014 cl18 5/12/2291 601 8
4/2/2014 cl3 5/12/2300 601 10
8/2/2014 cl6 5/12/2322 601 7
8/2/2014 cl16 5/12/2327 396 10
8/2/2014 cl14 5/12/2329 601 1
11/2/2014 cl9 5/12/2342 601 2
16/2/2014 cl18 5/12/2371 601 12
20/2/2014 cl18 5/12/2405 601 3
22/2/2014 cl18 5/12/2416 600 3
25/2/2014 cl14 5/12/2432 601 48
26/2/2014 cl9 5/12/2438 601 0
26/2/2014 cl9 5/12/2438 601 5
2/3/2014 cl13 5/12/2464 396 8
4/3/2014 cl15 5/12/2486 601 4
4/3/2014 cl18 5/12/2488 601 14
11/3/2014 cl3 5/12/2534 600 3
11/3/2014 cl3 5/12/2534 601 5
13/3/2014 cl15 5/12/2549 601 3
13/3/2014 cl6 5/12/2550 1851 1
13/3/2014 cl6 5/12/2550 601 3
13/3/2014 cl3 5/12/2551 601 12
15/3/2014 cl15 5/12/2554 601 1
15/3/2014 cl18 5/12/2557 601 3
18/3/2014 cl14 5/12/2584 601 1
19/3/2014 cl14 5/12/2588 601 4
19/3/2014 cl2 5/12/2589 601 2
19/3/2014 cl9 5/12/2591 601 0
19/3/2014 cl9 5/12/2591 601 5
22/3/2014 cl17 5/12/2602 601 1
22/3/2014 cl5 5/12/2605 296 3
25/3/2014 cl7 5/12/2629 278 5
27/3/2014 cl6 5/12/2641 601 4
27/3/2014 cl18 5/12/2642 601 23
31/3/2014 cl5 5/12/2664 296 3
31/3/2014 cl5 5/12/2664 601 1
31/3/2014 cl6 5/12/2666 601 3
31/3/2014 cl2 5/12/2668 601 1
2/4/2014 cl14 5/12/2677 601 1
5/4/2014 cl18 5/12/2702 601 5
13/4/2014 cl18 5/12/2751 601 6
13/4/2014 cl13 5/12/2756 396 4
15/4/2014 cl6 5/12/2770 601 2
16/4/2014 cl18 5/12/2775 601 3
17/4/2014 cl14 5/12/2781 601 1
17/4/2014 cl15 5/12/2786 601 1
19/4/2014 cl18 5/12/2787 601 2
22/4/2014 cl9 5/12/2804 601 1
24/4/2014 cl18 5/12/2812 601 6
27/4/2014 cl8 5/12/2824 1775 2
29/4/2014 cl16 5/12/2846 23 4
30/4/2014 cl18 5/12/2855 396 4
1/5/2014 cl18 5/12/2860 601 3
17/5/2014 cl14 5/12/2929 601 2
20/5/2014 cl18 5/12/2960 601 6
21/5/2014 cl4 5/12/2963 601 1
1/6/2014 cl18 5/12/3037 601 6
3/6/2014 cl18 5/12/3043 601 4
4/6/2014 cl6 5/12/3045 601 14
5/6/2014 cl7 5/12/3060 601 2
11/6/2014 cl6 5/12/3090 601 5
12/6/2014 cl18 5/12/3096 601 12
17/6/2014 cl8 5/12/3116 601 7
18/6/2014 cl17 5/12/3122 335 70
18/6/2014 cl17 5/12/3122 60003 25
19/6/2014 cl16 5/12/3130 1775 2
19/6/2014 cl16 5/12/3130 1776 2
1/7/2014 cl3 5/12/3204 601 50
3/7/2014 cl18 5/12/3219 601 21
10/7/2014 cl18 5/12/3253 601 10
12/7/2014 cl17 5/12/3256 601 5
12/7/2014 cl17 5/12/3258 601 5
19/7/2014 cl8 5/12/3313 601 1
19/7/2014 cl18 5/12/3314 601 5
22/7/2014 cl5 5/12/3330 601 3
24/7/2014 cl10 5/12/3348 89 4
26/7/2014 cl16 5/12/3358 601 1
9/8/2014 cl11 5/12/3379 89 1
11/8/2014 cl8 5/12/3385 1775 2
11/8/2014 cl8 5/12/3385 1776 2
14/8/2014 cl17 5/12/3402 60003 4
21/8/2014 cl9 5/12/3425 601 3
21/8/2014 cl18 5/12/3431 601 3
24/8/2014 cl15 5/12/3443 601 3
24/8/2014 cl3 5/12/3444 1775 2
24/8/2014 cl3 5/12/3444 1776 2
25/8/2014 cl9 5/12/3451 601 5
25/8/2014 cl18 5/12/3454 601 10
1/9/2014 cl17 5/12/3485 601 2
8/9/2014 cl7 5/12/3516 601 5
9/9/2014 cl7 5/12/3524 11308 2
14/9/2014 cl17 5/12/3554 1775 2
14/9/2014 cl17 5/12/3554 1776 2
16/9/2014 cl11 5/12/3570 601 5
17/9/2014 cl17 5/12/3575 1775 14
17/9/2014 cl17 5/12/3575 1776 14
17/9/2014 cl17 5/12/3575 601 12
20/9/2014 cl17 5/12/3588 601 8
21/9/2014 cl6 5/12/3600 601 20
22/9/2014 cl18 5/12/3605 601 10
22/9/2014 cl17 5/12/3608 601 2
22/9/2014 cl8 5/12/3609 601 3
2/10/2014 cl8 5/12/3664 601 3
16/10/2014 cl5 5/12/3685 396 1
27/10/2014 cl18 5/12/3733 601 7
2/11/2014 cl17 5/12/3777 335 1
3/11/2014 cl18 5/12/3779 601 0
3/11/2014 cl18 5/12/3779 601 3
4/11/2014 cl6 5/12/3784 601 14
4/11/2014 cl6 5/12/3784 601 0
18/11/2014 cl9 5/12/3841 601 1
20/11/2014 cl17 5/12/3849 601 4
20/11/2014 cl13 5/12/3850 335 2
20/11/2014 cl18 5/12/3852 601 15
26/11/2014 cl18 5/12/3885 601 6
30/11/2014 cl18 5/12/3896 601 10
11/12/2014 cl14 5/12/3962 600 24
14/12/2014 cl18 5/12/3967 600 3
22/12/2014 cl13 5/12/3999 600 2
23/12/2014 cl18 5/12/4007 600 2
23/12/2014 cl14 5/12/4009 600 10
27/12/2014 cl6 5/12/4023 600 24
27/12/2014 cl6 5/12/4023 601 8
28/12/2014 cl18 5/12/4031 600 3
5/1/2015 cl18 5/12/4059 600 6
11/1/2015 cl6 5/12/4089 601 8
18/1/2015 cl18 5/12/4120 600 3
25/1/2015 cl18 5/12/4149 600 4
31/1/2015 cl8 5/12/4172 23 1
31/1/2015 cl18 5/12/4174 600 6
1/2/2015 cl12 5/12/4177 296 4
1/2/2015 cl14 5/12/4178 600 24
5/2/2015 cl4 5/12/4204 600 1
12/2/2015 cl18 5/12/4239 600 3
14/2/2015 cl14 5/12/4245 600 12
15/2/2015 cl18 5/12/4251 600 3
22/2/2015 cl9 5/12/4282 23 2
23/2/2015 cl16 5/12/4292 600 4
23/2/2015 cl18 5/12/4295 600 2
25/2/2015 cl18 5/12/4304 776 1
26/2/2015 cl3 5/12/4306 776 1
26/2/2015 cl3 5/12/4306 923 1
1/3/2015 cl18 5/12/4325 600 5
5/3/2015 cl5 5/12/4352 23 1
5/3/2015 cl14 5/12/4353 600 10
14/3/2015 cl13 5/12/4398 923 1
15/3/2015 cl17 5/12/4401 600 1
5/1/2014 cl16 5/12/2143 893 1
5/1/2014 cl14 5/12/2147 8902 1
5/1/2014 cl14 5/12/2147 891 1
8/1/2014 cl4 May-17 8902 2
8/1/2014 cl4 May-17 8912 6
8/1/2014 cl4 May-17 897 1
12/1/2014 cl10 5/12/2177 8912 4
12/1/2014 cl18 5/12/2181 8902 1
12/1/2014 cl18 5/12/2181 893 1
13/1/2014 cl7 5/12/2188 8912 4
13/1/2014 cl7 5/12/2188 897 2
19/1/2014 cl17 5/12/2210 8902 1
19/1/2014 cl17 5/12/2210 893 1
20/1/2014 cl14 5/12/2217 8902 6
20/1/2014 cl14 5/12/2217 8912 8
20/1/2014 cl14 5/12/2217 897 2
22/1/2014 cl15 5/12/2228 8902 8
22/1/2014 cl15 5/12/2228 8912 20
22/1/2014 cl15 5/12/2228 897 10
29/1/2014 cl17 5/12/2253 8902 0
29/1/2014 cl17 5/12/2253 8902 2
29/1/2014 cl17 5/12/2253 8902 0
29/1/2014 cl17 5/12/2253 8912 1
29/1/2014 cl17 5/12/2253 8912 0
1/2/2014 cl7 5/12/2272 8902 5
1/2/2014 cl7 5/12/2272 8912 5
1/2/2014 cl7 5/12/2272 897 1
1/2/2014 cl15 5/12/2273 8902 3
1/2/2014 cl15 5/12/2273 8912 5
1/2/2014 cl15 5/12/2273 897 1
1/2/2014 cl10 5/12/2274 8902 2
1/2/2014 cl10 5/12/2274 8912 2
2/2/2014 cl4 5/12/2280 8902 2
2/2/2014 cl4 5/12/2280 8912 4
2/2/2014 cl4 5/12/2280 897 1
5/2/2014 cl16 5/12/2309 8902 2
5/2/2014 cl16 5/12/2309 893 2
5/2/2014 cl12 5/12/2311 1401 2
5/2/2014 cl12 5/12/2311 893 2
6/2/2014 cl16 5/12/2318 8902 1
6/2/2014 cl16 5/12/2318 8912 2
8/2/2014 cl12 5/12/2323 8902 3
8/2/2014 cl15 5/12/2325 8902 2
8/2/2014 cl15 5/12/2325 8912 3
8/2/2014 cl15 5/12/2325 897 1
8/2/2014 cl16 5/12/2327 893 1
9/2/2014 cl3 5/12/2335 8902 2
9/2/2014 cl3 5/12/2335 8912 2
10/2/2014 cl5 5/12/2338 8902 20
10/2/2014 cl5 5/12/2338 8912 20
12/2/2014 cl9 5/12/2350 8912 8
13/2/2014 cl9 5/12/2359 8912 200
15/2/2014 cl7 5/12/2363 8912 1
15/2/2014 cl10 5/12/2364 8902 2
15/2/2014 cl10 5/12/2364 8912 3
16/2/2014 cl14 5/12/2372 8902 4
16/2/2014 cl14 5/12/2372 8912 6
16/2/2014 cl5 5/12/2373 1789 20
17/2/2014 cl6 5/12/2384 8912 2
18/2/2014 cl16 5/12/2387 907 1
20/2/2014 cl14 5/12/2400 891 70
20/2/2014 cl7 5/12/2404 8902 2
20/2/2014 cl7 5/12/2404 8912 2
24/2/2014 cl14 5/12/2423 8912 3
26/2/2014 cl7 5/12/2441 8902 4
26/2/2014 cl7 5/12/2441 8912 1
26/2/2014 cl7 5/12/2441 897 1
27/2/2014 cl15 5/12/2446 8902 2
27/2/2014 cl15 5/12/2446 907 1
1/3/2014 cl7 5/12/2449 8902 4
1/3/2014 cl7 5/12/2449 8912 4
1/3/2014 cl7 5/12/2449 897 2
1/3/2014 cl14 5/12/2450 1789 5
1/3/2014 cl14 5/12/2450 8902 2
1/3/2014 cl14 5/12/2450 897 1
1/3/2014 cl15 5/12/2451 907 1
2/3/2014 cl10 5/12/2462 89022 0
2/3/2014 cl10 5/12/2462 89022 2
2/3/2014 cl10 5/12/2463 89022 2
2/3/2014 cl3 5/12/2465 89022 2
5/3/2014 cl10 5/12/2494 89022 2
6/3/2014 cl14 5/12/2504 8912 10
10/3/2014 cl14 5/12/2521 1789 20
10/3/2014 cl14 5/12/2521 8902 20
10/3/2014 cl14 5/12/2521 891 100
10/3/2014 cl13 5/12/2524 8902 2
10/3/2014 cl13 5/12/2524 8912 3
10/3/2014 cl13 5/12/2524 897 2
11/3/2014 cl17 5/12/2530 8902 2
11/3/2014 cl17 5/12/2530 8912 3
11/3/2014 cl17 5/12/2530 897 1
12/3/2014 cl13 5/12/2536 1789 3
12/3/2014 cl13 5/12/2536 8902 2
12/3/2014 cl5 5/12/2542 8902 4
15/3/2014 cl14 5/12/2559 891 30
15/3/2014 cl14 5/12/2559 8912 4
15/3/2014 cl3 5/12/2560 8902 10
15/3/2014 cl3 5/12/2560 8912 13
16/3/2014 cl10 5/12/2564 8902 4
16/3/2014 cl10 5/12/2564 8912 4
16/3/2014 cl14 5/12/2566 1789 8
16/3/2014 cl14 5/12/2566 8902 4
16/3/2014 cl14 5/12/2566 897 2
17/3/2014 cl14 5/12/2570 893 1
17/3/2014 cl16 5/12/2573 907 1
18/3/2014 cl13 5/12/2577 89022 4
18/3/2014 cl13 5/12/2577 89122 4
18/3/2014 cl3 5/12/2582 8912 8
18/3/2014 cl3 5/12/2582 897 4
19/3/2014 cl17 5/12/2592 8902 5
19/3/2014 cl17 5/12/2592 8912 5
19/3/2014 cl17 5/12/2592 897 2
20/3/2014 cl2 5/12/2597 8912 1
20/3/2014 cl2 5/12/2597 893 1
20/3/2014 cl6 May-91 8902 2
20/3/2014 cl6 May-91 8912 4
20/3/2014 cl6 May-91 897 0
20/3/2014 cl6 May-91 897 1
25/3/2014 cl13 5/12/2623 897 2
25/3/2014 cl12 5/12/2624 8902 1
25/3/2014 cl12 5/12/2624 893 1
26/3/2014 cl14 5/12/2628 8902 1
26/3/2014 cl14 5/12/2628 89022 4
26/3/2014 cl14 5/12/2628 893 1
29/3/2014 cl18 5/12/2647 8902 4
29/3/2014 cl18 5/12/2647 8912 6
31/3/2014 cl9 May-62 8912 90
2/4/2014 cl17 5/12/2682 891 3
8/4/2014 cl3 5/12/2722 8902 4
10/4/2014 cl13 5/12/2737 8902 2
10/4/2014 cl13 5/12/2737 8912 4
13/4/2014 cl16 5/12/2750 8902 1
14/4/2014 cl16 5/12/2761 89022 2
14/4/2014 cl16 5/12/2761 89122 4
15/4/2014 cl17 5/12/2768 8902 2
15/4/2014 cl17 5/12/2768 8912 4
15/4/2014 cl17 5/12/2768 897 2
15/4/2014 cl6 5/12/2770 1401 25
16/4/2014 cl18 5/12/2772 8902 1
16/4/2014 cl17 5/12/2778 8902 4
16/4/2014 cl17 5/12/2778 8912 4
16/4/2014 cl17 5/12/2778 897 2
17/4/2014 cl7 5/12/2780 8902 2
17/4/2014 cl7 5/12/2780 8912 2
20/4/2014 cl10 5/12/2797 8902 2
20/4/2014 cl10 5/12/2797 8912 2
20/4/2014 cl17 5/12/2798 8902 6
20/4/2014 cl17 5/12/2798 8912 10
20/4/2014 cl5 5/12/2799 8902 4
20/4/2014 cl5 5/12/2799 8912 7
20/4/2014 cl5 5/12/2799 897 1
22/4/2014 cl9 5/12/2804 8902 2
22/4/2014 cl9 5/12/2804 897 2
26/4/2014 cl6 5/12/2822 8902 6
26/4/2014 cl6 5/12/2822 8912 3
26/4/2014 cl15 5/12/2823 8902 4
26/4/2014 cl15 5/12/2823 8912 9
26/4/2014 cl15 5/12/2823 897 1
30/4/2014 cl15 5/12/2854 8902 2
30/4/2014 cl15 5/12/2854 8912 2
30/4/2014 cl15 5/12/2854 897 1
1/5/2014 cl7 5/12/2859 8902 2
1/5/2014 cl7 5/12/2859 8912 2
1/5/2014 cl7 5/12/2859 897 1
1/5/2014 cl15 5/12/2862 8902 25
1/5/2014 cl15 5/12/2862 8912 20
1/5/2014 cl15 5/12/2862 893 20
3/5/2014 cl9 5/12/2863 8902 2
3/5/2014 cl9 5/12/2863 8912 4
3/5/2014 cl9 5/12/2863 897 2
4/5/2014 cl12 5/12/2872 893 1
7/5/2014 cl12 5/12/2883 908 1
7/5/2014 cl3 5/12/2889 8902 6
7/5/2014 cl3 5/12/2889 8912 8
7/5/2014 cl3 5/12/2889 907 2
10/5/2014 cl7 5/12/2893 8902 2
10/5/2014 cl7 5/12/2893 8912 5
10/5/2014 cl7 5/12/2893 897 1
10/5/2014 cl15 5/12/2895 8902 4
10/5/2014 cl15 5/12/2895 8912 7
10/5/2014 cl15 5/12/2895 897 1
10/5/2014 cl5 5/12/2896 178 1
11/5/2014 cl14 5/12/2905 1789 2
11/5/2014 cl14 5/12/2905 8902 2
11/5/2014 cl14 5/12/2905 897 1
18/5/2014 cl14 5/12/2932 8912 3
18/5/2014 cl14 5/12/2932 893 4
18/5/2014 cl6 5/12/2935 8902 2
18/5/2014 cl6 5/12/2935 8912 1
18/5/2014 cl6 5/12/2935 897 1
18/5/2014 cl5 5/12/2938 897 1
18/5/2014 cl15 5/12/2941 8902 4
18/5/2014 cl15 5/12/2941 8912 4
18/5/2014 cl15 5/12/2941 897 2
20/5/2014 cl5 5/12/2959 8902 2
21/5/2014 cl8 5/12/2965 8912 5
22/5/2014 cl9 5/12/2973 8902 3
22/5/2014 cl9 5/12/2973 8912 7
22/5/2014 cl9 5/12/2973 897 1
22/5/2014 cl9 5/12/2973 908 1
22/5/2014 cl16 5/12/2974 8902 15
22/5/2014 cl16 5/12/2974 8912 15
22/5/2014 cl16 5/12/2974 897 6
25/5/2014 cl5 5/12/2991 8902 10
25/5/2014 cl5 5/12/2991 8912 10
25/5/2014 cl5 5/12/2991 897 4
28/5/2014 cl16 5/12/3006 8902 1
28/5/2014 cl16 5/12/3006 893 1
28/5/2014 cl7 5/12/3009 89022 2
31/5/2014 cl2 5/12/3025 8902 7
31/5/2014 cl4 5/12/3027 8902 2
31/5/2014 cl4 5/12/3027 8912 2
31/5/2014 cl16 5/12/3029 8902 2
31/5/2014 cl16 5/12/3029 8912 2
1/6/2014 cl5 5/12/3031 8902 2
1/6/2014 cl5 5/12/3031 8912 2
1/6/2014 cl5 5/12/3031 897 1
2/6/2014 cl7 5/12/3039 8902 4
2/6/2014 cl7 5/12/3039 8912 7
2/6/2014 cl7 5/12/3039 897 3
4/6/2014 cl6 5/12/3045 1401 2
4/6/2014 cl14 5/12/3055 891 175
5/6/2014 cl17 5/12/3056 8902 4
5/6/2014 cl17 5/12/3056 8912 10
5/6/2014 cl17 5/12/3056 8912 0
5/6/2014 cl17 5/12/3056 897 1
5/6/2014 cl14 5/12/3061 891 112
9/6/2014 cl7 5/12/3071 89022 6
9/6/2014 cl15 5/12/3072 8902 4
9/6/2014 cl15 5/12/3072 8912 8
9/6/2014 cl15 5/12/3072 897 2
10/6/2014 cl15 5/12/3082 8912 18
10/6/2014 cl2 5/12/3085 893 3
11/6/2014 cl18 5/12/3089 8902 4
11/6/2014 cl18 5/12/3089 8912 6
11/6/2014 cl18 5/12/3089 897 2
12/6/2014 cl8 5/12/3092 8902 2
12/6/2014 cl8 5/12/3092 8912 3
12/6/2014 cl8 5/12/3092 897 1
22/10/2014 cl15 5/12/3714 1789 1
22/10/2014 cl15 5/12/3714 8902 1
22/10/2014 cl15 5/12/3714 893 0
22/10/2014 cl15 5/12/3714 893 1
23/10/2014 cl18 5/12/3717 8902 1
23/10/2014 cl18 5/12/3717 893 1
23/10/2014 cl9 5/12/3718 1789 30
23/10/2014 cl9 5/12/3718 908 13
25/10/2014 cl15 5/12/3720 8902 20
25/10/2014 cl15 5/12/3720 908 10
26/10/2014 cl15 5/12/3725 1789 10
27/10/2014 cl18 5/12/3735 893 1
27/10/2014 cl5 5/12/3737 1789 12
27/10/2014 cl5 5/12/3737 8902 12
28/10/2014 cl6 5/12/3743 1789 5
4/11/2014 cl6 5/12/3784 1789 5
4/11/2014 cl6 5/12/3784 8902 5
5/11/2014 cl10 5/12/3786 8902 4
5/11/2014 cl10 5/12/3786 897 1
6/11/2014 cl5 5/12/3792 8902 10
6/11/2014 cl17 5/12/3794 8902 1
6/11/2014 cl17 5/12/3794 897 1
9/11/2014 cl8 5/12/3800 8902 2
9/11/2014 cl8 5/12/3800 897 2
10/11/2014 cl17 5/12/3804 8902 3
10/11/2014 cl17 5/12/3804 908 1
10/11/2014 cl14 5/12/3807 8902 2
10/11/2014 cl14 5/12/3807 897 1
12/11/2014 cl17 5/12/3814 8902 50
12/11/2014 cl17 5/12/3814 8912 50
12/11/2014 cl17 5/12/3814 897 25
15/11/2014 cl5 5/12/3826 8902 2
15/11/2014 cl5 5/12/3826 8912 2
15/11/2014 cl5 5/12/3826 897 1
15/11/2014 cl3 5/12/3827 8902 4
15/11/2014 cl3 5/12/3827 8902 0
15/11/2014 cl3 5/12/3827 8912 0
15/11/2014 cl3 5/12/3827 8912 4
15/11/2014 cl3 5/12/3827 897 1
17/11/2014 cl17 5/12/3833 8902 2
17/11/2014 cl17 5/12/3833 8912 2
17/11/2014 cl17 5/12/3833 897 1
17/11/2014 cl6 5/12/3836 8902 2
17/11/2014 cl6 5/12/3836 8912 1
18/11/2014 cl7 5/12/3840 89022 4
18/11/2014 cl15 5/12/3843 8902 2
18/11/2014 cl15 5/12/3843 893 3
20/11/2014 cl18 5/12/3852 897 1
22/11/2014 cl18 5/12/3857 8902 2
22/11/2014 cl18 5/12/3857 8912 4
22/11/2014 cl18 5/12/3857 897 1
1/12/2014 cl5 5/12/3902 8902 2
1/12/2014 cl5 5/12/3902 8912 3
1/12/2014 cl5 5/12/3902 897 1
6/12/2014 cl6 5/12/3922 8902 2
6/12/2014 cl6 5/12/3922 8912 2
7/12/2014 cl9 5/12/3926 1789 5
8/12/2014 cl18 5/12/3932 1789 3
8/12/2014 cl18 5/12/3932 897 1
8/12/2014 cl7 5/12/3939 1789 3
8/12/2014 cl7 5/12/3939 897 1
13/12/2014 cl12 5/12/3958 1789 2
14/12/2014 cl10 5/12/3964 8902 6
14/12/2014 cl10 5/12/3964 8912 7
14/12/2014 cl10 5/12/3964 897 1
14/12/2014 cl7 5/12/3965 89022 2
14/12/2014 cl3 5/12/3966 1789 11
14/12/2014 cl3 5/12/3966 897 4
15/12/2014 cl5 5/12/3972 8902 4
16/12/2014 cl6 5/12/3974 1789 8
16/12/2014 cl6 5/12/3974 897 3
16/12/2014 cl18 5/12/3975 8902 8
16/12/2014 cl18 5/12/3975 8912 14
16/12/2014 cl18 5/12/3975 897 2
17/12/2014 cl14 5/12/3977 8902 20
17/12/2014 cl14 5/12/3977 8912 20
17/12/2014 cl16 5/12/3978 897 1
17/12/2014 cl9 5/12/3979 1789 7
21/12/2014 cl3 5/12/3996 1789 2
21/12/2014 cl3 5/12/3996 8902 2
21/12/2014 cl3 5/12/3996 897 1
23/12/2014 cl18 5/12/4003 8902 6
23/12/2014 cl18 5/12/4003 8912 12
23/12/2014 cl18 5/12/4003 897 2
23/12/2014 cl3 5/12/4004 1789 8
23/12/2014 cl3 5/12/4004 8902 6
23/12/2014 cl3 5/12/4004 908 3
23/12/2014 cl3 5/12/4005 1789 4
23/12/2014 cl3 5/12/4005 8902 4
23/12/2014 cl3 5/12/4005 897 1
25/12/2014 cl17 5/12/4016 1789 4
25/12/2014 cl17 5/12/4016 908 2
27/12/2014 cl12 5/12/4021 8902 4
27/12/2014 cl12 5/12/4021 8912 4
28/12/2014 cl14 5/12/4029 897 4
31/12/2014 cl15 5/12/4035 8902 6
31/12/2014 cl15 5/12/4035 8912 40
31/12/2014 cl15 5/12/4035 897 18
31/12/2014 cl1 5/12/4043 1789 5
31/12/2014 cl1 5/12/4043 8902 2
3/1/2015 cl17 5/12/4054 8902 1
3/1/2015 cl17 5/12/4054 8912 1
5/1/2015 cl14 5/12/4058 89022 2
7/1/2015 cl14 5/12/4069 8902 6
7/1/2015 cl14 5/12/4069 8912 10
7/1/2015 cl14 5/12/4069 897 1
8/1/2015 cl14 5/12/4077 897 17
11/1/2015 cl6 5/12/4089 1789 60
11/1/2015 cl16 5/12/4090 897 10
12/1/2015 cl14 5/12/4093 89002 2
12/1/2015 cl14 5/12/4093 8912 3
12/1/2015 cl14 5/12/4093 897 1
12/1/2015 cl7 5/12/4099 8902 1
12/1/2015 cl7 5/12/4099 8912 1
12/1/2015 cl7 5/12/4099 897 1
13/1/2015 cl7 5/12/4102 890 20
13/1/2015 cl7 5/12/4102 8912 20
15/1/2015 cl6 5/12/4110 8902 2
19/1/2015 cl17 5/12/4123 893 3
21/1/2015 cl17 5/12/4133 8902 2
21/1/2015 cl17 5/12/4133 8912 6
21/1/2015 cl17 5/12/4133 897 1
22/1/2015 cl18 5/12/4138 8902 2
22/1/2015 cl18 5/12/4138 8912 4
25/1/2015 cl6 5/12/4147 8902 2
25/1/2015 cl6 5/12/4147 897 2
28/1/2015 cl7 5/12/4158 1789 3
29/1/2015 cl17 5/12/4165 8902 2
29/1/2015 cl17 5/12/4165 8912 2
29/1/2015 cl17 5/12/4165 897 2
31/1/2015 cl9 5/12/4173 893 1
1/2/2015 cl14 5/12/4178 1789 6
1/2/2015 cl14 5/12/4178 8902 6
1/2/2015 cl14 5/12/4178 897 1
1/2/2015 cl17 5/12/4179 1789 2
1/2/2015 cl17 5/12/4179 8902 2
9/2/2015 cl15 5/12/4220 1789 1
14/2/2015 cl16 5/12/4242 8902 2
14/2/2015 cl16 5/12/4242 8912 2
14/2/2015 cl16 5/12/4242 897 1
14/2/2015 cl9 5/12/4244 893 2
15/2/2015 cl13 5/12/4246 89022 2
17/2/2015 cl17 5/12/4257 8902 4
17/2/2015 cl17 5/12/4257 8912 12
19/2/2015 cl14 5/12/4271 1789 5
19/2/2015 cl14 5/12/4271 897 1
21/2/2015 cl14 5/12/4278 8902 2
21/2/2015 cl14 5/12/4278 8912 3
21/2/2015 cl14 5/12/4278 897 1
24/2/2015 cl15 5/12/4301 8902 2
24/2/2015 cl15 5/12/4301 8912 2
26/2/2015 cl1 5/12/4308 1789 2
4/3/2015 cl13 5/12/4341 8902 2
4/3/2015 cl13 5/12/4341 8912 2
4/3/2015 cl13 5/12/4341 893 1
4/3/2015 cl13 5/12/4341 897 2
4/3/2015 cl17 5/12/4344 8902 2
4/3/2015 cl17 5/12/4344 8912 1
4/3/2015 cl17 5/12/4344 897 1
5/3/2015 cl10 5/12/4348 8902 2
5/3/2015 cl10 5/12/4348 8912 2
5/3/2015 cl10 5/12/4348 897 1
5/3/2015 cl16 5/12/4350 89002 2
5/3/2015 cl16 5/12/4350 8912 2
7/3/2015 cl4 5/12/4355 1789 3
7/3/2015 cl8 5/12/4357 8902 2
7/3/2015 cl8 5/12/4357 8912 0
7/3/2015 cl8 5/12/4357 8912 2
7/3/2015 cl8 5/12/4357 897 1
8/3/2015 cl9 5/12/4362 8902 16
8/3/2015 cl9 5/12/4362 8912 16
15/3/2015 cl14 5/12/4403 8902 2
15/3/2015 cl14 5/12/4403 8912 2
15/3/2015 cl14 5/12/4403 897 1
2/11/2014 cl17 5/12/3778 2249 1
11/3/2015 cl16 5/12/4388 767 1
8/2/2014 cl6 5/12/2322 866 3
26/2/2014 cl7 5/12/2441 866 1
29/3/2014 cl5 5/12/2652 866 2
1/2/2015 cl17 5/12/4181 866 1
2/11/2014 cl17 5/12/3778 5895 1
2/11/2014 cl17 5/12/3778 5896 1
21/6/2014 cl13 5/12/3139 1810 2
22/12/2014 cl11 5/12/4001 1816 1
1/1/2014 cl15 5/12/2122 1885 1
1/1/2014 cl14 5/12/2123 183 1
1/1/2014 cl14 5/12/2123 2 1
1/1/2014 cl14 5/12/2125 264 2
1/1/2014 cl14 5/12/2125 266 3
2/1/2014 cl10 5/12/2129 264 7
2/1/2014 cl7 5/12/2131 263 2
2/1/2014 cl11 5/12/2132 184 1
4/1/2014 cl13 5/12/2133 183 8
4/1/2014 cl17 5/12/2134 184 2
4/1/2014 cl12 5/12/2135 184 3
4/1/2014 cl3 May-91 263 2
5/1/2014 cl3 5/12/2139 264 6
5/1/2014 cl3 5/12/2141 183 3
5/1/2014 cl18 5/12/2149 268 3
5/1/2014 cl9 5/12/2151 184 2
5/1/2014 cl9 5/12/2151 263 4
5/1/2014 cl9 5/12/2151 404 1
6/1/2014 cl3 5/12/2155 183 3
8/1/2014 cl5 5/12/2159 183 2
9/1/2014 cl14 5/12/2162 184 2
9/1/2014 cl6 5/12/2165 184 1
9/1/2014 cl6 5/12/2165 264 1
11/1/2014 cl17 5/12/2168 184 1
11/1/2014 cl17 5/12/2168 264 5
11/1/2014 cl7 5/12/2169 183 2
11/1/2014 cl15 5/12/2170 184 1
11/1/2014 cl14 5/12/2171 1030 1
11/1/2014 cl14 5/12/2171 264 1
11/1/2014 cl10 5/12/2172 184 1
12/1/2014 cl13 5/12/2175 184 0
12/1/2014 cl13 5/12/2175 184 5
12/1/2014 cl10 5/12/2176 184 2
10/3/2014 cl18 5/12/2527 556 3
1/4/2014 cl7 5/12/2672 556 3
9/4/2014 cl16 5/12/2728 1174 2
12/4/2014 cl16 5/12/2741 556 1
15/4/2014 cl15 5/12/2769 556 3
16/4/2014 cl18 5/12/2772 1840 1
17/4/2014 cl9 5/12/2785 557 2
28/4/2014 cl16 5/12/2831 1375 1
29/4/2014 cl13 5/12/2845 1174 2
30/4/2014 cl16 5/12/2856 557 12
6/5/2014 cl12 5/12/2880 1375 1
10/5/2014 cl17 5/12/2891 1375 1
14/5/2014 cl16 5/12/2919 1174 1
18/5/2014 cl9 5/12/2936 557 4
21/5/2014 cl3 5/12/2966 557 4
22/5/2014 cl16 5/12/2974 1375 3
24/5/2014 cl16 5/12/2978 1375 1
25/5/2014 cl12 5/12/2988 556 4
28/5/2014 cl7 5/12/3009 1840 2
4/6/2014 cl4 5/12/3054 556 2
5/6/2014 cl9 5/12/3059 557 4
9/6/2014 cl7 5/12/3071 80017 2
10/6/2014 cl16 5/12/3079 556 2
14/6/2014 cl6 5/12/3100 556 1
16/6/2014 cl16 5/12/3110 557 1
16/6/2014 cl16 5/12/3110 80017 6
22/6/2014 cl5 5/12/3147 375 1
28/6/2014 cl10 5/12/3183 375 4
28/6/2014 cl10 5/12/3183 80017 2
1/7/2014 cl15 5/12/3203 556 3
2/7/2014 cl9 5/12/3207 557 4
2/7/2014 cl16 5/12/3210 557 8
12/7/2014 cl16 5/12/3254 557 11
15/7/2014 cl7 5/12/3281 1840 1
15/7/2014 cl15 5/12/3282 556 2
15/7/2014 cl3 5/12/3283 557 8
21/7/2014 cl7 5/12/3322 1840 1
23/7/2014 cl18 5/12/3341 1375 1
13/8/2014 cl12 5/12/3400 556 1
19/8/2014 cl10 5/12/3422 1840 1
23/8/2014 cl5 5/12/3436 556 1
27/8/2014 cl7 5/12/3467 1174 1
4/9/2014 cl17 5/12/3498 375 1
13/9/2014 cl10 5/12/3547 1174 1
20/9/2014 cl3 5/12/3592 557 8
23/9/2014 cl3 5/12/3616 557 4
25/9/2014 cl9 5/12/3623 557 8
8/1/2015 cl16 5/12/4076 94 10
10/1/2015 cl7 5/12/4079 611111 20
10/1/2015 cl6 5/12/4082 1206 16
10/1/2015 cl6 5/12/4082 611111 16
11/1/2015 cl6 5/12/4089 56 30
11/1/2015 cl6 5/12/4089 611111 75
13/1/2015 cl9 5/12/4101 1206 23
13/1/2015 cl9 5/12/4101 56 2
13/1/2015 cl9 5/12/4101 611111 130
13/1/2015 cl9 5/12/4101 612 36
13/1/2015 cl9 5/12/4101 94 2
14/1/2015 cl8 5/12/4104 56 2
14/1/2015 cl8 5/12/4104 611111 4
14/1/2015 cl5 5/12/4106 1206 2000
19/1/2015 cl16 5/12/4124 1351 3
20/1/2015 cl6 5/12/4126 611111 20
20/1/2015 cl6 5/12/4126 6161 40
20/1/2015 cl9 5/12/4127 1351 64
20/1/2015 cl6 5/12/4129 611111 20
20/1/2015 cl6 5/12/4129 6161 40
20/1/2015 cl18 5/12/4132 6161 60
21/1/2015 cl16 5/12/4135 1206 20
21/1/2015 cl16 5/12/4135 56 8
21/1/2015 cl16 5/12/4135 611111 20
21/1/2015 cl16 5/12/4135 6161 60
27/1/2015 cl9 5/12/4154 56 15
27/1/2015 cl17 5/12/4156 1206 6
27/1/2015 cl17 5/12/4156 56 2
27/1/2015 cl17 5/12/4156 611111 15
27/1/2015 cl11 5/12/4157 611111 40
28/1/2015 cl7 5/12/4158 1351 6
28/1/2015 cl7 5/12/4158 56 2
28/1/2015 cl7 5/12/4158 611111 4
28/1/2015 cl7 5/12/4160 1206 40
28/1/2015 cl7 5/12/4160 611111 40
29/1/2015 cl3 5/12/4163 1206 50
29/1/2015 cl3 5/12/4163 56 1
29/1/2015 cl3 5/12/4163 611111 300
29/1/2015 cl8 5/12/4168 1206 10
29/1/2015 cl8 5/12/4168 611111 20
31/1/2015 cl9 5/12/4171 611111 16
31/1/2015 cl8 5/12/4172 611111 26
31/1/2015 cl8 5/12/4172 6161 80
31/1/2015 cl18 5/12/4174 56 1
1/2/2015 cl13 5/12/4176 6161 15
1/2/2015 cl17 5/12/4179 1206 15
1/2/2015 cl17 5/12/4179 612 15
2/2/2015 cl9 5/12/4190 6 55
4/2/2015 cl7 5/12/4197 1206 6
4/2/2015 cl7 5/12/4197 612 6
5/2/2015 cl9 5/12/4203 1206 10
5/2/2015 cl9 5/12/4203 6161 20
5/2/2015 cl9 5/12/4203 94 4
7/2/2015 cl18 5/12/4208 56 4
7/2/2015 cl4 5/12/4209 1351 4
7/2/2015 cl5 5/12/4213 1206 10
7/2/2015 cl5 5/12/4213 612 10
7/2/2015 cl10 5/12/4214 1206 10
7/2/2015 cl10 5/12/4214 612 10
7/2/2015 cl9 5/12/4215 1206 35
7/2/2015 cl9 5/12/4215 6 35
8/2/2015 cl15 5/12/4219 611111 8
9/2/2015 cl15 5/12/4220 6 40
9/2/2015 cl9 5/12/4221 6161 6
9/2/2015 cl18 5/12/4222 6 30
9/2/2015 cl18 5/12/4222 6 0
10/2/2015 cl9 5/12/4229 1206 400
10/2/2015 cl9 5/12/4229 6 400
12/2/2015 cl3 5/12/4234 6 20
12/2/2015 cl15 5/12/4238 1206 5
15/2/2015 cl11 5/12/4247 6 100
15/2/2015 cl9 5/12/4248 1206 8
15/2/2015 cl9 5/12/4248 612 8
16/2/2015 cl6 5/12/4254 1206 16
16/2/2015 cl6 5/12/4254 6 1
17/2/2015 cl17 5/12/4257 612 15
17/2/2015 cl13 5/12/4260 56 9
18/2/2015 cl17 5/12/4266 6 12
19/2/2015 cl15 5/12/4270 6 50
21/2/2015 cl4 5/12/4277 56 2
21/2/2015 cl4 5/12/4277 6 60
22/2/2015 cl8 5/12/4283 56 2
22/2/2015 cl8 5/12/4284 6 12
22/2/2015 cl8 5/12/4289 1206 19
22/2/2015 cl8 5/12/4289 6 19
23/2/2015 cl12 5/12/4293 1206 3
23/2/2015 cl12 5/12/4293 612 3
23/2/2015 cl18 5/12/4295 56 1
24/2/2015 cl17 5/12/4298 56 0
24/2/2015 cl17 5/12/4298 56 20
24/2/2015 cl9 5/12/4300 1206 15
24/2/2015 cl9 5/12/4300 56 10
24/2/2015 cl9 5/12/4300 6 15
25/2/2015 cl18 5/12/4304 6 10
26/2/2015 cl1 5/12/4308 1206 10
26/2/2015 cl1 5/12/4308 6 20
26/2/2015 cl9 5/12/4312 1206 2
26/2/2015 cl9 5/12/4312 6 2
1/3/2015 cl18 5/12/4322 6 40
1/3/2015 cl11 5/12/4326 94 2
2/3/2015 cl18 5/12/4330 6 8
2/3/2015 cl9 5/12/4332 612 20
3/3/2015 cl4 5/12/4336 1206 40
5/3/2015 cl16 5/12/4350 6 28
5/3/2015 cl16 5/12/4350 6161 100
5/3/2015 cl5 5/12/4352 56 1
5/3/2015 cl5 5/12/4352 6 4
7/3/2015 cl18 5/12/4354 6 28
8/3/2015 cl17 5/12/4363 56 2
8/3/2015 cl17 5/12/4363 612 10
9/3/2015 cl9 5/12/4373 6161 50
9/3/2015 cl10 5/12/4374 6161 70
10/3/2015 cl12 5/12/4376 56 4
10/3/2015 cl18 5/12/4377 56 30
10/3/2015 cl18 5/12/4377 612 36
10/3/2015 cl15 5/12/4381 612 270
11/3/2015 cl18 5/12/4386 1206 24
11/3/2015 cl18 5/12/4386 612 24
11/3/2015 cl18 5/12/4386 6161 28
11/3/2015 cl10 5/12/4387 612 50
11/3/2015 cl10 5/12/4387 6161 50
11/3/2015 cl2 5/12/4390 612 16
11/3/2015 cl2 5/12/4390 6161 90
12/3/2015 cl10 5/12/4391 56 4
12/3/2015 cl16 5/12/4392 1206 8
12/3/2015 cl16 5/12/4392 612 8
12/3/2015 cl13 5/12/4393 1351 2
15/3/2015 cl17 5/12/4401 56 2
1/1/2014 cl13 5/12/2124 211 0
1/1/2014 cl13 5/12/2124 211 1
2/1/2014 cl10 5/12/2129 2306 4
2/1/2014 cl10 5/12/2130 2431 2
2/1/2014 cl7 5/12/2131 2306 1
4/1/2014 cl13 5/12/2133 2306 5
4/1/2014 cl17 5/12/2134 2293 2
4/1/2014 cl12 5/12/2135 2293 1
4/1/2014 cl3 May-91 2307 1
5/1/2014 cl3 5/12/2141 2292 1
5/1/2014 cl4 5/12/2145 1060 1
6/1/2014 cl15 5/12/2154 2285 1
6/1/2014 cl15 5/12/2154 2293 1
6/1/2014 cl15 5/12/2154 2430 1
8/1/2014 cl5 5/12/2159 222 1
8/1/2014 cl5 5/12/2159 2293 2
9/1/2014 cl14 5/12/2162 2293 1
9/1/2014 cl17 5/12/2164 2293 1
9/1/2014 cl6 5/12/2165 2392 2
11/1/2014 cl7 5/12/2169 2307 1
11/1/2014 cl5 5/12/2173 2306 2
12/1/2014 cl13 5/12/2175 2293 1
12/1/2014 cl10 5/12/2176 2306 1
12/1/2014 cl10 5/12/2176 2392 1
12/1/2014 cl3 5/12/2178 2307 1
13/1/2014 cl13 5/12/2186 2293 2
14/1/2014 cl17 5/12/2190 2293 1
15/1/2014 cl3 5/12/2196 2307 1
16/1/2014 cl16 5/12/2198 2292 3
18/1/2014 cl13 5/12/2203 2392 3
18/1/2014 cl15 5/12/2204 2308 3
18/1/2014 cl6 5/12/2207 2392 1
19/1/2014 cl17 5/12/2210 2320 1
21/1/2014 cl5 5/12/2219 1845 1
21/1/2014 cl12 5/12/2221 1046 1
21/1/2014 cl12 5/12/2221 1845 1
21/1/2014 cl12 5/12/2221 2315 1
22/1/2014 cl10 5/12/2232 2306 11
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
once the data is delimited, create a pivot table, drag client and order date into rows then select MAX in field settings..


below some client invoices date and I need to find how to get the last date ordered for every client:
you will need to convert from text to columns - delimited - other (space):
Date client Invoice number item code qty
4/1/2014 cl12 5/12/2135 601 4
5/1/2014 cl18 5/12/2144 601 10
9/1/2014 cl4 5/12/2166 601 4
11/1/2014 cl14 5/12/2171 601 48
11/1/2014 cl10 5/12/2172 252 3
12/1/2014 cl18 5/12/2180 601 3
16/1/2014 cl16 5/12/2198 1851 1
20/1/2014 cl11 5/12/2216 23 1
22/1/2014 cl5 5/12/2227 601 2
1/2/2014 cl15 5/12/2273 601 2
3/2/2014 cl18 5/12/2291 601 8
4/2/2014 cl3 5/12/2300 601 10
8/2/2014 cl6 5/12/2322 601 7
8/2/2014 cl16 5/12/2327 396 10
8/2/2014 cl14 5/12/2329 601 1
11/2/2014 cl9 5/12/2342 601 2
16/2/2014 cl18 5/12/2371 601 12
20/2/2014 cl18 5/12/2405 601 3
22/2/2014 cl18 5/12/2416 600 3
25/2/2014 cl14 5/12/2432 601 48
26/2/2014 cl9 5/12/2438 601 0
26/2/2014 cl9 5/12/2438 601 5
2/3/2014 cl13 5/12/2464 396 8
4/3/2014 cl15 5/12/2486 601 4
4/3/2014 cl18 5/12/2488 601 14
11/3/2014 cl3 5/12/2534 600 3
11/3/2014 cl3 5/12/2534 601 5
13/3/2014 cl15 5/12/2549 601 3
13/3/2014 cl6 5/12/2550 1851 1
13/3/2014 cl6 5/12/2550 601 3
13/3/2014 cl3 5/12/2551 601 12
15/3/2014 cl15 5/12/2554 601 1
15/3/2014 cl18 5/12/2557 601 3
18/3/2014 cl14 5/12/2584 601 1
19/3/2014 cl14 5/12/2588 601 4
19/3/2014 cl2 5/12/2589 601 2
19/3/2014 cl9 5/12/2591 601 0
19/3/2014 cl9 5/12/2591 601 5
22/3/2014 cl17 5/12/2602 601 1
22/3/2014 cl5 5/12/2605 296 3
25/3/2014 cl7 5/12/2629 278 5
27/3/2014 cl6 5/12/2641 601 4
27/3/2014 cl18 5/12/2642 601 23
31/3/2014 cl5 5/12/2664 296 3
31/3/2014 cl5 5/12/2664 601 1
31/3/2014 cl6 5/12/2666 601 3
31/3/2014 cl2 5/12/2668 601 1
2/4/2014 cl14 5/12/2677 601 1
5/4/2014 cl18 5/12/2702 601 5
13/4/2014 cl18 5/12/2751 601 6
13/4/2014 cl13 5/12/2756 396 4
15/4/2014 cl6 5/12/2770 601 2
16/4/2014 cl18 5/12/2775 601 3
17/4/2014 cl14 5/12/2781 601 1
17/4/2014 cl15 5/12/2786 601 1
19/4/2014 cl18 5/12/2787 601 2
22/4/2014 cl9 5/12/2804 601 1
24/4/2014 cl18 5/12/2812 601 6
27/4/2014 cl8 5/12/2824 1775 2
29/4/2014 cl16 5/12/2846 23 4
30/4/2014 cl18 5/12/2855 396 4
1/5/2014 cl18 5/12/2860 601 3
17/5/2014 cl14 5/12/2929 601 2
20/5/2014 cl18 5/12/2960 601 6
21/5/2014 cl4 5/12/2963 601 1
1/6/2014 cl18 5/12/3037 601 6
3/6/2014 cl18 5/12/3043 601 4
4/6/2014 cl6 5/12/3045 601 14
5/6/2014 cl7 5/12/3060 601 2
11/6/2014 cl6 5/12/3090 601 5
12/6/2014 cl18 5/12/3096 601 12
17/6/2014 cl8 5/12/3116 601 7
18/6/2014 cl17 5/12/3122 335 70
18/6/2014 cl17 5/12/3122 60003 25
19/6/2014 cl16 5/12/3130 1775 2
19/6/2014 cl16 5/12/3130 1776 2
1/7/2014 cl3 5/12/3204 601 50
3/7/2014 cl18 5/12/3219 601 21
10/7/2014 cl18 5/12/3253 601 10
12/7/2014 cl17 5/12/3256 601 5
12/7/2014 cl17 5/12/3258 601 5
19/7/2014 cl8 5/12/3313 601 1
19/7/2014 cl18 5/12/3314 601 5
22/7/2014 cl5 5/12/3330 601 3
24/7/2014 cl10 5/12/3348 89 4
26/7/2014 cl16 5/12/3358 601 1
9/8/2014 cl11 5/12/3379 89 1
11/8/2014 cl8 5/12/3385 1775 2
11/8/2014 cl8 5/12/3385 1776 2
14/8/2014 cl17 5/12/3402 60003 4
21/8/2014 cl9 5/12/3425 601 3
21/8/2014 cl18 5/12/3431 601 3
24/8/2014 cl15 5/12/3443 601 3
24/8/2014 cl3 5/12/3444 1775 2
24/8/2014 cl3 5/12/3444 1776 2
25/8/2014 cl9 5/12/3451 601 5
25/8/2014 cl18 5/12/3454 601 10
1/9/2014 cl17 5/12/3485 601 2
8/9/2014 cl7 5/12/3516 601 5
9/9/2014 cl7 5/12/3524 11308 2
14/9/2014 cl17 5/12/3554 1775 2
14/9/2014 cl17 5/12/3554 1776 2
16/9/2014 cl11 5/12/3570 601 5
17/9/2014 cl17 5/12/3575 1775 14
17/9/2014 cl17 5/12/3575 1776 14
17/9/2014 cl17 5/12/3575 601 12
20/9/2014 cl17 5/12/3588 601 8
21/9/2014 cl6 5/12/3600 601 20
22/9/2014 cl18 5/12/3605 601 10
22/9/2014 cl17 5/12/3608 601 2
22/9/2014 cl8 5/12/3609 601 3
2/10/2014 cl8 5/12/3664 601 3
16/10/2014 cl5 5/12/3685 396 1
27/10/2014 cl18 5/12/3733 601 7
2/11/2014 cl17 5/12/3777 335 1
3/11/2014 cl18 5/12/3779 601 0
3/11/2014 cl18 5/12/3779 601 3
4/11/2014 cl6 5/12/3784 601 14
4/11/2014 cl6 5/12/3784 601 0
18/11/2014 cl9 5/12/3841 601 1
20/11/2014 cl17 5/12/3849 601 4
20/11/2014 cl13 5/12/3850 335 2
20/11/2014 cl18 5/12/3852 601 15
26/11/2014 cl18 5/12/3885 601 6
30/11/2014 cl18 5/12/3896 601 10
11/12/2014 cl14 5/12/3962 600 24
14/12/2014 cl18 5/12/3967 600 3
22/12/2014 cl13 5/12/3999 600 2
23/12/2014 cl18 5/12/4007 600 2
23/12/2014 cl14 5/12/4009 600 10
27/12/2014 cl6 5/12/4023 600 24
27/12/2014 cl6 5/12/4023 601 8
28/12/2014 cl18 5/12/4031 600 3
5/1/2015 cl18 5/12/4059 600 6
11/1/2015 cl6 5/12/4089 601 8
18/1/2015 cl18 5/12/4120 600 3
25/1/2015 cl18 5/12/4149 600 4
31/1/2015 cl8 5/12/4172 23 1
31/1/2015 cl18 5/12/4174 600 6
1/2/2015 cl12 5/12/4177 296 4
1/2/2015 cl14 5/12/4178 600 24
5/2/2015 cl4 5/12/4204 600 1
12/2/2015 cl18 5/12/4239 600 3
14/2/2015 cl14 5/12/4245 600 12
15/2/2015 cl18 5/12/4251 600 3
22/2/2015 cl9 5/12/4282 23 2
23/2/2015 cl16 5/12/4292 600 4
23/2/2015 cl18 5/12/4295 600 2
25/2/2015 cl18 5/12/4304 776 1
26/2/2015 cl3 5/12/4306 776 1
26/2/2015 cl3 5/12/4306 923 1
1/3/2015 cl18 5/12/4325 600 5
5/3/2015 cl5 5/12/4352 23 1
5/3/2015 cl14 5/12/4353 600 10
14/3/2015 cl13 5/12/4398 923 1
15/3/2015 cl17 5/12/4401 600 1
5/1/2014 cl16 5/12/2143 893 1
5/1/2014 cl14 5/12/2147 8902 1
5/1/2014 cl14 5/12/2147 891 1
8/1/2014 cl4 May-17 8902 2
8/1/2014 cl4 May-17 8912 6
8/1/2014 cl4 May-17 897 1
12/1/2014 cl10 5/12/2177 8912 4
12/1/2014 cl18 5/12/2181 8902 1
12/1/2014 cl18 5/12/2181 893 1
13/1/2014 cl7 5/12/2188 8912 4
13/1/2014 cl7 5/12/2188 897 2
19/1/2014 cl17 5/12/2210 8902 1
19/1/2014 cl17 5/12/2210 893 1
20/1/2014 cl14 5/12/2217 8902 6
20/1/2014 cl14 5/12/2217 8912 8
20/1/2014 cl14 5/12/2217 897 2
22/1/2014 cl15 5/12/2228 8902 8
22/1/2014 cl15 5/12/2228 8912 20
22/1/2014 cl15 5/12/2228 897 10
29/1/2014 cl17 5/12/2253 8902 0
29/1/2014 cl17 5/12/2253 8902 2
29/1/2014 cl17 5/12/2253 8902 0
29/1/2014 cl17 5/12/2253 8912 1
29/1/2014 cl17 5/12/2253 8912 0
1/2/2014 cl7 5/12/2272 8902 5
1/2/2014 cl7 5/12/2272 8912 5
1/2/2014 cl7 5/12/2272 897 1
1/2/2014 cl15 5/12/2273 8902 3
1/2/2014 cl15 5/12/2273 8912 5
1/2/2014 cl15 5/12/2273 897 1
1/2/2014 cl10 5/12/2274 8902 2
1/2/2014 cl10 5/12/2274 8912 2
2/2/2014 cl4 5/12/2280 8902 2
2/2/2014 cl4 5/12/2280 8912 4
2/2/2014 cl4 5/12/2280 897 1
5/2/2014 cl16 5/12/2309 8902 2
5/2/2014 cl16 5/12/2309 893 2
5/2/2014 cl12 5/12/2311 1401 2
5/2/2014 cl12 5/12/2311 893 2
6/2/2014 cl16 5/12/2318 8902 1
6/2/2014 cl16 5/12/2318 8912 2
8/2/2014 cl12 5/12/2323 8902 3
8/2/2014 cl15 5/12/2325 8902 2
8/2/2014 cl15 5/12/2325 8912 3
8/2/2014 cl15 5/12/2325 897 1
8/2/2014 cl16 5/12/2327 893 1
9/2/2014 cl3 5/12/2335 8902 2
9/2/2014 cl3 5/12/2335 8912 2
10/2/2014 cl5 5/12/2338 8902 20
10/2/2014 cl5 5/12/2338 8912 20
12/2/2014 cl9 5/12/2350 8912 8
13/2/2014 cl9 5/12/2359 8912 200
15/2/2014 cl7 5/12/2363 8912 1
15/2/2014 cl10 5/12/2364 8902 2
15/2/2014 cl10 5/12/2364 8912 3
16/2/2014 cl14 5/12/2372 8902 4
16/2/2014 cl14 5/12/2372 8912 6
16/2/2014 cl5 5/12/2373 1789 20
17/2/2014 cl6 5/12/2384 8912 2
18/2/2014 cl16 5/12/2387 907 1
20/2/2014 cl14 5/12/2400 891 70
20/2/2014 cl7 5/12/2404 8902 2
20/2/2014 cl7 5/12/2404 8912 2
24/2/2014 cl14 5/12/2423 8912 3
26/2/2014 cl7 5/12/2441 8902 4
26/2/2014 cl7 5/12/2441 8912 1
26/2/2014 cl7 5/12/2441 897 1
27/2/2014 cl15 5/12/2446 8902 2
27/2/2014 cl15 5/12/2446 907 1
1/3/2014 cl7 5/12/2449 8902 4
1/3/2014 cl7 5/12/2449 8912 4
1/3/2014 cl7 5/12/2449 897 2
1/3/2014 cl14 5/12/2450 1789 5
1/3/2014 cl14 5/12/2450 8902 2
1/3/2014 cl14 5/12/2450 897 1
1/3/2014 cl15 5/12/2451 907 1
2/3/2014 cl10 5/12/2462 89022 0
2/3/2014 cl10 5/12/2462 89022 2
2/3/2014 cl10 5/12/2463 89022 2
2/3/2014 cl3 5/12/2465 89022 2
5/3/2014 cl10 5/12/2494 89022 2
6/3/2014 cl14 5/12/2504 8912 10
10/3/2014 cl14 5/12/2521 1789 20
10/3/2014 cl14 5/12/2521 8902 20
10/3/2014 cl14 5/12/2521 891 100
10/3/2014 cl13 5/12/2524 8902 2
10/3/2014 cl13 5/12/2524 8912 3
10/3/2014 cl13 5/12/2524 897 2
11/3/2014 cl17 5/12/2530 8902 2
11/3/2014 cl17 5/12/2530 8912 3
11/3/2014 cl17 5/12/2530 897 1
12/3/2014 cl13 5/12/2536 1789 3
12/3/2014 cl13 5/12/2536 8902 2
12/3/2014 cl5 5/12/2542 8902 4
15/3/2014 cl14 5/12/2559 891 30
15/3/2014 cl14 5/12/2559 8912 4
15/3/2014 cl3 5/12/2560 8902 10
15/3/2014 cl3 5/12/2560 8912 13
16/3/2014 cl10 5/12/2564 8902 4
16/3/2014 cl10 5/12/2564 8912 4
16/3/2014 cl14 5/12/2566 1789 8
16/3/2014 cl14 5/12/2566 8902 4
16/3/2014 cl14 5/12/2566 897 2
17/3/2014 cl14 5/12/2570 893 1
17/3/2014 cl16 5/12/2573 907 1
18/3/2014 cl13 5/12/2577 89022 4
18/3/2014 cl13 5/12/2577 89122 4
18/3/2014 cl3 5/12/2582 8912 8
18/3/2014 cl3 5/12/2582 897 4
19/3/2014 cl17 5/12/2592 8902 5
19/3/2014 cl17 5/12/2592 8912 5
19/3/2014 cl17 5/12/2592 897 2
20/3/2014 cl2 5/12/2597 8912 1
20/3/2014 cl2 5/12/2597 893 1
20/3/2014 cl6 May-91 8902 2
20/3/2014 cl6 May-91 8912 4
20/3/2014 cl6 May-91 897 0
20/3/2014 cl6 May-91 897 1
25/3/2014 cl13 5/12/2623 897 2
25/3/2014 cl12 5/12/2624 8902 1
25/3/2014 cl12 5/12/2624 893 1
26/3/2014 cl14 5/12/2628 8902 1
26/3/2014 cl14 5/12/2628 89022 4
26/3/2014 cl14 5/12/2628 893 1
29/3/2014 cl18 5/12/2647 8902 4
29/3/2014 cl18 5/12/2647 8912 6
31/3/2014 cl9 May-62 8912 90
2/4/2014 cl17 5/12/2682 891 3
8/4/2014 cl3 5/12/2722 8902 4
10/4/2014 cl13 5/12/2737 8902 2
10/4/2014 cl13 5/12/2737 8912 4
13/4/2014 cl16 5/12/2750 8902 1
14/4/2014 cl16 5/12/2761 89022 2
14/4/2014 cl16 5/12/2761 89122 4
15/4/2014 cl17 5/12/2768 8902 2
15/4/2014 cl17 5/12/2768 8912 4
15/4/2014 cl17 5/12/2768 897 2
15/4/2014 cl6 5/12/2770 1401 25
16/4/2014 cl18 5/12/2772 8902 1
16/4/2014 cl17 5/12/2778 8902 4
16/4/2014 cl17 5/12/2778 8912 4
16/4/2014 cl17 5/12/2778 897 2
17/4/2014 cl7 5/12/2780 8902 2
17/4/2014 cl7 5/12/2780 8912 2
20/4/2014 cl10 5/12/2797 8902 2
20/4/2014 cl10 5/12/2797 8912 2
20/4/2014 cl17 5/12/2798 8902 6
20/4/2014 cl17 5/12/2798 8912 10
20/4/2014 cl5 5/12/2799 8902 4
20/4/2014 cl5 5/12/2799 8912 7
20/4/2014 cl5 5/12/2799 897 1
22/4/2014 cl9 5/12/2804 8902 2
22/4/2014 cl9 5/12/2804 897 2
26/4/2014 cl6 5/12/2822 8902 6
26/4/2014 cl6 5/12/2822 8912 3
26/4/2014 cl15 5/12/2823 8902 4
26/4/2014 cl15 5/12/2823 8912 9
26/4/2014 cl15 5/12/2823 897 1
30/4/2014 cl15 5/12/2854 8902 2
30/4/2014 cl15 5/12/2854 8912 2
30/4/2014 cl15 5/12/2854 897 1
1/5/2014 cl7 5/12/2859 8902 2
1/5/2014 cl7 5/12/2859 8912 2
1/5/2014 cl7 5/12/2859 897 1
1/5/2014 cl15 5/12/2862 8902 25
1/5/2014 cl15 5/12/2862 8912 20
1/5/2014 cl15 5/12/2862 893 20
3/5/2014 cl9 5/12/2863 8902 2
3/5/2014 cl9 5/12/2863 8912 4
3/5/2014 cl9 5/12/2863 897 2
4/5/2014 cl12 5/12/2872 893 1
7/5/2014 cl12 5/12/2883 908 1
7/5/2014 cl3 5/12/2889 8902 6
7/5/2014 cl3 5/12/2889 8912 8
7/5/2014 cl3 5/12/2889 907 2
10/5/2014 cl7 5/12/2893 8902 2
10/5/2014 cl7 5/12/2893 8912 5
10/5/2014 cl7 5/12/2893 897 1
10/5/2014 cl15 5/12/2895 8902 4
10/5/2014 cl15 5/12/2895 8912 7
10/5/2014 cl15 5/12/2895 897 1
10/5/2014 cl5 5/12/2896 178 1
11/5/2014 cl14 5/12/2905 1789 2
11/5/2014 cl14 5/12/2905 8902 2
11/5/2014 cl14 5/12/2905 897 1
18/5/2014 cl14 5/12/2932 8912 3
18/5/2014 cl14 5/12/2932 893 4
18/5/2014 cl6 5/12/2935 8902 2
18/5/2014 cl6 5/12/2935 8912 1
18/5/2014 cl6 5/12/2935 897 1
18/5/2014 cl5 5/12/2938 897 1
18/5/2014 cl15 5/12/2941 8902 4
18/5/2014 cl15 5/12/2941 8912 4
18/5/2014 cl15 5/12/2941 897 2
20/5/2014 cl5 5/12/2959 8902 2
21/5/2014 cl8 5/12/2965 8912 5
22/5/2014 cl9 5/12/2973 8902 3
22/5/2014 cl9 5/12/2973 8912 7
22/5/2014 cl9 5/12/2973 897 1
22/5/2014 cl9 5/12/2973 908 1
22/5/2014 cl16 5/12/2974 8902 15
22/5/2014 cl16 5/12/2974 8912 15
22/5/2014 cl16 5/12/2974 897 6
25/5/2014 cl5 5/12/2991 8902 10
25/5/2014 cl5 5/12/2991 8912 10
25/5/2014 cl5 5/12/2991 897 4
28/5/2014 cl16 5/12/3006 8902 1
28/5/2014 cl16 5/12/3006 893 1
28/5/2014 cl7 5/12/3009 89022 2
31/5/2014 cl2 5/12/3025 8902 7
31/5/2014 cl4 5/12/3027 8902 2
31/5/2014 cl4 5/12/3027 8912 2
31/5/2014 cl16 5/12/3029 8902 2
31/5/2014 cl16 5/12/3029 8912 2
1/6/2014 cl5 5/12/3031 8902 2
1/6/2014 cl5 5/12/3031 8912 2
1/6/2014 cl5 5/12/3031 897 1
2/6/2014 cl7 5/12/3039 8902 4
2/6/2014 cl7 5/12/3039 8912 7
2/6/2014 cl7 5/12/3039 897 3
4/6/2014 cl6 5/12/3045 1401 2
4/6/2014 cl14 5/12/3055 891 175
5/6/2014 cl17 5/12/3056 8902 4
5/6/2014 cl17 5/12/3056 8912 10
5/6/2014 cl17 5/12/3056 8912 0
5/6/2014 cl17 5/12/3056 897 1
5/6/2014 cl14 5/12/3061 891 112
9/6/2014 cl7 5/12/3071 89022 6
9/6/2014 cl15 5/12/3072 8902 4
9/6/2014 cl15 5/12/3072 8912 8
9/6/2014 cl15 5/12/3072 897 2
10/6/2014 cl15 5/12/3082 8912 18
10/6/2014 cl2 5/12/3085 893 3
11/6/2014 cl18 5/12/3089 8902 4
11/6/2014 cl18 5/12/3089 8912 6
11/6/2014 cl18 5/12/3089 897 2
12/6/2014 cl8 5/12/3092 8902 2
12/6/2014 cl8 5/12/3092 8912 3
12/6/2014 cl8 5/12/3092 897 1
22/10/2014 cl15 5/12/3714 1789 1
22/10/2014 cl15 5/12/3714 8902 1
22/10/2014 cl15 5/12/3714 893 0
22/10/2014 cl15 5/12/3714 893 1
23/10/2014 cl18 5/12/3717 8902 1
23/10/2014 cl18 5/12/3717 893 1
23/10/2014 cl9 5/12/3718 1789 30
23/10/2014 cl9 5/12/3718 908 13
25/10/2014 cl15 5/12/3720 8902 20
25/10/2014 cl15 5/12/3720 908 10
26/10/2014 cl15 5/12/3725 1789 10
27/10/2014 cl18 5/12/3735 893 1
27/10/2014 cl5 5/12/3737 1789 12
27/10/2014 cl5 5/12/3737 8902 12
28/10/2014 cl6 5/12/3743 1789 5
4/11/2014 cl6 5/12/3784 1789 5
4/11/2014 cl6 5/12/3784 8902 5
5/11/2014 cl10 5/12/3786 8902 4
5/11/2014 cl10 5/12/3786 897 1
6/11/2014 cl5 5/12/3792 8902 10
6/11/2014 cl17 5/12/3794 8902 1
6/11/2014 cl17 5/12/3794 897 1
9/11/2014 cl8 5/12/3800 8902 2
9/11/2014 cl8 5/12/3800 897 2
10/11/2014 cl17 5/12/3804 8902 3
10/11/2014 cl17 5/12/3804 908 1
10/11/2014 cl14 5/12/3807 8902 2
10/11/2014 cl14 5/12/3807 897 1
12/11/2014 cl17 5/12/3814 8902 50
12/11/2014 cl17 5/12/3814 8912 50
12/11/2014 cl17 5/12/3814 897 25
15/11/2014 cl5 5/12/3826 8902 2
15/11/2014 cl5 5/12/3826 8912 2
15/11/2014 cl5 5/12/3826 897 1
15/11/2014 cl3 5/12/3827 8902 4
15/11/2014 cl3 5/12/3827 8902 0
15/11/2014 cl3 5/12/3827 8912 0
15/11/2014 cl3 5/12/3827 8912 4
15/11/2014 cl3 5/12/3827 897 1
17/11/2014 cl17 5/12/3833 8902 2
17/11/2014 cl17 5/12/3833 8912 2
17/11/2014 cl17 5/12/3833 897 1
17/11/2014 cl6 5/12/3836 8902 2
17/11/2014 cl6 5/12/3836 8912 1
18/11/2014 cl7 5/12/3840 89022 4
18/11/2014 cl15 5/12/3843 8902 2
18/11/2014 cl15 5/12/3843 893 3
20/11/2014 cl18 5/12/3852 897 1
22/11/2014 cl18 5/12/3857 8902 2
22/11/2014 cl18 5/12/3857 8912 4
22/11/2014 cl18 5/12/3857 897 1
1/12/2014 cl5 5/12/3902 8902 2
1/12/2014 cl5 5/12/3902 8912 3
1/12/2014 cl5 5/12/3902 897 1
6/12/2014 cl6 5/12/3922 8902 2
6/12/2014 cl6 5/12/3922 8912 2
7/12/2014 cl9 5/12/3926 1789 5
8/12/2014 cl18 5/12/3932 1789 3
8/12/2014 cl18 5/12/3932 897 1
8/12/2014 cl7 5/12/3939 1789 3
8/12/2014 cl7 5/12/3939 897 1
13/12/2014 cl12 5/12/3958 1789 2
14/12/2014 cl10 5/12/3964 8902 6
14/12/2014 cl10 5/12/3964 8912 7
14/12/2014 cl10 5/12/3964 897 1
14/12/2014 cl7 5/12/3965 89022 2
14/12/2014 cl3 5/12/3966 1789 11
14/12/2014 cl3 5/12/3966 897 4
15/12/2014 cl5 5/12/3972 8902 4
16/12/2014 cl6 5/12/3974 1789 8
16/12/2014 cl6 5/12/3974 897 3
16/12/2014 cl18 5/12/3975 8902 8
16/12/2014 cl18 5/12/3975 8912 14
16/12/2014 cl18 5/12/3975 897 2
17/12/2014 cl14 5/12/3977 8902 20
17/12/2014 cl14 5/12/3977 8912 20
17/12/2014 cl16 5/12/3978 897 1
17/12/2014 cl9 5/12/3979 1789 7
21/12/2014 cl3 5/12/3996 1789 2
21/12/2014 cl3 5/12/3996 8902 2
21/12/2014 cl3 5/12/3996 897 1
23/12/2014 cl18 5/12/4003 8902 6
23/12/2014 cl18 5/12/4003 8912 12
23/12/2014 cl18 5/12/4003 897 2
23/12/2014 cl3 5/12/4004 1789 8
23/12/2014 cl3 5/12/4004 8902 6
23/12/2014 cl3 5/12/4004 908 3
23/12/2014 cl3 5/12/4005 1789 4
23/12/2014 cl3 5/12/4005 8902 4
23/12/2014 cl3 5/12/4005 897 1
25/12/2014 cl17 5/12/4016 1789 4
25/12/2014 cl17 5/12/4016 908 2
27/12/2014 cl12 5/12/4021 8902 4
27/12/2014 cl12 5/12/4021 8912 4
28/12/2014 cl14 5/12/4029 897 4
31/12/2014 cl15 5/12/4035 8902 6
31/12/2014 cl15 5/12/4035 8912 40
31/12/2014 cl15 5/12/4035 897 18
31/12/2014 cl1 5/12/4043 1789 5
31/12/2014 cl1 5/12/4043 8902 2
3/1/2015 cl17 5/12/4054 8902 1
3/1/2015 cl17 5/12/4054 8912 1
5/1/2015 cl14 5/12/4058 89022 2
7/1/2015 cl14 5/12/4069 8902 6
7/1/2015 cl14 5/12/4069 8912 10
7/1/2015 cl14 5/12/4069 897 1
8/1/2015 cl14 5/12/4077 897 17
11/1/2015 cl6 5/12/4089 1789 60
11/1/2015 cl16 5/12/4090 897 10
12/1/2015 cl14 5/12/4093 89002 2
12/1/2015 cl14 5/12/4093 8912 3
12/1/2015 cl14 5/12/4093 897 1
12/1/2015 cl7 5/12/4099 8902 1
12/1/2015 cl7 5/12/4099 8912 1
12/1/2015 cl7 5/12/4099 897 1
13/1/2015 cl7 5/12/4102 890 20
13/1/2015 cl7 5/12/4102 8912 20
15/1/2015 cl6 5/12/4110 8902 2
19/1/2015 cl17 5/12/4123 893 3
21/1/2015 cl17 5/12/4133 8902 2
21/1/2015 cl17 5/12/4133 8912 6
21/1/2015 cl17 5/12/4133 897 1
22/1/2015 cl18 5/12/4138 8902 2
22/1/2015 cl18 5/12/4138 8912 4
25/1/2015 cl6 5/12/4147 8902 2
25/1/2015 cl6 5/12/4147 897 2
28/1/2015 cl7 5/12/4158 1789 3
29/1/2015 cl17 5/12/4165 8902 2
29/1/2015 cl17 5/12/4165 8912 2
29/1/2015 cl17 5/12/4165 897 2
31/1/2015 cl9 5/12/4173 893 1
1/2/2015 cl14 5/12/4178 1789 6
1/2/2015 cl14 5/12/4178 8902 6
1/2/2015 cl14 5/12/4178 897 1
1/2/2015 cl17 5/12/4179 1789 2
1/2/2015 cl17 5/12/4179 8902 2
9/2/2015 cl15 5/12/4220 1789 1
14/2/2015 cl16 5/12/4242 8902 2
14/2/2015 cl16 5/12/4242 8912 2
14/2/2015 cl16 5/12/4242 897 1
14/2/2015 cl9 5/12/4244 893 2
15/2/2015 cl13 5/12/4246 89022 2
17/2/2015 cl17 5/12/4257 8902 4
17/2/2015 cl17 5/12/4257 8912 12
19/2/2015 cl14 5/12/4271 1789 5
19/2/2015 cl14 5/12/4271 897 1
21/2/2015 cl14 5/12/4278 8902 2
21/2/2015 cl14 5/12/4278 8912 3
21/2/2015 cl14 5/12/4278 897 1
24/2/2015 cl15 5/12/4301 8902 2
24/2/2015 cl15 5/12/4301 8912 2
26/2/2015 cl1 5/12/4308 1789 2
4/3/2015 cl13 5/12/4341 8902 2
4/3/2015 cl13 5/12/4341 8912 2
4/3/2015 cl13 5/12/4341 893 1
4/3/2015 cl13 5/12/4341 897 2
4/3/2015 cl17 5/12/4344 8902 2
4/3/2015 cl17 5/12/4344 8912 1
4/3/2015 cl17 5/12/4344 897 1
5/3/2015 cl10 5/12/4348 8902 2
5/3/2015 cl10 5/12/4348 8912 2
5/3/2015 cl10 5/12/4348 897 1
5/3/2015 cl16 5/12/4350 89002 2
5/3/2015 cl16 5/12/4350 8912 2
7/3/2015 cl4 5/12/4355 1789 3
7/3/2015 cl8 5/12/4357 8902 2
7/3/2015 cl8 5/12/4357 8912 0
7/3/2015 cl8 5/12/4357 8912 2
7/3/2015 cl8 5/12/4357 897 1
8/3/2015 cl9 5/12/4362 8902 16
8/3/2015 cl9 5/12/4362 8912 16
15/3/2015 cl14 5/12/4403 8902 2
15/3/2015 cl14 5/12/4403 8912 2
15/3/2015 cl14 5/12/4403 897 1
2/11/2014 cl17 5/12/3778 2249 1
11/3/2015 cl16 5/12/4388 767 1
8/2/2014 cl6 5/12/2322 866 3
26/2/2014 cl7 5/12/2441 866 1
29/3/2014 cl5 5/12/2652 866 2
1/2/2015 cl17 5/12/4181 866 1
2/11/2014 cl17 5/12/3778 5895 1
2/11/2014 cl17 5/12/3778 5896 1
21/6/2014 cl13 5/12/3139 1810 2
22/12/2014 cl11 5/12/4001 1816 1
1/1/2014 cl15 5/12/2122 1885 1
1/1/2014 cl14 5/12/2123 183 1
1/1/2014 cl14 5/12/2123 2 1
1/1/2014 cl14 5/12/2125 264 2
1/1/2014 cl14 5/12/2125 266 3
2/1/2014 cl10 5/12/2129 264 7
2/1/2014 cl7 5/12/2131 263 2
2/1/2014 cl11 5/12/2132 184 1
4/1/2014 cl13 5/12/2133 183 8
4/1/2014 cl17 5/12/2134 184 2
4/1/2014 cl12 5/12/2135 184 3
4/1/2014 cl3 May-91 263 2
5/1/2014 cl3 5/12/2139 264 6
5/1/2014 cl3 5/12/2141 183 3
5/1/2014 cl18 5/12/2149 268 3
5/1/2014 cl9 5/12/2151 184 2
5/1/2014 cl9 5/12/2151 263 4
5/1/2014 cl9 5/12/2151 404 1
6/1/2014 cl3 5/12/2155 183 3
8/1/2014 cl5 5/12/2159 183 2
9/1/2014 cl14 5/12/2162 184 2
9/1/2014 cl6 5/12/2165 184 1
9/1/2014 cl6 5/12/2165 264 1
11/1/2014 cl17 5/12/2168 184 1
11/1/2014 cl17 5/12/2168 264 5
11/1/2014 cl7 5/12/2169 183 2
11/1/2014 cl15 5/12/2170 184 1
11/1/2014 cl14 5/12/2171 1030 1
11/1/2014 cl14 5/12/2171 264 1
11/1/2014 cl10 5/12/2172 184 1
12/1/2014 cl13 5/12/2175 184 0
12/1/2014 cl13 5/12/2175 184 5
12/1/2014 cl10 5/12/2176 184 2
10/3/2014 cl18 5/12/2527 556 3
1/4/2014 cl7 5/12/2672 556 3
9/4/2014 cl16 5/12/2728 1174 2
12/4/2014 cl16 5/12/2741 556 1
15/4/2014 cl15 5/12/2769 556 3
16/4/2014 cl18 5/12/2772 1840 1
17/4/2014 cl9 5/12/2785 557 2
28/4/2014 cl16 5/12/2831 1375 1
29/4/2014 cl13 5/12/2845 1174 2
30/4/2014 cl16 5/12/2856 557 12
6/5/2014 cl12 5/12/2880 1375 1
10/5/2014 cl17 5/12/2891 1375 1
14/5/2014 cl16 5/12/2919 1174 1
18/5/2014 cl9 5/12/2936 557 4
21/5/2014 cl3 5/12/2966 557 4
22/5/2014 cl16 5/12/2974 1375 3
24/5/2014 cl16 5/12/2978 1375 1
25/5/2014 cl12 5/12/2988 556 4
28/5/2014 cl7 5/12/3009 1840 2
4/6/2014 cl4 5/12/3054 556 2
5/6/2014 cl9 5/12/3059 557 4
9/6/2014 cl7 5/12/3071 80017 2
10/6/2014 cl16 5/12/3079 556 2
14/6/2014 cl6 5/12/3100 556 1
16/6/2014 cl16 5/12/3110 557 1
16/6/2014 cl16 5/12/3110 80017 6
22/6/2014 cl5 5/12/3147 375 1
28/6/2014 cl10 5/12/3183 375 4
28/6/2014 cl10 5/12/3183 80017 2
1/7/2014 cl15 5/12/3203 556 3
2/7/2014 cl9 5/12/3207 557 4
2/7/2014 cl16 5/12/3210 557 8
12/7/2014 cl16 5/12/3254 557 11
15/7/2014 cl7 5/12/3281 1840 1
15/7/2014 cl15 5/12/3282 556 2
15/7/2014 cl3 5/12/3283 557 8
21/7/2014 cl7 5/12/3322 1840 1
23/7/2014 cl18 5/12/3341 1375 1
13/8/2014 cl12 5/12/3400 556 1
19/8/2014 cl10 5/12/3422 1840 1
23/8/2014 cl5 5/12/3436 556 1
27/8/2014 cl7 5/12/3467 1174 1
4/9/2014 cl17 5/12/3498 375 1
13/9/2014 cl10 5/12/3547 1174 1
20/9/2014 cl3 5/12/3592 557 8
23/9/2014 cl3 5/12/3616 557 4
25/9/2014 cl9 5/12/3623 557 8
8/1/2015 cl16 5/12/4076 94 10
10/1/2015 cl7 5/12/4079 611111 20
10/1/2015 cl6 5/12/4082 1206 16
10/1/2015 cl6 5/12/4082 611111 16
11/1/2015 cl6 5/12/4089 56 30
11/1/2015 cl6 5/12/4089 611111 75
13/1/2015 cl9 5/12/4101 1206 23
13/1/2015 cl9 5/12/4101 56 2
13/1/2015 cl9 5/12/4101 611111 130
13/1/2015 cl9 5/12/4101 612 36
13/1/2015 cl9 5/12/4101 94 2
14/1/2015 cl8 5/12/4104 56 2
14/1/2015 cl8 5/12/4104 611111 4
14/1/2015 cl5 5/12/4106 1206 2000
19/1/2015 cl16 5/12/4124 1351 3
20/1/2015 cl6 5/12/4126 611111 20
20/1/2015 cl6 5/12/4126 6161 40
20/1/2015 cl9 5/12/4127 1351 64
20/1/2015 cl6 5/12/4129 611111 20
20/1/2015 cl6 5/12/4129 6161 40
20/1/2015 cl18 5/12/4132 6161 60
21/1/2015 cl16 5/12/4135 1206 20
21/1/2015 cl16 5/12/4135 56 8
21/1/2015 cl16 5/12/4135 611111 20
21/1/2015 cl16 5/12/4135 6161 60
27/1/2015 cl9 5/12/4154 56 15
27/1/2015 cl17 5/12/4156 1206 6
27/1/2015 cl17 5/12/4156 56 2
27/1/2015 cl17 5/12/4156 611111 15
27/1/2015 cl11 5/12/4157 611111 40
28/1/2015 cl7 5/12/4158 1351 6
28/1/2015 cl7 5/12/4158 56 2
28/1/2015 cl7 5/12/4158 611111 4
28/1/2015 cl7 5/12/4160 1206 40
28/1/2015 cl7 5/12/4160 611111 40
29/1/2015 cl3 5/12/4163 1206 50
29/1/2015 cl3 5/12/4163 56 1
29/1/2015 cl3 5/12/4163 611111 300
29/1/2015 cl8 5/12/4168 1206 10
29/1/2015 cl8 5/12/4168 611111 20
31/1/2015 cl9 5/12/4171 611111 16
31/1/2015 cl8 5/12/4172 611111 26
31/1/2015 cl8 5/12/4172 6161 80
31/1/2015 cl18 5/12/4174 56 1
1/2/2015 cl13 5/12/4176 6161 15
1/2/2015 cl17 5/12/4179 1206 15
1/2/2015 cl17 5/12/4179 612 15
2/2/2015 cl9 5/12/4190 6 55
4/2/2015 cl7 5/12/4197 1206 6
4/2/2015 cl7 5/12/4197 612 6
5/2/2015 cl9 5/12/4203 1206 10
5/2/2015 cl9 5/12/4203 6161 20
5/2/2015 cl9 5/12/4203 94 4
7/2/2015 cl18 5/12/4208 56 4
7/2/2015 cl4 5/12/4209 1351 4
7/2/2015 cl5 5/12/4213 1206 10
7/2/2015 cl5 5/12/4213 612 10
7/2/2015 cl10 5/12/4214 1206 10
7/2/2015 cl10 5/12/4214 612 10
7/2/2015 cl9 5/12/4215 1206 35
7/2/2015 cl9 5/12/4215 6 35
8/2/2015 cl15 5/12/4219 611111 8
9/2/2015 cl15 5/12/4220 6 40
9/2/2015 cl9 5/12/4221 6161 6
9/2/2015 cl18 5/12/4222 6 30
9/2/2015 cl18 5/12/4222 6 0
10/2/2015 cl9 5/12/4229 1206 400
10/2/2015 cl9 5/12/4229 6 400
12/2/2015 cl3 5/12/4234 6 20
12/2/2015 cl15 5/12/4238 1206 5
15/2/2015 cl11 5/12/4247 6 100
15/2/2015 cl9 5/12/4248 1206 8
15/2/2015 cl9 5/12/4248 612 8
16/2/2015 cl6 5/12/4254 1206 16
16/2/2015 cl6 5/12/4254 6 1
17/2/2015 cl17 5/12/4257 612 15
17/2/2015 cl13 5/12/4260 56 9
18/2/2015 cl17 5/12/4266 6 12
19/2/2015 cl15 5/12/4270 6 50
21/2/2015 cl4 5/12/4277 56 2
21/2/2015 cl4 5/12/4277 6 60
22/2/2015 cl8 5/12/4283 56 2
22/2/2015 cl8 5/12/4284 6 12
22/2/2015 cl8 5/12/4289 1206 19
22/2/2015 cl8 5/12/4289 6 19
23/2/2015 cl12 5/12/4293 1206 3
23/2/2015 cl12 5/12/4293 612 3
23/2/2015 cl18 5/12/4295 56 1
24/2/2015 cl17 5/12/4298 56 0
24/2/2015 cl17 5/12/4298 56 20
24/2/2015 cl9 5/12/4300 1206 15
24/2/2015 cl9 5/12/4300 56 10
24/2/2015 cl9 5/12/4300 6 15
25/2/2015 cl18 5/12/4304 6 10
26/2/2015 cl1 5/12/4308 1206 10
26/2/2015 cl1 5/12/4308 6 20
26/2/2015 cl9 5/12/4312 1206 2
26/2/2015 cl9 5/12/4312 6 2
1/3/2015 cl18 5/12/4322 6 40
1/3/2015 cl11 5/12/4326 94 2
2/3/2015 cl18 5/12/4330 6 8
2/3/2015 cl9 5/12/4332 612 20
3/3/2015 cl4 5/12/4336 1206 40
5/3/2015 cl16 5/12/4350 6 28
5/3/2015 cl16 5/12/4350 6161 100
5/3/2015 cl5 5/12/4352 56 1
5/3/2015 cl5 5/12/4352 6 4
7/3/2015 cl18 5/12/4354 6 28
8/3/2015 cl17 5/12/4363 56 2
8/3/2015 cl17 5/12/4363 612 10
9/3/2015 cl9 5/12/4373 6161 50
9/3/2015 cl10 5/12/4374 6161 70
10/3/2015 cl12 5/12/4376 56 4
10/3/2015 cl18 5/12/4377 56 30
10/3/2015 cl18 5/12/4377 612 36
10/3/2015 cl15 5/12/4381 612 270
11/3/2015 cl18 5/12/4386 1206 24
11/3/2015 cl18 5/12/4386 612 24
11/3/2015 cl18 5/12/4386 6161 28
11/3/2015 cl10 5/12/4387 612 50
11/3/2015 cl10 5/12/4387 6161 50
11/3/2015 cl2 5/12/4390 612 16
11/3/2015 cl2 5/12/4390 6161 90
12/3/2015 cl10 5/12/4391 56 4
12/3/2015 cl16 5/12/4392 1206 8
12/3/2015 cl16 5/12/4392 612 8
12/3/2015 cl13 5/12/4393 1351 2
15/3/2015 cl17 5/12/4401 56 2
1/1/2014 cl13 5/12/2124 211 0
1/1/2014 cl13 5/12/2124 211 1
2/1/2014 cl10 5/12/2129 2306 4
2/1/2014 cl10 5/12/2130 2431 2
2/1/2014 cl7 5/12/2131 2306 1
4/1/2014 cl13 5/12/2133 2306 5
4/1/2014 cl17 5/12/2134 2293 2
4/1/2014 cl12 5/12/2135 2293 1
4/1/2014 cl3 May-91 2307 1
5/1/2014 cl3 5/12/2141 2292 1
5/1/2014 cl4 5/12/2145 1060 1
6/1/2014 cl15 5/12/2154 2285 1
6/1/2014 cl15 5/12/2154 2293 1
6/1/2014 cl15 5/12/2154 2430 1
8/1/2014 cl5 5/12/2159 222 1
8/1/2014 cl5 5/12/2159 2293 2
9/1/2014 cl14 5/12/2162 2293 1
9/1/2014 cl17 5/12/2164 2293 1
9/1/2014 cl6 5/12/2165 2392 2
11/1/2014 cl7 5/12/2169 2307 1
11/1/2014 cl5 5/12/2173 2306 2
12/1/2014 cl13 5/12/2175 2293 1
12/1/2014 cl10 5/12/2176 2306 1
12/1/2014 cl10 5/12/2176 2392 1
12/1/2014 cl3 5/12/2178 2307 1
13/1/2014 cl13 5/12/2186 2293 2
14/1/2014 cl17 5/12/2190 2293 1
15/1/2014 cl3 5/12/2196 2307 1
16/1/2014 cl16 5/12/2198 2292 3
18/1/2014 cl13 5/12/2203 2392 3
18/1/2014 cl15 5/12/2204 2308 3
18/1/2014 cl6 5/12/2207 2392 1
19/1/2014 cl17 5/12/2210 2320 1
21/1/2014 cl5 5/12/2219 1845 1
21/1/2014 cl12 5/12/2221 1046 1
21/1/2014 cl12 5/12/2221 1845 1
21/1/2014 cl12 5/12/2221 2315 1
22/1/2014 cl10 5/12/2232 2306 11
 
Upvote 0
Dear All
in this example, how to check for some items like:601 - 89 -1000 - 1000 - 6250- 2233222- 442233 - 1845 - 1856 - 2306 what if they been soled to some clients like :cl1 - cl5 -cl3 - cl17 - cl22 - cl45 -cl56 -ccl6 or not? and when the last time?
appreciate your support.
Thanks
 
Upvote 0

Forum statistics

Threads
1,214,996
Messages
6,122,636
Members
449,092
Latest member
bsb1122

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top