count unique records with latest date

I Want To Count All "x" With Unique Record In Column B
Parameter Must Be The Latest Date In Colum C Will Count

Answer Is "2"
Date Of 10/01/05 08:01am
Ed & Xr

What Is The Easyway To Create This Formula
Tnx


A B C

X Ed 10/01/05-08:00am
X Ed 10/01/05-08:01am
X Xr 10/01/05-08:00am
X Xr 10/01/05-08:01am

Hello xtrmhyper,

This macro will return a Variant Array. Array(0) = the number of unique entries and Array(n) to Array(n+x) = the column "B" values sorted in ascending order. Just put the sort range in as a string. The range is assumed to be on the active worksheet and to contain 3 columns.

Calling the Macro:

Dim N, X

N = FindUnique("A1:C4")

X = N(0) ' X = 2
X = N(1) ' X = "Ed"
X = N(2) ' X = Xr


Macro Code:

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Try this formula

=COUNT(1/FREQUENCY(IF((A2:A10="X")*($C$2:$C$10=MAX($C$2:$C$10)),MATCH(B2:B10
,B2:B10,0)),ROW(INDIRECT("2:"&ROWS(B2:B10)-ROW(B2)+1))))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"xtrmhyper" <[email protected]> wrote
in message news:[email protected]...
>
> I Want To Count All "x" With Unique Record In Column B
> Parameter Must Be The Latest Date In Colum C Will Count
>
> Answer Is "2"
> Date Of 10/01/05 08:01am
> Ed & Xr
>
> What Is The Easyway To Create This Formula
> Tnx
>
>
> A B C
>
>
> X Ed 10/01/05-08:00am
> X Ed 10/01/05-08:01am
> X Xr 10/01/05-08:00am
> X Xr 10/01/05-08:01am
>
>
> --
> xtrmhyper
> ------------------------------------------------------------------------
> xtrmhyper's Profile:
http://www.excelforum.com/member.php...o&userid=23851
> View this thread: http://www.excelforum.com/showthread...hreadid=478152
>