Hi Sara,
PFA
Regards
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On 4/27/2012 10:00 AM, Sara Lee wrote:
hi
i have data as in the attached data. i need count of unique values of
column A i.e i need output as in column AB, AC... pls advise a
formula thanks
--
FORUM RULES
no but this takes duplicates into consideration.. I would need count of
only unique values for every load no
On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed wrote:
> Hi Sara,
>
> PFA, Hope this is what you are looking for...
>
> On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee wrote:
>
>> Anil
>
Anil
it s not the count of loads.. i need the count of distinct values for every
load no
ie Load 0241
7151865O 7154687O 7175843O 7202990O 7212856O 7253406O
has 6 values both from top row and bottom row.. so 6 should be the output
for load 0241
in some case as u see, some loads have 3 ro
Dear Sara,
Its Working Fine please find the attached file.
Thanks & Regards
Anil Kumar
113784
On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan wrote:
> See if you understand array formula.
>
> http://www.excelfunctions.net/Excel-Array-Formulas.html
>
>
> 2012/4/27 Sara Lee
>
>> thee are two si
See if you understand array formula.
http://www.excelfunctions.net/Excel-Array-Formulas.html
2012/4/27 Sara Lee
> thee are two similar rows with same load no---this is not working
>
> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>
>> you can use
>>
>> =SUMPRODUCT(--($A$2:$A$23=AB2))
>>
thee are two similar rows with same load no---this is not working
On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
>
>> yes i need count of distinct records for each load no-- sample
should i paste in AB2?
On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote:
> sara,
>
> the formula should workfirst highlight the range you want to implement
> this formula, then you should try Ctrl + Shift + Enter.
>
>
> 2012/4/27 Sara Lee
>
>> it is not working-- anybody else can help here
sara,
the formula should workfirst highlight the range you want to implement
this formula, then you should try Ctrl + Shift + Enter.
2012/4/27 Sara Lee
> it is not working-- anybody else can help here
>
>
> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>
>> you can use
>>
>> =SUMPROD
it is not working-- anybody else can help here
On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
>
>> yes i need count of distinct records for each load no-- sample output
>>
>> load
you can use
=SUMPRODUCT(--($A$2:$A$23=AB2))
On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
> yes i need count of distinct records for each load no-- sample output
>
> load 02416
> load 02423
> load 02452
> load 02462
>
>
> On Fri, Apr 27, 2012 at 3:45 AM, Ab
yes i need count of distinct records for each load no-- sample output
load 02416
load 02423
load 02452
load 02462
On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote:
> Actually count of values stored in adjacent columns of each load number is
> required. For Loa
Actually count of values stored in adjacent columns of each load number is
required. For Load 0241 - there are 6 values so the formula should return 6.
On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan wrote:
> Hi Sara,
>
> Seems formula COUNTIF can solve your problem simply.
>
> 2012/4/27 Sara Lee
Hi Sara,
Seems formula COUNTIF can solve your problem simply.
2012/4/27 Sara Lee
> hi
>
> i have data as in the attached data. i need count of unique values of
> column A i.e i need output as in column AB, AC... pls advise a formula
> thanks
>
> --
> FORUM RULES (986+ members already BANNED
hi
i have data as in the attached data. i need count of unique values of
column A i.e i need output as in column AB, AC... pls advise a formula
thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Ur
14 matches
Mail list logo
