| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Unique Changes
I have a very large spreadsheet with only 2 columns, looks like this below:
The first column is the part # The second column is the manufact. I want to make a third column to identify every part# that has more than one manufacturer, in this case it would be Part #D317001 because it has Jet004 & Let001 as vendors for the same part. Sounds easy but i cannot get this to work. I setup a pivot table but the list is 40,000 lines long. , please help if you can. #DNV DNV001 #DNV DNV001 #D317001 JET004 #D317001 LET001 #D317001 LET001 #D317001 JET004 EB184 TIM006 EB184 TIM006 EB185 TIM006 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Unique Changes
Data in b5:c18 and formula in column d... =IF(SUMPRODUCT(--($B$5:$B$18=B5),--($C$5:$C$18<C5))0,B5,"") -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Francis" wrote in message I have a very large spreadsheet with only 2 columns, looks like this below: The first column is the part # The second column is the manufact. I want to make a third column to identify every part# that has more than one manufacturer, in this case it would be Part #D317001 because it has Jet004 & Let001 as vendors for the same part. Sounds easy but i cannot get this to work. I setup a pivot table but the list is 40,000 lines long. , please help if you can. #DNV DNV001 #DNV DNV001 #D317001 JET004 #D317001 LET001 #D317001 LET001 #D317001 JET004 EB184 TIM006 EB184 TIM006 EB185 TIM006 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Unique Changes
Works great. Thank you.
"Jim Cone" wrote: Data in b5:c18 and formula in column d... =IF(SUMPRODUCT(--($B$5:$B$18=B5),--($C$5:$C$18<C5))0,B5,"") -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Francis" wrote in message I have a very large spreadsheet with only 2 columns, looks like this below: The first column is the part # The second column is the manufact. I want to make a third column to identify every part# that has more than one manufacturer, in this case it would be Part #D317001 because it has Jet004 & Let001 as vendors for the same part. Sounds easy but i cannot get this to work. I setup a pivot table but the list is 40,000 lines long. , please help if you can. #DNV DNV001 #DNV DNV001 #D317001 JET004 #D317001 LET001 #D317001 LET001 #D317001 JET004 EB184 TIM006 EB184 TIM006 EB185 TIM006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find unique data by row | Excel Worksheet Functions | |||
| Find unique value in list (TIME), not working | Excel Worksheet Functions | |||
| Find top date for unique fields | Excel Discussion (Misc queries) | |||
| Find Unique | Excel Discussion (Misc queries) | |||
| find Unique number | Excel Discussion (Misc queries) | |||
Linear Mode
