View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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