If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
duplicate records, how to identify and count
Hi
Have a look he http://www.cpearson.com/excel/duplicat.htm -- Andy. "vishal " wrote in message ... Hi , I have got stuck in this very cumbersome problem. I have downloaded around 12000 records in a cell. From cell A1 to going down to cell a12043. However, there are certain duplicate records in those 12000+ records. My problem is how to identify how many records are there and how to check for eg. a record ABC Inc. appears how many times. thanks Vishal --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
duplicate records, how to identify and count
You can get a count of unique records with:
=SUMPRODUCT(1/COUNTIF(A1:A12043,A1:A12043)) To see how many duplicates their are of each record, you could put this in B1 and fill down: =COUNTIF(A:A,A1) HTH Jason Atlanta, GA -----Original Message----- Hi , I have got stuck in this very cumbersome problem. I have downloaded around 12000 records in a cell. From cell A1 to going down to cell a12043. However, there are certain duplicate records in those 12000+ records. My problem is how to identify how many records are there and how to check for eg. a record ABC Inc. appears how many times. thanks Vishal --- Message posted from http://www.ExcelForum.com/ . |
#3
|
|||
|
|||
duplicate records, how to identify and count
Hi
just on a sidenote: this will count blank cells also. To omit blank cells try =SUMPRODUCT((A1:A12000"")/COUNTIF(A1:A12000,A1:A12000&"")) -- Regards Frank Kabel Frankfurt, Germany "Jason Morin" schrieb im Newsbeitrag ... You can get a count of unique records with: =SUMPRODUCT(1/COUNTIF(A1:A12043,A1:A12043)) To see how many duplicates their are of each record, you could put this in B1 and fill down: =COUNTIF(A:A,A1) HTH Jason Atlanta, GA -----Original Message----- Hi , I have got stuck in this very cumbersome problem. I have downloaded around 12000 records in a cell. From cell A1 to going down to cell a12043. However, there are certain duplicate records in those 12000+ records. My problem is how to identify how many records are there and how to check for eg. a record ABC Inc. appears how many times. thanks Vishal --- Message posted from http://www.ExcelForum.com/ . |
Thread Tools | |
Display Modes | |
|
|