hi
use this Function to Count only Unique value in a List
{=SUM(IF(COUNTIF(A1:A24,A1:A24)=1,1,0))}
On 12/14/11, NOORAIN ANSARI wrote:
> PFA
>
> On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Darwin,
>>
>> Please find attached sheet...hope it will help to u...
>>
>> On We
Assume Bill ID's are numeric. Use this *ARRAY FORMULA *(must hit *
CTRL+SHIFT+ENTER*, rather than just ENTER). then copy down.
=SUM(SIGN(FREQUENCY(IF(Customer=E2,Billid),Billid)))
If you want to count the total unique ID's regardless of customers, use
this with just ENTER.
=SUM(SIGN(FREQUENCY(B
PFA
On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI
wrote:
> Dear Darwin,
>
> Please find attached sheet...hope it will help to u...
>
> On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan > wrote:
>
>> Dear all,
>>
>> I have a excel table with duplicate bill id, i want to get the unique
>> count
Dear Darwin,
Please find attached sheet...hope it will help to u...
On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan wrote:
> Dear all,
>
> I have a excel table with duplicate bill id, i want to get the unique
> count. However, it should also consider another criteria, which is
> customer. Shoul
Hi Darwin
if your bill ids are in ascending order then
check the attachment see if it helps formula cells in red color
On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan wrote:
> Dear all,
>
> I have a excel table with duplicate bill id, i want to get the unique
> count. However, it should also con
Dear all,
I have a excel table with duplicate bill id, i want to get the unique
count. However, it should also consider another criteria, which is
customer. Should I use advanced filter instead? How should the advanced
filter be set?
--
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.
