Thread: countif - unique values only
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default countif - unique values only
On Mon, 10 Sep 2012 19:23:30 -0700 (PDT), wrote:

the part numbers are at the top of the column. lets call it part A and part B. on your layout part A requires tools 1,2 and 3 and part B requires tool 1,3

In your original post, you wrote you had three columns A - B - C with the tools in Column C. That would imply only two part numbers based on what you've written above. Surely you must have more than two part numbers, if this is a real life problem. And, if so, it seems unlikely that your tools are listed in column C. Please, how is your data really set up? That information will make crafting a solution much more efficient.
Reply With QuoteReply With Quote