Amit,
If you are looking to count unique Vehicles in a date & a period. here is
one way:
For a single date:
=SUM(IF(FREQUENCY(IF(TEXT(H$4:H$9,"md")=TEXT(CabOutDate,"md"),IF(C$4:C$9<>"",MATCH(C$4:C$9,C$4:C$9,0))),ROW(C$4:C$9)-ROW(C$4)+1),1))
Change cabOutDate to your reference where is
ong as ever you can.” - John Wesley
-
From: Amit Desai (MERU)
To: excel-macros@googlegroups.com
Sent: Tue, April 10, 2012 2:30:40 PM
Subject: RE: $$Excel-Macros$$ Unique count for a date & between range
My friend I wanted to get unique count & not just simple
u 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
-
____________
From: Amit Desai (MERU)
To: excel-macros@googlegroups.com
Sent: Tue, April 10, 2012 1:11:35 PM
Subject: RE: $$Excel-Macros$$ Unique co
Please see the attached file
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Apr/Tue/2012 09:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unique count for a date & between range
Hi,
Consider, Dates Rang
Hi,
Consider, Dates Range is A1:A10,
Try this array formula, (Apply with Ctrl+Shift+Enter)
=SUM(--(COUNTIF(A1:A10,A1:A10)=1))
Regards,
MARIES.
On Tue, Apr 10, 2012 at 8:07 PM, Amit Desai (MERU)
wrote:
> Dear All,
>
> ** **
>
> Please help to calculate unique count for a date & for a dat
