t;>>> By "formula", do you mean Excel "function" or VBA functions in a macro?
>>>>
>>>> *Paul*
>>>> -
>>>>
>>>>
>>>>
>>>>
>>>>
>>&g
gt;>
>>>
>>>
>>>
>>> *“Do all the good you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can,To all the people
>>> you can,As long as ever you can.” - John Wesley*
>>> -
;>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> -
” - John Wesley*
> -----
>
> *From:* Ahmad Mustfa
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, February 11, 2015 6:00 AM
> *Subject:* $$Excel-Macros$$ Count duplicate records.
>
> Hi all.
> I am looking for a formula to
Thanks for the reply . good effort.
Could you please see the attachment i have created actual format i wanted?
On Thu, Feb 12, 2015 at 12:14 PM, Vaibhav Joshi wrote:
> Hi
>
> check attached file:
>
> use follo. formula to count distinct values:
> =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))
>
> & for d
Hi
check attached file:
use follo. formula to count distinct values:
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))
& for duplicated values:
=COUNT($A$1:$A$10)-SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))
Where A1 to A1o is your range of class.
Cheers!!
On Wed, Feb 11, 2015 at 4:30 PM, Ahmad Mustfa wrote:
>
ou can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Ahmad Mustfa
>To: excel-macros@googlegroups.com
>Sent: Wednesday, February 11, 2015 6:00 A
Hi all.
I am looking for a formula to count duplicate records for a specific
class/field in excel. Please help. Thanks
--
Regards,
Ahmad Mustafa
+44 7768197568
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi