identifying same or related products (franks results and what I need for results

  • Thread starter Thread starter terry
  • Start date Start date
T

terry

Description Product #1 Product #2 Product #3
Product #4 Universal Number
Windex 002003 00203mon 45792-246 P01
Xtreme Glass 15429 45792-246 88424-001
2
Bic Pen 11343 7132150 3
Yellow Notepad - mead brand 11908
4
White Notepad 77889 67890 5
Squeeky Clean Glass 57769 45792-246
88424-001 6
Yellow Notepad - officemax brand 79602 11908
7
White Notepad Mead 77456 24789 8
#2 pencil 114-78221 9


This is what I needed Col F to show:

Description Product #1 Product #2 Product #3
Product #4 Universal Number
Windex 002003 00203mon 45792-246 P01
Xtreme Glass 15429 45792-246 88424-001
P01
Bic Pen 11343 7132150 P02
Yellow Notepad - mead brand 11908
P03
White Notepad 77889 67890 P04
Squeeky Clean Glass 57769 66793-221
88424-001 P01
Yellow Notepad - officemax brand 79602 11908
P03
White Notepad Mead 77456 24789ZNC
67890 P04
#2 pencil 114-78221 P05
 
Terry
my problem with your data is that I don't know how you identify related
products. what do they have in common (at least on column must be
identical for related products). But if I see the two rows:
Windex 002003 00203mon 45792-246 P01
and
Squeeky Clean Glass 57769 66793-221 88424-001 P01

both getting the same 'universal ID' how do you know that these two
rows belong together. If you're just able to 'know' this relation due
to some associations you make (e.g. knowing that Glass and Windex is
related) no way Excel (or any other computer program) would be able to
make this relation

But if there's a logic behind this 'relation' you may explain this to
us so we'll be able to come up with a working formula/macro
 
Back
Top