I have thousands of questions & answers arranged in two consecutive columns as shown below. I want to delete all the duplicate Question and Answer sets keeping only one set. Sometimes questions may be same but answers differ as shown below. In this case I want to delete the colored/highlighted range.
Question: xyz
Correct Answer: abc
Question: def
Correct Answer: pqr
Question: xyz
Correct Answer: abc
Question: xyz
Correct Answer: asd
How to write a macro for this?
Hello Krishna234,
This macro will copy all unique questions and answers to a new worksheet named "Uniques". The macro assumes the questions and answers are on the ActiveSheet. You will need to change the range of the questions and answers to match what you are using. This example uses the range "A1:B1000". It's marked in red in the code. Copy this code and after inserting a Standard VBA Module into your Workbook, paste the code into it.
Sincerely,
Please Login or Register to view this content.
Leith Ross
Hello Leith Ross,
I tried the code. It indeed works as you have said, but the macro considers "Questions" and "Correct Answers" individually but not as a set. I mean each question has corresponding answer. The macro should treat set of questions and correct answers as a single entity. I am giving below the arrangements once again.
BEFORE RUNNING MACRO:
COLUMN A |COLUMN B
Question | What is your pet's name
Correct Answer | Doggy
Question | What is your name?
Correct Answer | Krishna
Question | What is your pet's name
Correct Answer | Doggy
Question | What is your pet's name
Correct Answer | Raaju
Question | What is your pet's name
Correct Answer | Raaju
AFTER RUNNING MACRO
COLUMN A |COLUMN B
Question | What is your pet's name
Correct Answer | Doggy
Question | What is your name?
Correct Answer | Krishna
Question | What is your pet's name
Correct Answer | Raaju
COLUMN A acts as labels. Its contents are fixed: Content of first cell is "Question" and that of second cell is "Correct Answer" and are repeated.
COLUMN B contains corresponding Question and answer: Content of first cell is for example "What is your pet's name" and that of second cell for example is "Doggy"
Truly
kRISHNA234
Last edited by Krishna234; 04-24-2007 at 11:02 AM.
I have written a code for the problem and I will be thankful to everyone who can find faults with it or suggests a better one.
Screen Shots before & after running the macro are attached (without macro) for your reference.Please Login or Register to view this content.
Regards
krishna
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks