davidmyers
Board Regular
- Joined
- Jan 29, 2017
- Messages
- 88
- Office Version
- 2016
- Platform
- Windows
Hi,
Can't find a solution, and need a little help.
If possible I'd like to this with a formula.
Compare values in
Complaints!B2:B1350 (Whole column starting B2) In this range the values are not unique - same value on many rows.
with the range:
Memp-Only!A2:A143 (Whole column starting A2) Here all values are unique
I want to delete all rows in Complaints sheet that do not have a matching value in Memp-Only
Thanks for any help
David
Can't find a solution, and need a little help.
If possible I'd like to this with a formula.
Compare values in
Complaints!B2:B1350 (Whole column starting B2) In this range the values are not unique - same value on many rows.
with the range:
Memp-Only!A2:A143 (Whole column starting A2) Here all values are unique
I want to delete all rows in Complaints sheet that do not have a matching value in Memp-Only
Thanks for any help
David