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
|
|||
|
|||
How do I get Excel to count identical rows in a list?
I have a large list of data and I need some way to get Excel to count the
number of identical rows. The list is sorted so that identical rows are adjacent to each other. I need excel to put a number in another column stating how many exact replicates of that row are present in the worksheet. If possible I would also like excel to delete the replicates and leave only one row with a count of the number of replicates it has deleted. I am using Excel 2002 on Windows XP Professional. |
#2
|
|||
|
|||
Hi
how many columns are filled with data?. you may use a formula such as =SUMPRODUCT(--($A$1$A$100=A1),--($B$1:$B$100=B1),--8$C$1:$C$100=C1)) and copy this down for all rows "Ali Dennis" wrote: I have a large list of data and I need some way to get Excel to count the number of identical rows. The list is sorted so that identical rows are adjacent to each other. I need excel to put a number in another column stating how many exact replicates of that row are present in the worksheet. If possible I would also like excel to delete the replicates and leave only one row with a count of the number of replicates it has deleted. I am using Excel 2002 on Windows XP Professional. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table Access 2000? | Air-ron | General Discussion | 2 | October 29th, 2004 06:19 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Drop-down list populated with linked Excel column | Garrett | Mailmerge | 1 | May 17th, 2004 04:09 AM |
Autofilter/filter in Excel only shows 1000 rows in dropdown list. | Sven Stian | Worksheet Functions | 2 | March 25th, 2004 08:07 AM |