R
Rockbear
I have a list of article numbers, article name,location that I neet to sort
out whats missing in the two different collums
A1 B1 C1 D1 E1
F1
Art,nr Art.name Location Art,nr Art.name Loc
80750404 1/4" STRUPE D0315 79930015 J D 15 SF D0101
90320112 Plugg-rør D0319 66200809 H RHD 8 S D0102
90320204 Plugg 1/4" D0320 66201213 DR KROPP D0103
50220032 CAM-AL-C. 2" D0331
Have tried =IFCOUNT(A:A;D2;1) and that give me 1 if it finds it but its over
15000 article numbers, and some are also with letters, not only numbers and
the sort takes a looong time.. and you have to copy the 0 to another sheet
and sort them there.
The goal is to have one list that are with all possible numbers, and try to
know why the different reports give different number of article/artnumber
The really neat one would be, compare column A with column D, and get a list
over the numers missing in column A or column D.
Any suggestions out there, I know there are some big brains out there
Thanks in advance
Rock
out whats missing in the two different collums
A1 B1 C1 D1 E1
F1
Art,nr Art.name Location Art,nr Art.name Loc
80750404 1/4" STRUPE D0315 79930015 J D 15 SF D0101
90320112 Plugg-rør D0319 66200809 H RHD 8 S D0102
90320204 Plugg 1/4" D0320 66201213 DR KROPP D0103
50220032 CAM-AL-C. 2" D0331
Have tried =IFCOUNT(A:A;D2;1) and that give me 1 if it finds it but its over
15000 article numbers, and some are also with letters, not only numbers and
the sort takes a looong time.. and you have to copy the 0 to another sheet
and sort them there.
The goal is to have one list that are with all possible numbers, and try to
know why the different reports give different number of article/artnumber
The really neat one would be, compare column A with column D, and get a list
over the numers missing in column A or column D.
Any suggestions out there, I know there are some big brains out there
Thanks in advance
Rock