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
<tbody>
</tbody>
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
25-Nov-17 | 300123129 | M129129002 | Visit | |
29-Nov-17 | 300190332 | CC72801239 | No Visit | |
30-Nov-17 | 300920912 | F030000124 | Visit |
<tbody>
</tbody>
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