Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I remove Duplicate rows?
I have an excel spreadsheet that has 2 columns. Col A is customer# and Col B
is invoice #. A customer# can have many invoice#s A customer# can have many rows with the same inv#. An invoice# can only be associated with 1 customer# I need to create a spreadsheet that shows each customer with the associated invoice#. Each customer#/invoice# should only show once. for example: cust# invoice# 1 100 1 100 1 101 2 200 3 300 3 300 The result would be: cust# inv# 1 100 1 101 2 200 3 300 How do I get rid of the extra rows? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically remove duplicate data within a column? | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Preventing Duplicate Entries in rows | Excel Worksheet Functions | |||
Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |