Hello, would anybody be able to help?
In the table below, how can I filter the results on cells U5, U6and U7 based on the period selected ( start date on cell U1 and end Date on Cell U2)
The column D is where the reference dates....
Any help is welcome.
Thank you
In the table below, how can I filter the results on cells U5, U6and U7 based on the period selected ( start date on cell U1 and end Date on Cell U2)
The column D is where the reference dates....
Any help is welcome.
Thank you
| Book1 | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
| 1 | in | device | referrer | date | time | name | postcode | reason | travel | spare1 | spare2 | spare3 | spare4 | District | Month | Start Date | 4/1/24 | ||||||
| 2 | in | 750 | 81.149.159.151 | 3/3/24 | 9:52:10 | Mark | ol5 0dw | 5 | 1 | 0 | 0 | 0 | 0 | Tameside | Mar-24 | End Date | 12/31/25 | ||||||
| 3 | in | 750 | 81.149.159.151 | 6/4/24 | 9:35:57 | Ciara | M4 4EE | 5 | 2 | 0 | 0 | 0 | 0 | Manchester | Jun-24 | ||||||||
| 4 | in | 750 | 81.149.159.151 | 6/4/24 | 9:11:46 | Freya | SK15 3LH | 12 | 2 | 0 | 0 | 0 | 0 | Tameside | Jun-24 | Total | |||||||
| 5 | in | 750 | 81.149.159.151 | 6/4/24 | 19:02:25 | Jon | OL5 0QR | 5 | 0 | 0 | 0 | 0 | 0 | Tameside | Jun-24 | Individuals | 4 | ||||||
| 6 | in | 101 | 195.11.117.2 | 6/3/24 | 17:21:46 | Jon | OL5 0QR | 12 | 0 | 0 | 0 | 0 | 0 | Tameside | Jun-24 | Districts | 2 | ||||||
| 7 | in | 961 | 80.229.9.166 | 6/3/25 | 11:34:31 | Jon | OL5 0QR | 7 | 0 | 0 | 0 | 0 | 0 | Tameside | Jun-25 | artist | 3 | ||||||
| 8 | |||||||||||||||||||||||
| 9 | |||||||||||||||||||||||
New Data | |||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| P2:P9 | P2 | =IF(G2<>0,IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes1'!$A$1:$E$1040000,4,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes1'!$B$1:$E$1040000,3,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes2'!$A$1:$E$1040000,4,FALSE),IFERROR(VLOOKUP(G2,'[Vale sign in data analysis.xlsm]PostCodes2'!$B$1:$E$1040000,3,FALSE),"Not found")))),"") |
| Q2:Q9 | Q2 | =IF(D2<>0,TEXT(D2,"mmm-YY"),"") |
| U5 | U5 | =IFERROR(ROWS(UNIQUE(FILTER('New Data'!F2:F9998,'New Data'!$F2:$F9998<>""))),0) |
| U6 | U6 | =IFERROR(ROWS(UNIQUE(FILTER('New Data'!$P$2:$P$9998,'New Data'!$P$2:$P$9998<>""))),0) |
| U7 | U7 | =IFERROR(ROWS(UNIQUE(FILTER('New Data'!F2:'New Data'!F9998,'New Data'!I2:'New Data'!I9998=5))),0) |
