comparing numbers in a sheet
 

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

comparing numbers in a sheet
 

I fyou are trying to explain the differences then why don't you hightlight
the missing items using conditional formating?

"Rockbear" wrote:

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