mohdamir1989
New Member
- Joined
- Oct 17, 2017
- Messages
- 42
Hi,
I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value "no visit") it should write redo.
For Example
[TABLE="width: 500"]
<tbody>[TR]
[TD]25-Nov-17[/TD]
[TD]300123129[/TD]
[TD]M129129002[/TD]
[TD]Visit[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29-Nov-17[/TD]
[TD]300190332[/TD]
[TD]CC72801239[/TD]
[TD][/TD]
[TD]No Visit[/TD]
[/TR]
[TR]
[TD]30-Nov-17[/TD]
[TD]300920912[/TD]
[TD]F030000124[/TD]
[TD]Visit[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This data is in sheet 1
Similar format is in sheet "Previous" Now if the value matches in other sheet within 1 Month. It should write redo.
I've gone through the web regarding this but couldn't understand right output.
Your guidance in this regards is highly appreciated.
Best Regards
I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value "no visit") it should write redo.
For Example
[TABLE="width: 500"]
<tbody>[TR]
[TD]25-Nov-17[/TD]
[TD]300123129[/TD]
[TD]M129129002[/TD]
[TD]Visit[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29-Nov-17[/TD]
[TD]300190332[/TD]
[TD]CC72801239[/TD]
[TD][/TD]
[TD]No Visit[/TD]
[/TR]
[TR]
[TD]30-Nov-17[/TD]
[TD]300920912[/TD]
[TD]F030000124[/TD]
[TD]Visit[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This data is in sheet 1
Similar format is in sheet "Previous" Now if the value matches in other sheet within 1 Month. It should write redo.
I've gone through the web regarding this but couldn't understand right output.
Your guidance in this regards is highly appreciated.
Best Regards