I am trying to merge rows based on duplicate values in two columns. Specifically, look at the two screenshots below. If entries under Last Name (Column B) and Email (Column C) match in any two rows, then they should be merged.
This is what it looks like originally:
I use the following code to enter a name selected from a listbox to the end of a list of names named "nameList"
I please need some help to prevent the name being added if it already appears in the list and a messagebox to appear advising that the name was not added because it is already in the...
Sorry for what is probably silly newbie question. I have a mailing list with 8000 email addresses, and I want to remove all email addresses who have not opened an email in last 8 newsletters sent to reduce to only those who actively read the email.
I have column A containing 8000 email...
I want to Count the Duplicate entries in the column "SYMBOL" with the refeance of column "EXPIRY_DT" and also want to number them like...
IF 31-Mar-16 than BANKNIFTY-I , 28-Apr-16 than BANKNIFTY-II & 26-MAY-16 than BANKNIFTY-III
I have a challenge which I am struggling with. I need to highlight duplicates in rages across multiple sheets in a workbook.
There are 26 ranges which contain text values and the ranges are the same from sheets 1 to 10.
I have the following named Ranges
Activity ID Numeric, Unique --Key Field
Customer Name Name
Customer ID Numeric,
Ticket ID Numeric
SCIP Event Yes / No
What I am attempting to do, is Flag...
I am using the following macro to post dates from excel into outlook, however, each time I run the macro it duplicates the entry in Outlook. Any help on how to stop this would be greatly appreciated:
' Create the Outlook session
Set myOutlook =...
I was given a macro for this but it doesn't seem to work. Hopefully someone can help.
column A will contain a list of telephone numbers entered in this format: (xxx) yyy-zzzz which is how it would appear in the formula bar if the cell were selected. I need a macro that would eliminate all...
I can't find a code that suits my needs, so I come to ask for your help.
The basic idea I want to achieve is to have unique data in my sheet, but it's a bit more complicated then a basic RemoveDuplicates. There are some if's and but's I will try to explain as clear as I can.
I am looking for excel function to return less value in Duplicate names given below. Ex. if we take AAA has three duplicates with different values however, I need less value out of all the duplicates and should be return the less value as output, in this case value 100.00 should get as...
I have a very involved formula that counts data based on about 5 different criteria; however, the criteria is not defined by the name column. This is where the problem comes in. When I get the count of data that fulfills the criteria, there are a few anomaly items where the same person, in the...
I have some doubts about how to calculate this results.
Without using a pivot table, I need to know how many employees each manager has. For example: If I enter the name: "Zara" on the cell G1 I'll need to get the number 5 on the cell H1, because Zara has 5 employees even though there...
I have a database #1 of contact information consisting of e-mails, first name, last name, business name, etc. which contains many entries (rows) that need to be deleted. These entries would be deleted based on a secondary database #2 consisting of just e-mails.
If there are duplicates...
I have a large amount of data that contains a lot of duplicate records. The records can have different states but I just want to count the number of times a specific cell appears in the list of data, without removing duplicates.
I have identified potential fraud in a limited number of employees' time keeping postings and would like to figure out how to test if it is prevalent throughout the company.
Here's the scenario: Looking at daily time sheet records I identified that certain employees had identical daily time...
I tried to solve above problem using Data Validation formula but it does not help as per my wish. Because data validation does not work if somebody copy paste the duplicate values,it works when somebody types duplicate values in next column. So if I want to enter lot of urls to a...
I'm a welding inspector trying to develop a weld tracking sheet and am in need of a formula that counts types of welds from column-B but without duplicating a weld number from Column A. For example:
Weld#. weldType. Inspection. #ofwelds
This forum has served me well several times in the past while struggling with Excel, and I'm hoping you guys can come through for me now. No matter how much searching I do for this, the solutions provided to similar problems always boggle my mind a little too much for me to...
How can I specify the frequency / occurrence of repeating values that need to be found in a column or across different columns?
For example, if a column had 1,2,3,3,4,4,4, I want Excel to only find values that repeat 3 times, and the answer should be 4.
Someone gave a very good tip on how to...