counting and matching

[jsc3489]

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(D2477)),"","Line "&(MATCH(0,D2477)-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
(" " )â—‹

 

[bj]

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:C77>0),--(D2477="")),2)+1,"","Line
"&Sumproduct((--(C24:C77>0),--(D2477=""),row(D2477)) & " is missing a
part number.", "Several lines are missing a part number")

 

[jsc3489]

I copied and pasted the formula and Excell says it has errors, can you
elaborate?