View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Sum Count of Numeric Duplicates: appears x2 in any Row

Glad to hear that. Thanks for the feedback!


--
Biff
Microsoft Excel MVP


"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:7ee9f1c14e28f@uwe...
Hi Biff & Domenic

I've been doing a manual count on Refs 201-207 and it tallys with your
Formula result, Biff. I really did expect a much higher count than it
turned
out to be! I just didn't believe the results would be as low as they are.

Biff, thank you ever so much for all your time, help and patience.

Cheers,
Sam

Domenic wrote:
If that's the case, then everything seems to check out. The formula
that Biff offered should return the desired result.


--
Message posted via http://www.officekb.com