melifreeman
New Member
- Joined
- Dec 4, 2020
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hi All,
You were a great help with my last issue so I'm hoping for some more assistance. I have a LARGE project coming up where I will need to track multiple sites and data. I'm hoping to find a way to extract data from one master spreadsheet of information that uses a date range AND a multiple site IDs to fill in the row of data. Below is a mock-up of the master layout. Basically I need it to pull like this:
If the date is between 2/16/21 and 2/18/21 AND the SITE ID includes SDF-03, ABC-01 and ADF-09.....data fills across the row
I can get the data to pull for the Site IDs but the second I try to put in a date range too both my formula (and my brain) goes off track. Any ideas??? Thanks in advance!
You were a great help with my last issue so I'm hoping for some more assistance. I have a LARGE project coming up where I will need to track multiple sites and data. I'm hoping to find a way to extract data from one master spreadsheet of information that uses a date range AND a multiple site IDs to fill in the row of data. Below is a mock-up of the master layout. Basically I need it to pull like this:
If the date is between 2/16/21 and 2/18/21 AND the SITE ID includes SDF-03, ABC-01 and ADF-09.....data fills across the row
I can get the data to pull for the Site IDs but the second I try to put in a date range too both my formula (and my brain) goes off track. Any ideas??? Thanks in advance!
DATE | SITE ID | SCHEDULED TIME | LAST NAME | FIRST NAME | ID | PHOTO REQ. | COMPLETE | NO SHOW | OTHER REASON FOR NON-COMPLETION |
16-Feb | SDF-03 | BUNNY | BUGS | 7790103 | YES | NO | NO ID | ||
16-Feb | ABC-01 | STARK | TONY | 8678989 | NO | YES | |||
16-Feb | ABC-02 | FUDD | ELMER | 9567875 | YES | YES | |||
17-Feb | ADF-09 | BANNER | BRUCE | 10456760 | YES | NO | YES | ||
17-Feb | ADF-09 | BUNNY | BUGS | 11345646 | YES | NO | NO ID | ||
18-Feb | ABC-01 | STARK | TONY | 12234532 | NO | YES | |||
16-Feb | ABC-02 | FUDD | ELMER | 13123418 | YES | YES | |||
16-Feb | ABC-01 | 1:01 PM | STARK | TONY | 1234567 | NO | YES | ||
18-Feb | SDF-03 | 2:15 PM | FUDD | ELMER | 3456789 | YES | YES | ||
18-Feb | ADF-09 | 1:30 PM | BANNER | BRUCE | 2345678 | YES | NO | YES | |
16-Feb | SDF-02 | 9:15 AM | BUNNY | BUGS | 4567890 | YES | NO | NO ID | |
17-Feb | ABC-01 | STARK | TONY | 5123446 | NO | YES | |||
17-Feb | ABC-02 | FUDD | ELMER | 6012331 | YES | YES | |||
16-Feb | ABC-01 | BANNER | BRUCE | 6901217 | YES | NO | YES |