Counting Unique Part Numbers In A Range
Hi!
Try this:
Array entered using the key combo of CTRL,SHIFT,ENTER:
=SUM(N(FREQUENCY(IF(B1:B100010,MATCH(A1:A1000,A1: A1000,0)),MATCH(A1:A1000,A1:A1000,0))0))
Biff
"BigH" wrote in message
...
Hi,
Hopefully someone can help, in column A i have over 1000 part numbers
(some of which are duplicated many times) and in column B i have values
ranging from 1 to 320 which correspond to column A part numbers. The
header in column A is Part Numbers and the header in column B is Days
Late.
What i want to calculate is how many unique part numbers are greater
than 10 days.
hope this makes sense
regards Big H
|