Chuckiedev
New member
- Joined
- Feb 9, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hello,
I am a guidance counselor and need help.
Here’s the deal.
I have an excel spreadsheet with about 2500 students. Some days it’s 2499 and other days it’s 2501. We assign the kids a mental health survey. When we run the report we get all “active” students. Column J says True if the student took the survey, False if they did not. I know three students took the test because my total numbers of true changed over the weekend. I’m trying to find who was true on Feb 8 but not Feb 5. (We asked the vendor to add time stamps but they declined)
On the February 6th tab I have =A1<>’Feb5’!A1 it worked.
When I try it on the Feb 8 tab it highlights everyone.
I just removed three students, and from the source sheet and it no longer worked.
I want it to compare columns A, B, and C on Tuesday results..
If A and B are the same on “Tuesday” and “Wednesday”, but C is different I want C to Highlight.(or something)
Please note, Chuck dropped out of school.. I think he is smoking pot down on the corner.
I am a guidance counselor and need help.
Here’s the deal.
I have an excel spreadsheet with about 2500 students. Some days it’s 2499 and other days it’s 2501. We assign the kids a mental health survey. When we run the report we get all “active” students. Column J says True if the student took the survey, False if they did not. I know three students took the test because my total numbers of true changed over the weekend. I’m trying to find who was true on Feb 8 but not Feb 5. (We asked the vendor to add time stamps but they declined)
On the February 6th tab I have =A1<>’Feb5’!A1 it worked.
When I try it on the Feb 8 tab it highlights everyone.
I just removed three students, and from the source sheet and it no longer worked.
I want it to compare columns A, B, and C on Tuesday results..
If A and B are the same on “Tuesday” and “Wednesday”, but C is different I want C to Highlight.(or something)
Please note, Chuck dropped out of school.. I think he is smoking pot down on the corner.
Tuesday | |||
Name | ID | Took Test | |
Mary | 1234 | False | |
Mark | 5678 | False | |
Luke | 2468 | True | |
John | 1357 | False | |
Chuck | 9119 | True | |
Bob | 1991 | True | |
Wednesday | |||
Name | ID | Took Test | |
Mary | 1234 | False | |
Mark | 5678 | True | |
Luke | 2468 | True | |
John | 1357 | False | |
Bob | 1991 | True | |
| | | |