View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigH
 
Posts: n/a
Default Counting Unique Part Numbers In A Range

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