LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"COUNTU" function in Excel to count unique entries in a range WayneL Excel Worksheet Functions 20 September 19th 08 03:50 AM
Counting unique records based on date range aspAddict Excel Worksheet Functions 3 October 26th 05 08:12 PM
How do I use a range of numbers in an if statement? pbeattie Excel Worksheet Functions 2 October 10th 05 10:36 PM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
Counting unique text/number cells from a range sudeepd12 Excel Discussion (Misc queries) 3 June 15th 05 07:58 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"