Help Loop and Count if more than one unique

[broman5000]

Hi there,

Any help here would be much appreciated as I'm pressed for a deadline today

The file is about 90K rows, so this is just a little example of what i'm looking at

Here's what I need to provide

Look at Long Name in column F, Identify and Count the amount unique vendors in column D, Output what those unique vendor are correlated to Long Name in a format (spreadsheet or chart)...something easy to digest

I have attached the file as well...Once again Thank you for your time!!!




Concept Name
UNIT_ID
VENDOR_ID
Vendor Name
INVENTORY_UOM
Long Name


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


21321
212
10001962
SAVE ON SEAFOOD
LB
0309 BFG South Hills PA


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


21321
212
10022246
CLASSIC SEAFOODS
LB
0309 BFG South Hills PA


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
EA
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
EA
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI


6
8310
10001954
SUPERIOR FOODS COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
EA
8310 BFG Troy MI


6
8310
10001954
SUPERIOR FOODS COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI


6
8310
10007329
FORTUNE FISH COMPANY
LB
8310 BFG Troy MI

[SamT]

Copy Columns D and F to another sheet. Then with Data Menu, Filter >> Advanced Filter >> "Unique records only"

[p45cal]

perhaps…