| I have looked on the net but can not find what I am looking for | ||||||||
I need to use the If statement and the VLOOKUP and match to find the correct answerer. Can you help
|
Last edited by a moderator:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I need to use the If statement and the VLOOKUP and match to find the correct answer.
- Thread starter Gerri
- Start date
Good Morning
If there is another formula to find the answer -- Could you help with that? I could use sort but that would take to long. I have about 50 of these to do with other data. I have a attached one that I sorted ---
If there is another formula to find the answer -- Could you help with that? I could use sort but that would take to long. I have about 50 of these to do with other data. I have a attached one that I sorted ---
Attachments
The answer should be 1
| (F) = 1,2,4 | (G) = 1 | (H) = not null | (I) = is null | (J) = 1 | K | ||
| 1 | 1 | 10/05/18 | 10/05/18 | 1 | 10/05/19 | 1 | (F) = 1,2,4 |
1 | 1 | 1 | 1 | 1 | 1 | 1 | (G) = 1 |
0 | 0 | 0 | 0 | 1 | 0 | 1 | (H) = not null |
0 | 0 | 0 | 0 | (I) = is null | |||
1 | 1 | 1 | 1 | (J) = 1 | |||
0 | 0 | 0 | Begin | End | |||
0 | 0 | 0 | 09/01/19 | 12/31/19 | |||
0 | 0 | 0 | 1 | Total | |||
0 | 0 | 0 | |||||
1 | 1 | 1 | 1 | 1 | 1 | ||
| Answer Should be 1 |
Attachments
Im sorry I did not check your file --- It has a macro -- I dont know macros. I did change the date because it was in the date range of Begin Date 09/01/2019 and End Date of 12/31/2019. I am sending you the spreadsheet I am working on I have a list of Data Element that number 174 Colums and about 370 rows. In each of them I have to answer about 50 Questions. The first question is Count of unique records where
PIRL 808 (Eligible Migrant and Seasonal Farmworker Status (WIOA sec. 167)) = 1, 2, or 4
and PIRL 941 (National Farmworker Jobs Program (NFJP)) = 1
and PIRL 1001 (Date of First Basic Career Service) is not null and
PIRL 1200 (Date of First Individualized Career Service) is null
and PIRL 1300 (Received Training) ≠1 and
PIRL 901 (Date of Program Exit) is within the reporting period
Reporting Period is Begin Date 07/01/2019 End Date is 12/31/2019 I have sent the report
PIRL 808 (Eligible Migrant and Seasonal Farmworker Status (WIOA sec. 167)) = 1, 2, or 4
and PIRL 941 (National Farmworker Jobs Program (NFJP)) = 1
and PIRL 1001 (Date of First Basic Career Service) is not null and
PIRL 1200 (Date of First Individualized Career Service) is null
and PIRL 1300 (Received Training) ≠1 and
PIRL 901 (Date of Program Exit) is within the reporting period
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |
Last edited:
Gerri
That file - sample
- needs to press [ Solve ] to see possible rows
- needs to press [ Reset ] to see all rows
No need to 'know' more ...
I moved those You above given ... to Sheet1 (2)
(( I changed dates to this format - to confirm that those are correct ))
> press [ Solve ] and You could see all steps results
after above is done
> press [ Reset ] to get normal view.
Your data has same features as always ... later more!
That file - sample
- needs to press [ Solve ] to see possible rows
- needs to press [ Reset ] to see all rows
No need to 'know' more ...
I moved those You above given ... to Sheet1 (2)
(( I changed dates to this format - to confirm that those are correct ))
> press [ Solve ] and You could see all steps results
after above is done
> press [ Reset ] to get normal view.
Your data has same features as always ... later more!