| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check rows for duplicate references and add related data
Excel 2002. I have a sheet containing 27K rows of data, each row
referenced by a reference number in column A. Many of the rows have duplicate or triplicate references e.g. 01/010/0002 01/010/0014 01/012/0020 01/012/0020 01/012/0020 01/013/0134 01/014/0004 01/014/0004 but contain different values in subsequent columns. What I need to do is identify the rows where the references are the same and sum data in the corresponding rows e.g. for 01/012/0020 above I need to sum the contents of column C for the 3 related rows and for 01/014/0004 sum the contents of column C for the 2 related rows. I know how to identify duplicates in column A using =countif(A:A,A1) which will give me 2 where there is a duplicate entry or 3 where there is a triplicate entry, but I am not sure where to go from there. I imagine that I need to extract the data to another range to sum the data in column C for each reference. Grateful for any assistance. -- Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving duplicate data in rows to columns with same name | Excel Discussion (Misc queries) | |||
| Row data duplicate check. | Excel Discussion (Misc queries) | |||
| Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
| Check for duplicate data | Excel Worksheet Functions | |||
| Comparing 2 rows for duplicate data | Excel Programming | |||
![Robert[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
