Hi All,
i wish to match a range of data (Table 1) against a specified criteria (Table 2). I tried the delete duplicates option in excel but to no avail.
Once matched I wish for the specific column to be deleted.
I have attached an Excel file for reference.
I don't understand where you are finding a number 10 in A2:A17 in order to match to J1.
Please clarify
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi 10999989,
So for the attached sample, it will delete column B till Column J right, only left column A?
As B3 till J3 are matching the table 2 (Criteria).
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks