| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for duplicate ranges
I have 100 rows of data. The first record occupies range C2:G2. The next record occupies row C3:G3 and so on through C1000:G1000. I would like to count the number of duplicate records found as you proceed down the list. For example, if C2:G2 contains 1,2,3,4,5; I would like to count how many records (thru the next 999) are also 1,2,3,4,5. I would like to place this count in cell I2. Can anyone help on this? Thanks :) -- yungexec ------------------------------------------------------------------------ yungexec's Profile: http://www.excelforum.com/member.php...o&userid=22593 View this thread: http://www.excelforum.com/showthread...hreadid=565444 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
| Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
