Thread: Count but ignore duplicate data
View Single Post
  #2  
Old April 20th, 2010, 02:12 PM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
  
Posts: 5,952
Default Count but ignore duplicate data
Try
=SUMPRODUCT((A2:A10"")/COUNTIF(A2:A10,A2:A10&""))

--
Jacob (MVP - Excel)


"Rechie" wrote:

Hi Expert, I need your help on how to count data but to ignore duplicates.

Below count results should be = 3 (ignore duplicates)
Inv No.
9123
9123
9125
9128
9128

Thanks for your support,