Differance trend Query

M

MoyAA

ID Date Shift 1H414 1H418 1H214 1H218
1 13-Jan 1 0 4 0 1
2 13-Jan 2 6 5 0 2
3 13-Jan 3 0 0 0 1
4 14-Jan 1 0 1 0 2
5 14-Jan 2 0 5 0 3
6 14-Jan 3 0 0 0 0
7 15-Jan 1 0 3 2 0
8 15-Jan 2 5 3 1 0
9 15-Jan 3 0 1 0 0
10 16-Jan 1 0 7 0 0
11 16-Jan 2 3 7 0 1
12 16-Jan 3 0 0 0 0
13 17-Jan 1 5 1 0 1
14 17-Jan 2 11 0 0 1
15 17-Jan 3 0 0 0 0
16 18-Jan 1 1 0 0 0
17 18-Jan 2 5 0 0 0
18 18-Jan 3 0 0 0 0
19 19-Jan 1 4 1 0 0
20 19-Jan 2 12 5 3 0
21 19-Jan 3 0 1 0 0
22 20-Jan 1 0 0 0 0
23 20-Jan 2 12 0 0 0
24 20-Jan 3 0 0 0 0
25 21-Jan 1 15 1 0 0
26 21-Jan 2 11 7 1 0
27 21-Jan 3 0 0 0 0
28 22-Jan 1 0 0 3 1
29 22-Jan 2 0 1 4 0
30 22-Jan 3 0 0 0 0
31 23-Jan 1 12 0 3 1
32 23-Jan 2 7 0 1 0
33 23-Jan 3 0 0 0 0
34 24-Jan 1 0 0 0 0
35 24-Jan 2 2 4 3 0
36 24-Jan 3 0 0 0 0
37 25-Jan 1 0 0 0 0
38 25-Jan 2 0 4 0 0
39 25-Jan 3 0 0 0 0
40 26-Jan 1 7 2 2 0
41 26-Jan 2 19 4 3 0
42 26-Jan 3 2 2 0 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Differance trend query 2
How to getting text labels to show up in scatter chart. 0
15 minute data to daily data 1
VBA - (re-) Set a Table Style 2
Countifs or a pivot 1
Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value 7
Make Y-axis values correspond to x- axis value 1

Top