| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Report duplicate rows
What I have is a sheet with duplicate URL’s in a column and I want to
know what rows the duplicates appear in. For example: Row URL 1 www.aaaa.com 2 www.xxxx.com 3 www.aaaa.com 4 www.aaaa.com 5 www.xxxx.com 6 www.ffff.com What I want to get is: Row URL Duplicate column rows 1 www.aaaa.com 1,3,4 2 www.xxxx.com 2,5 3 www.aaaa.com 1,3,4 4 www.aaaa.com 1,3,4 5 www.xxxx.com 2,5 6 www.ffff.com 6 Can anyone help? Cheers Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate rows into new rows based on row value | Excel Worksheet Functions | |||
| Duplicate rows, put in another value | Excel Worksheet Functions | |||
| duplicate rows | Excel Discussion (Misc queries) | |||
| duplicate rows | Excel Discussion (Misc queries) | |||
| Add totals at end of the report with unknow number of rows with VB | New Users to Excel | |||
Threaded Mode
