D
devdas777
There are 3 things I am attempting to accomplish
1. If a cell is blank, I want to populate the cell with text from an
adjacent cell while removing the text from the adjacent cell
2. I have a list of addresses. I want to filter the list to remove
duplicate names & addresses and retain the row which contains the most
information. For instance, I may have 2 entries for the same person with
only one entry containing phone number and email address info. How do I
filter this information to retain the entry with the most data?
3. Is there a search function that can be used to identify duplicates
sharing one or more columns of information?
Can anyone help?
1. If a cell is blank, I want to populate the cell with text from an
adjacent cell while removing the text from the adjacent cell
2. I have a list of addresses. I want to filter the list to remove
duplicate names & addresses and retain the row which contains the most
information. For instance, I may have 2 entries for the same person with
only one entry containing phone number and email address info. How do I
filter this information to retain the entry with the most data?
3. Is there a search function that can be used to identify duplicates
sharing one or more columns of information?
Can anyone help?