Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Then formula help
A report that is pulled from SAP into Excel, version 2003, generates a list
of stores, by store number but the data includes duplicate information because each store may have 2 to 4 different account numbers assigned to it. Example of data below: STORE# SOff. TERR# 1 H04 L99 1 H04 L99 1 H04 L99 What formula or formulas can be used to somehow mark the duplicate store numbers so that it can be sorted and then deleted? I need to streamline the information to include each store only one time. My store lists are around 21 pages because of all the duplicate information. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If / Then formula help
hi
see this site... http://www.cpearson.com/Excel/Duplicates.aspx regards FSt1 "Melissa_RBTC" wrote: A report that is pulled from SAP into Excel, version 2003, generates a list of stores, by store number but the data includes duplicate information because each store may have 2 to 4 different account numbers assigned to it. Example of data below: STORE# SOff. TERR# 1 H04 L99 1 H04 L99 1 H04 L99 What formula or formulas can be used to somehow mark the duplicate store numbers so that it can be sorted and then deleted? I need to streamline the information to include each store only one time. My store lists are around 21 pages because of all the duplicate information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|