counting and matching
 

Hello and welcome to my problem.

I have a column of 'quantity' (C) and a column of 'part #'s' (D).

The formula only works if I put a zero in column D, wouod like it to work
for a 'blank'

=IF(COUNTA(C24:C77)<(COUNTA(D24:D77)),"","Line "&(MATCH(0,D24:D77)-22)&" is
missing part a number.")
--
parts galore
--
Happy ßuππy (O \ | / O) VW''s rule
because it''s a car with camel toe ;)
() ()
(°ˆ™Â°) - go suck an Easter Egg
(" " )—‹

I am not sure what you want, but if it is that if there is a non zero number
in column C and no identifier in the same row in Column D
try
=Choose(max(sumproduct(--(C24:C770),--(D24:D77="")),2)+1,"","Line
"&Sumproduct((--(C24:C770),--(D24:D77=""),row(D24:D77)) & " is missing a
part number.", "Several lines are missing a part number")

"jsc3489" wrote:

Hello and welcome to my problem.

I have a column of 'quantity' (C) and a column of 'part #'s' (D).

The formula only works if I put a zero in column D, wouod like it to work
for a 'blank'

=IF(COUNTA(C24:C77)<(COUNTA(D24:D77)),"","Line "&(MATCH(0,D24:D77)-22)&" is
missing part a number.")
--
parts galore
--
Happy ßuππy (O \ | / O) VW''s rule
because it''s a car with camel toe ;)
() ()
(°ˆ™Â°) - go suck an Easter Egg
(" " )—‹

I copied and pasted the formula and Excell says it has errors, can you
elaborate?
--
(O \ | / O) VW''''s rule because it''''s a car with camel toe ;)



"bj" wrote:

I am not sure what you want, but if it is that if there is a non zero number
in column C and no identifier in the same row in Column D
try
=Choose(max(sumproduct(--(C24:C770),--(D24:D77="")),2)+1,"","Line
"&Sumproduct((--(C24:C770),--(D24:D77=""),row(D24:D77)) & " is missing a
part number.", "Several lines are missing a part number")

"jsc3489" wrote:

Hello and welcome to my problem.

I have a column of 'quantity' (C) and a column of 'part #'s' (D).

The formula only works if I put a zero in column D, wouod like it to work
for a 'blank'

=IF(COUNTA(C24:C77)<(COUNTA(D24:D77)),"","Line "&(MATCH(0,D24:D77)-22)&" is
missing part a number.")
--
parts galore
--
Happy ßuππy (O \ | / O) VW''s rule
because it''s a car with camel toe ;)
() ()
(°ˆ™Â°) - go suck an Easter Egg
(" " )—‹