Duplicate Cells
Feb 20, 2007
I have a sheet where I input 8 columns of data from an email template which is sent to me throughout the day. I enter data in one row per email along the 8 columns. eg A1 to H1 then A2 to H2 etc.
Column C has the entry as a job number '123456'.
I need to be able to see if the same job number appears more than once.
In one week I have input 135 rows of data and have spotted 3 occasions where the same job number has been called in.
Any way I can set up a seperate sheet which will search and show duplicated rows from sheet 1.
View 9 Replies
ADVERTISEMENT
Nov 1, 2007
I feel as though I have spent enough time searching the previous posts to ask this question.
I have a 4 column sheet, column B has many cells with identical data. I want to delete all the rows that that have duplicate data in column B.
COLUMN A= Car Makers
COLUMN B= Models of cars
COLUMN C= color
COLUMN D= owner
I want to end up with rows that each contain unique info in COLUMN B.
View 9 Replies
View Related
Jan 15, 2009
I have a worksheet change event that prevents a person from entering a positive number in 2 different cells. If they enter a number in one cell, the other locks, and vice versa. The code is below.
View 4 Replies
View Related
Sep 24, 2009
Is there a formula I can use in B2 whereby if the value in A2 is identical to the value in any other cell in column A, then return the value "duplicate" in B2?
View 2 Replies
View Related
Jan 8, 2008
I've searched the forums, and there are a lot of similar questions, but not quite what I'm looking for.
I have a large list of song titles, in one column. As an example, Song A is listed 4 times, Song B is 10 times, and Song C is 6 times.
Is it possible for Excel to go from this:
Song A
Song A
Song A
Song A
Song B
Song B
Song B
Song B
Song B
Song B
Song B
Song B
Song B
Song B
Song C
Song C
Song C
Song C
Song C
Song C
to this:
04-Song A
10-Song B
06-Song C
The numbers wouldn't necessarily have to be in the same cell, as long as I can sort the list from highest to lowest numbers while keeping the song titles matched with the correct number of instances.
View 9 Replies
View Related
Mar 25, 2008
how would i run a macro to merge duplicate cells in a column
For example, i have lots of data in columns A, B and C
however some of the data in columns A and B is the same. Column C data never changes. so to make it easier to read, i would like to merge these cells (which are the same) together?
-ColumnA-
Cat
Cat
Cat
Dog
Dog
Dog
Dog
Mouse
Mouse
Mouse
Mouse
Mouse
would become.... (with all the other data the same)
-ColumnA-
Cat
Dog
Mouse
I dont want to lose any of the rows, as the data in column C is always different. I just want to merge the similar ones, so its easier to read.
Its a bit like this, but i cant even come close to getting this to work:
[url]
View 9 Replies
View Related
Aug 15, 2009
I have two columns of numbers (2003), some of which match. Each column is of a different length and is arranged in a different order. I need to find all the number matches between the two columns. I can sort them ascending numerically but the columns are still disjointed with only occasional number pairs being readily visible.
View 9 Replies
View Related
Jan 25, 2010
I have two columns each of 5000 cells. Some cells of column A are duplicated in column B. The duplicates are not necessarily on the same rows. How do I delete the duplicates?
I've spent hours researching for an answer and I've tried Data>Filter>Advanced Filter many many times and it does not work. The two columns just sit there. Shouldn't this be a very easy thing to do in Excel?
View 9 Replies
View Related
Aug 16, 2006
I have attached a spreadsheet where I need the cells B2 to B8 to return the number of Y/P's (in column D) by Unit (in column E). There are duplicate entries in column D, however, if entry is duplicated, it is only to be counted once. Is there a formula to be able to do this? I don't know anything about VBA so would prefer a formula if possible.
View 5 Replies
View Related
Jul 30, 2007
I want to make a report wherein the macro has to merge cells based on duplicate cell values in column A and to put corresponding data in columns into one cell which we do manually by pressing ALT+Enter.
How this can be done through a macro or other tricks as I need it for a large report and need to use repeatedly.
A sample WB is attached which explains more.
View 4 Replies
View Related
May 8, 2014
I have a sheet of over 20,000 rows, each with 2 columns. Column A is numerical, Column B is name and address. There are duplicate entries in Column B, but Column A has unique entries.
I need to have 1 row per unique name and address with the numerical data from Column A relevant to that name and address either in one cell comma separated, or in cell C,D,E,F etc...
View 1 Replies
View Related
Jan 25, 2013
I have text values in 2 different columns A and B. I can use the conditional formula to find and highlight duplicates but only if they are an exact match. How do I modify if they are not exact match but for example start with the same 3-4 text values?
View 1 Replies
View Related
Jun 20, 2013
How do I duplicate the values to say 4 times in a column?
So I have in a column,
dog
cat
bird
fish
I want to duplicate the above to look like this below,
dog
dog
dog
dog
cat
cat
cat
cat
bird
bird
bird
bird
fish
fish
fish
fish
I'll need to do this for 500 unique values 12 times each, so is there a formula to do this easily?
View 5 Replies
View Related
Jul 17, 2008
I'm use with this macro to Highlight duplicate cells BUT the macro highlight only from the second duplicate
I need to highlight ALL duplicate cells in column A:A .
FUNCTION like " =COUNTIF($A$1:$A$11,A1)>1 " it's not good for me in this case, i need it with a fast macro
View 9 Replies
View Related
Aug 12, 2009
how to even start this macro but i will like the macro to find duplicate with thin the same row and highlight it i have done with conditional formatting but the spreadsheet is about 3000 rows excel performance is super slow if anybody has a macro out there.
View 9 Replies
View Related
Oct 22, 2008
if the state, city and company name are the same, I need to make sure the address gets populated in the address column. I have included an attached sheet to clear this up.
For example,
Row 1 is Crazy Horse Saloon in Anchorage, AK and has an address and phone number
Row 2 is Crazy Horse Saloon in Anchorage, AK and does not have an address and phone number
I need it to be able to realize that the State, City, and Business all match and populate the missing information.
View 5 Replies
View Related
Dec 10, 2013
Checked for a while now for a match in my query but can't find one that matches. I have a column of data to which has multiple values in each cell separated by a comma I.e 1,1,12,37
I copy this column into a new sheet a:a then I'll run text to columns to separate the values into there own cells so the following columns now show this
a1 =1 b1=1 c1=12 etc
I'm now stuck as I need to clear the contents on the cells within range a1 to k1 that have duplicate values.
end result is a1=1 b1 is now blank c1 =12 etc
View 6 Replies
View Related
Jun 8, 2009
I have a spreadsheet that I have created as a door schedule for faculty members at our institution of higher education. The intention is for them to fill-in their office hours and courses along with a few other bits of information. One sheet should have their teaching and office hours and one sheet should not.
These are the cells that should be cleared once the sheet has been duplicated (F30, F31, G30, G31). Once the sheet is duplicated and those two cells' contents has been deleted, both sheets should be printed. Ideally, all of this would be initiated by clicking a hyperlink or something like that.
View 9 Replies
View Related
Feb 29, 2008
I have a spreadsheet with columns A to W populated with data and 2470 rows
Column A has email addresses in it (2470 rows)
Column B has email addresses that are bad and are duplicated of those found in Column A there are only 345 of them in column B.
I would like to compare columns A and B and highlight the email addresses in column A that are also found in column B.
OR: If column A has a duplicate found in column B I would like the word delete to be inserted into column C of that row so I can review and then delete later.
View 5 Replies
View Related
Apr 15, 2008
I have a workbook with 12 sheets, 1 for each month of the year. Each month has around 30,000 user IDs on it (this is a log of each time a user logs into our website). What I need to do is find out how many unique users have logged into our site for the whole year, or in other words, remove duplicate user ids accross the workbook. I realise that this will probably destroy my processor, so was wondering the best way to do it? I also have all this information in ONE spreadsheet if it would be easier? I just copied and pasted each month into a column (Jan is column A, feb in B, mar in C etc) I ran some code on this sheet to remove dupllicates from column A:E but this was taking AGES!
View 5 Replies
View Related
Aug 3, 2008
I was trying to create this certain tool using excel which queries data from database. I was successful in obtaining the data I need and paste it to my spreadsheet, however, there are some requirements I cannot create a solution with. Below is a description of my Excel file (which is also attached):
- There are 9 columns on my spreadsheet
- Number of records per data refresh are indefinite, for information in database are constantly being updated
- Several cells on the first column have exactly the same information
The requirements I cannot do are:
- For all cells on first column that have similar values, their corresponding data on column 5 should be concatenated
- Delete rows that have same data for column 1 except the first record found, place concatenated data on column 5 of first record
Example:..................
View 4 Replies
View Related
Feb 5, 2014
I have a sheet containing lots of information (lists of flight information to and from all countries). So entries are duplicated in the entire sheet. For example LITHUANIA, USA, CHINA... appears lots of times. I only need to highlight particular countries.
I would just use conditional formatting, but maybe there is a quicker way to do that?
So there is a list of 50 countries in one sheet and in another sheet I got all the info. I need those 50 countries from the list to be highlighted in the info sheet (sheet has many columns and rows).
View 6 Replies
View Related
May 17, 2014
I have a large compilation of data on an excel work sheet (I am using 2013). All cells relate to each other by means of dates, names, and other numeric values such as stock numbers, id numbers etc... In one column some stock numbers are repeated. I would like to know if there is a way to set up the program on this worksheet to highlight all repeating stock numbers, not only in the column but across the cells as well, in lieu of doing so manually.
View 1 Replies
View Related
Aug 8, 2014
I have a column that is filled with various car brands that a dealership might sell. The data in the cell may look like CHRYSLER; CHRYSLER; CHRYSLER which I would want to just say CHRYSLER. If the cell says CHRYSLER; FORD; CHRYSLER; FORD I want it to just say CHRYSLER; FORD.
View 1 Replies
View Related
Mar 10, 2009
I'm on Excel 2003 and have a sheet to track people who have read my emails. I want to know the answers to the questions below. I've included a fake sample to show what I'm looking at. The number of cells in each column is much higher and not the same per column. I've tried variations of MATCH, VLOOKUP, SUMPRODUCT, etc. but haven't found a good way to set up a formula.....
View 6 Replies
View Related
Sep 22, 2008
I have a spreadsheet that I need to delete duplicate rows in. However, in order to determine if a row is a duplicate I need to check 2 cells per row. In the attached file you will see that each row has 4 cells. I need to compare the cells in columns B and C with the B and C cells of the Row beneath. If the B and C cells match then it is considered a duplicate and one of the rows needs to be deleted. Also, there may be multiple duplicate rows.
For an example see rows 17, 18 and 19. I only need 1 row to remain.
I am looking for a vb script that would analyze a file with thousands of rows and delete the duplicates.
View 12 Replies
View Related
Sep 29, 2009
I have a large worksheet and I managed to duplicate data in a row of cells.
MOT 1/F1,
B/P 1f2,
B/P 1f2
In the string above I need to delete all text from the first comma to the end of the string so the above would look like:
MOT 1/F1
This is an example in one cell of many. The text prior to the first comma may or may not repeat and it is the only portion of the text I wish to keep. The first comma is not always in the same place (character count position).
View 2 Replies
View Related
Nov 5, 2007
What I have is a massive table of data (15k+ entries), which consists of 4 different tables merged together. I have a lot of duplicate entries. However, most of these entries have information in one or another columns that its duplicate does not.
What I need to do is:
Identify the duplicate entries (by part number, which is one of the columns).
Merge the duplicate entries. In the merging process, I need to carry information over, taking data that is currently in 2 or more rows and merging it into one row.
Here's an example:
column1 column2 column3 column4
row1 a . . d
row2 . b
row3 . . c
needs to turn into:
column1 column2 column3 column4
row1 a b c d
If I'm not explaining this well, I will do my best to clarify. My main question is, is there any way to automate this process (even partially)
View 14 Replies
View Related
May 1, 2012
I have a sheet which has the following Columns:
Name..........Sales..........Returns..........Net
These are columns B,C,D,E,
Because the data is imported, it shows one row for the person's sales and another for their returns like this:
Dave...........100...............0...............(Blank)
Dave..............0.............-20..............(Blank)
Fred............200...............0...............(Blank)
Andy..............0............-500..............(Blank)
What I am trying to do is get the net sales of 80 in either of Dave's rows in the Net column, then I can hide the duplicate row. However, this is complicated by the fact that names without returns, (like Fred in this example,) do not have a second row. (This also applies to those names without sales, but with returns, like Andy).
View 6 Replies
View Related
Feb 28, 2013
I would like to know how I can have a macro run on an excel sheet of mine.
I have a little database with a few names and email addresses submitted to me via web.
But some people tried to register to my services TWICE with a different name, but same email address (not smart eh)
I would like to run a macro on a column and have it search for duplicate values and highlight them in... blue perhaps.?
P.s. the column format is set to 'TEXT'
View 2 Replies
View Related
