ADVERTISEMENT

przyk__ad.xls

Excel - Przypisanie wartości z z 1 kolumny do drugiej

Chodzi mi o takie pogrupowanie 2005 produktów, funkcjami z automatu przykład w załączniku


Download file - link to post

,,,
" ID " , " GRUPA " , " kolejny numer wg podobnych grup " , " powi?zanie nr grupy "
" 1 " , " BLANKA " , " 1 " , " 1 "
" 2 " , " BLANKA " , " 1 " , " 2 "
" 3 " , " BLANKA " , " 1 " , " 3 "
" 4 " , " BLANKA " , " 1 " , " 4 "
" 5 " , " GOLD SPI " , " 2 " , " 1 "
" 6 " , " GOLD SPI " , " 2 " , " 2 "
" 7 " , " GOLD KOR " , " 2 " , " 3 "
" 8 " , " GOLD KOR " , " 2 " , " 4 "
,, " 3 " , " 1 "
,, " 3 " , " 2 "
,, " 3 " , " 3 "
,, " 3 " , " 4 "
,, " 4 " , " 1 "
,, " 4 " , " 2 "
,, " 4 " , " 3 "
,, " 4 " , " 4 "
,, " 5 " , " 5 "
,, " 5 " , " 6 "
,, " 6 " , " 5 "
,, " 6 " , " 6 "
,, " 7 " , " 7 "
,, " 7 " , " 8 "
,, " 8 " , " 7 "
,, " 8 " , " 8 "