| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure if this is possible...
Here is what I have.
RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD What I want to do is delete all of the sales orders that are identical. Essentially what I want the list to look like is this. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD I know how to "Identify duplicate values in a range" with a specific color, but I wanted to know if there is anyway to set up a macro or a formula that will delete an entire row if the sales order matches another. However, I do need one of those sales orders and it's accompanying info to remain in the sheet. This list was easy to do by hand, just going through and deleting the rows with the same sales order, but keeping one, however, genearlly these lists are hundreds of rows long. I do auto filter for other applications on the sheets, but it would not be feasable to do that for this. I print these sheets out, and, I would not want to print a sheet for each individual sales order. Any Suggestions? Is this possible? I have an excel book but I cannot find what I am looking for here, maybe I just do not know the correct name for the action. Thank You in Advance!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not sure if this is possible...
Select the table, do datafilteradvanced filter, select unique records only, click OK Now copy the filtered table somewhere else or do it in one fell swoop when you apply the filter there is also an option called "copy t0 another location" Regards, Peo Sjoblom Ben wrote: Here is what I have. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD What I want to do is delete all of the sales orders that are identical. Essentially what I want the list to look like is this. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD I know how to "Identify duplicate values in a range" with a specific color, but I wanted to know if there is anyway to set up a macro or a formula that will delete an entire row if the sales order matches another. However, I do need one of those sales orders and it's accompanying info to remain in the sheet. This list was easy to do by hand, just going through and deleting the rows with the same sales order, but keeping one, however, genearlly these lists are hundreds of rows long. I do auto filter for other applications on the sheets, but it would not be feasable to do that for this. I print these sheets out, and, I would not want to print a sheet for each individual sales order. Any Suggestions? Is this possible? I have an excel book but I cannot find what I am looking for here, maybe I just do not know the correct name for the action. Thank You in Advance!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not sure if this is possible...
Create a helper column
Formula =COUNTIF($A$2:A2,A2)1 Adjust to suit Auto filter all the TRUE select filter range Edit Delete "Ben" wrote: Here is what I have. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD What I want to do is delete all of the sales orders that are identical. Essentially what I want the list to look like is this. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD I know how to "Identify duplicate values in a range" with a specific color, but I wanted to know if there is anyway to set up a macro or a formula that will delete an entire row if the sales order matches another. However, I do need one of those sales orders and it's accompanying info to remain in the sheet. This list was easy to do by hand, just going through and deleting the rows with the same sales order, but keeping one, however, genearlly these lists are hundreds of rows long. I do auto filter for other applications on the sheets, but it would not be feasable to do that for this. I print these sheets out, and, I would not want to print a sheet for each individual sales order. Any Suggestions? Is this possible? I have an excel book but I cannot find what I am looking for here, maybe I just do not know the correct name for the action. Thank You in Advance!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not sure if this is possible...
Select the columns then DataFilterAdvanced Filter
The List Range will be filled by your selection. In the criteria dialog enter B:B Checkmark on "Unique records" Copy to another range or filter in place. Gord Dibben MS Excel MVP On Tue, 2 Jan 2007 15:50:00 -0800, Ben wrote: Here is what I have. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD What I want to do is delete all of the sales orders that are identical. Essentially what I want the list to look like is this. RANK Sales Order DELIVERY STATION Date COMMENTS 1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD 1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD I know how to "Identify duplicate values in a range" with a specific color, but I wanted to know if there is anyway to set up a macro or a formula that will delete an entire row if the sales order matches another. However, I do need one of those sales orders and it's accompanying info to remain in the sheet. This list was easy to do by hand, just going through and deleting the rows with the same sales order, but keeping one, however, genearlly these lists are hundreds of rows long. I do auto filter for other applications on the sheets, but it would not be feasable to do that for this. I print these sheets out, and, I would not want to print a sheet for each individual sales order. Any Suggestions? Is this possible? I have an excel book but I cannot find what I am looking for here, maybe I just do not know the correct name for the action. Thank You in Advance!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
