G
G
My worksheet has the following columns:
Last Name, First Name, middle, suffix, DOB, Phone, address1, address2, city,
state, zip
The worksheet that has the data I need to remove from my worksheet has:
Last Name, First Name, DOB, Field4, Field5, Field6
(those are the actual column headings). The data is small enough that a
match on Last Name, First Name and DOB in the second sheet is assumed to be
the same person as in the first sheet. So for the three columns in the
second sheet, I need to remove the corresponding row in the first sheet. In
fact, a match on last name and DOB is probably close enough. I am being
asked to redo this differently, so I want something better than sorting and
manually deleting. And I do not see how I can match three different columns
with the lookup functions. Can the lookup functions do this?
________
Greg Stigers, MCSA
remember to vote for the answers you like
Last Name, First Name, middle, suffix, DOB, Phone, address1, address2, city,
state, zip
The worksheet that has the data I need to remove from my worksheet has:
Last Name, First Name, DOB, Field4, Field5, Field6
(those are the actual column headings). The data is small enough that a
match on Last Name, First Name and DOB in the second sheet is assumed to be
the same person as in the first sheet. So for the three columns in the
second sheet, I need to remove the corresponding row in the first sheet. In
fact, a match on last name and DOB is probably close enough. I am being
asked to redo this differently, so I want something better than sorting and
manually deleting. And I do not see how I can match three different columns
with the lookup functions. Can the lookup functions do this?
________
Greg Stigers, MCSA
remember to vote for the answers you like