View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jill1 Jill1 is offline
external usenet poster
 
Posts: 12
Default Unique Count when Values 0.01

Hi

I have a spreadsheet with the following cols :-

ColA ColB ColC

Vendor1 0 5.99
Vendor2 1.99 0
Vendor1 2.00 3.99
Vendor1 0 1.00

Total 3.99 10.98
# of Vendors 2 1

The # of Vendors needs to be counted when the value in the particular column
is greater than 0.01, but only for each unique vendor.

Is this possible ?

Thanks
Jill