Newbie987654321
New Member
- Joined
- Mar 13, 2018
- Messages
- 9
Hi Guys. I so badly need your help.
Here's what I wanted to do.
I wanted to know if the following names from Table 1 have already submitted the documents considering that they submitted it after the Actual Date with the same infraction.
Table 2 shows the documents submitted.
I need a formula that would show if it has been "Submitted" or still "Pending" under the STATUS Column.
Those formulas that may need Ctrl+Shift+Enter, I need to get rid of that because I have multiple rows to drag it to.
[TABLE="width: 368"]
<tbody>[TR]
[TD]Table 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STATUS
[/TD]
[TD]Name
[/TD]
[TD]Supervisor
[/TD]
[TD]Infraction
[/TD]
[TD]Actual Date
[/TD]
[/TR]
[TR]
[TD]Submitted
[/TD]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]18-Mar-18
[/TD]
[/TR]
[TR]
[TD]Pending
[/TD]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]23-Mar-18
[/TD]
[/TR]
[TR]
[TD]Submitted
[/TD]
[TD]Carl Lee
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]18-Mar-18
[/TD]
[/TR]
[TR]
[TD]Pending
[/TD]
[TD]Carl Lee
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]23-Mar-18
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Supervisor
[/TD]
[TD]Frequency
[/TD]
[TD]Date Submitted
[/TD]
[TD]Infraction
[/TD]
[/TR]
[TR]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]1st instance
[/TD]
[TD]21-Mar-18
[/TD]
[TD]Tardiness
[/TD]
[/TR]
[TR]
[TD]Carl Lee
[/TD]
[TD]Sue Pervisor
[/TD]
[TD]1st instance
[/TD]
[TD]8-Mar-18
[/TD]
[TD]Tardiness
[/TD]
[/TR]
[TR]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]1st instance
[/TD]
[TD]21-Mar-18
[/TD]
[TD]Absence
[/TD]
[/TR]
[TR]
[TD]Carl Lee
[/TD]
[TD]Sue Pervisor
[/TD]
[TD]1st instance
[/TD]
[TD]8-Mar-18
[/TD]
[TD]Absence
[/TD]
[/TR]
</tbody>[/TABLE]
Here's what I wanted to do.
I wanted to know if the following names from Table 1 have already submitted the documents considering that they submitted it after the Actual Date with the same infraction.
Table 2 shows the documents submitted.
I need a formula that would show if it has been "Submitted" or still "Pending" under the STATUS Column.
Those formulas that may need Ctrl+Shift+Enter, I need to get rid of that because I have multiple rows to drag it to.
[TABLE="width: 368"]
<tbody>[TR]
[TD]Table 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STATUS
[/TD]
[TD]Name
[/TD]
[TD]Supervisor
[/TD]
[TD]Infraction
[/TD]
[TD]Actual Date
[/TD]
[/TR]
[TR]
[TD]Submitted
[/TD]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]18-Mar-18
[/TD]
[/TR]
[TR]
[TD]Pending
[/TD]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]23-Mar-18
[/TD]
[/TR]
[TR]
[TD]Submitted
[/TD]
[TD]Carl Lee
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]18-Mar-18
[/TD]
[/TR]
[TR]
[TD]Pending
[/TD]
[TD]Carl Lee
[/TD]
[TD]April Allens
[/TD]
[TD]Tardiness
[/TD]
[TD]23-Mar-18
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Supervisor
[/TD]
[TD]Frequency
[/TD]
[TD]Date Submitted
[/TD]
[TD]Infraction
[/TD]
[/TR]
[TR]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]1st instance
[/TD]
[TD]21-Mar-18
[/TD]
[TD]Tardiness
[/TD]
[/TR]
[TR]
[TD]Carl Lee
[/TD]
[TD]Sue Pervisor
[/TD]
[TD]1st instance
[/TD]
[TD]8-Mar-18
[/TD]
[TD]Tardiness
[/TD]
[/TR]
[TR]
[TD]John Smith
[/TD]
[TD]April Allens
[/TD]
[TD]1st instance
[/TD]
[TD]21-Mar-18
[/TD]
[TD]Absence
[/TD]
[/TR]
[TR]
[TD]Carl Lee
[/TD]
[TD]Sue Pervisor
[/TD]
[TD]1st instance
[/TD]
[TD]8-Mar-18
[/TD]
[TD]Absence
[/TD]
[/TR]
</tbody>[/TABLE]