chek this..I am not sure if it matches what you are looking for...
On Fri, Feb 13, 2015 at 6:19 PM, Ahmad Mustfa wrote:
> I want to count how many have attended the event both days in each class.
> On 13 Feb 2015 08:26, "Vaibhav Joshi" wrote:
>
>> what values do you want in col K, L & M?
>>
>>
I want to count how many have attended the event both days in each class.
On 13 Feb 2015 08:26, "Vaibhav Joshi" wrote:
> what values do you want in col K, L & M?
>
>
>
> On Fri, Feb 13, 2015 at 6:08 AM, Ahmad Mustfa
> wrote:
>
>> it's excel function.
>>
>> On Wed, Feb 11, 2015 at 12:47 PM, Paul
what values do you want in col K, L & M?
On Fri, Feb 13, 2015 at 6:08 AM, Ahmad Mustfa wrote:
> it's excel function.
>
> On Wed, Feb 11, 2015 at 12:47 PM, Paul Schreiner
> wrote:
>
>> REALLY need more infomation.
>>
>>
>>
>>
>>
>>
>> I was tempted to leave it at that:
>> ask for more info, b
it's excel function.
On Wed, Feb 11, 2015 at 12:47 PM, Paul Schreiner
wrote:
> REALLY need more infomation.
>
>
>
>
>
>
> I was tempted to leave it at that:
> ask for more info, but not say what info is needed.
>
> There ARE functions that CAN be used (or used in combination) to count
> duplica
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:
>
REALLY need more infomation.
I was tempted to leave it at that:
ask for more info, but not say what info is needed.
There ARE functions that CAN be used (or used in combination) to count
duplicate records.
But it REALLY depends on the format of the data and what is considered
"dupl
