REKLAMA

szpachla.xls

[EXCEL] Jak stworzyć generator kodów w Excelu z automatyczną numeracją?

A u mnie wychodzi tak:


Pobierz plik - link do postu

" sku " , " I człon " , " II człon " , " III człon "
" 0101/0101/001 " , " 0101 " , " 0101 " , " 001 " , " 2 " ,
" 0101/0101/001_1 " , " 0101 " , " 0101 " , " 001 " , " 3 " , " _1 "
" 0101/0101/001_2 " , " 0101 " , " 0101 " , " 001 " , " 4 " , " _2 "
" 0101/0101/001_3 " , " 0101 " , " 0101 " , " 001 " , " 0 " , " _3 "
" 0101/0101/001_4 " , " 0101 " , " 0101 " , " 001 " , " 1 " , " _4 "
" 0101/0101/002 " , " 0101 " , " 0101 " , " 002 " , " 2 " ,
" 0101/0101/002_1 " , " 0101 " , " 0101 " , " 002 " , " 3 " , " _1 "
" 0101/0101/002_2 " , " 0101 " , " 0101 " , " 002 " , " 4 " , " _2 "
" 0101/0101/002_3 " , " 0101 " , " 0101 " , " 002 " , " 0 " , " _3 "
" 0101/0101/002_4 " , " 0101 " , " 0101 " , " 002 " , " 1 " , " _4 "
" 0101/0101/003 " , " 0101 " , " 0101 " , " 003 " , " 2 " ,
" 0101/0101/003_1 " , " 0101 " , " 0101 " , " 003 " , " 3 " , " _1 "
" 0101/0101/003_2 " , " 0101 " , " 0101 " , " 003 " , " 4 " , " _2 "
" 0101/0101/003_3 " , " 0101 " , " 0101 " , " 003 " , " 0 " , " _3 "
" 0101/0101/003_4 " , " 0101 " , " 0101 " , " 003 " , " 1 " , " _4 "
" 0101/0101/004 " , " 0101 " , " 0101 " , " 004 " , " 2 " ,
" 0101/0101/004_1 " , " 0101 " , " 0101 " , " 004 " , " 3 " , " _1 "
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,