=MAX(IF(B1:B100="customer",C1:C100))
where B is the customer name, C the date
It is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> help need
>
[quoted text clipped - 5 lines]
> know the latest date of disconnection so pls help to
> the latest date of disconnection of particular customer
hitesh - 17 Sep 2007 15:44 GMT
when i enter the customer code date does not appear. i have to say that if i
enter a customer code in sheet 1 cell A2, the t customer name should appear
in cell B2 and latest date in C2. is it possible. my data base is in sheet 1.
regards
> =MAX(IF(B1:B100="customer",C1:C100))
>
[quoted text clipped - 15 lines]
> > know the latest date of disconnection so pls help to
> > the latest date of disconnection of particular customer
Why not apply autofilter to select the customer name and then examine
the dates for that customer?
Alternatively, you could use an array* formula like:
=MAX(IF(customer_range=X1,date_range))
where customer_range covers the cells where your customers are
located, eg A1:A100, date_range is where the dates are, eg F1:F100,
and X1 is used for the name of the customer you are interested in.
* As this is an array formula, then once you have typed it in (or
subsequently edit it) you need to use CTRL-SHIFT-ENTER instead of the
usual ENTER to commit it. If you do this correctly then Excel will
wrap curly braces { } around the formula when viewed in the formula
bar - do not type these yourself.
Hope this helps.
Pete
> help need
>
[quoted text clipped - 3 lines]
> know the latest date of disconnection so pls help to
> the latest date of disconnection of particular customer
bu alemın krali - 19 Sep 2007 12:52 GMT
bu metın yarak larda dırt
"Pete_UK":
> Why not apply autofilter to select the customer name and then examine
> the dates for that customer?
[quoted text clipped - 24 lines]
> > know the latest date of disconnection so pls help to
> > the latest date of disconnection of particular customer
Pete_UK - 19 Sep 2007 13:09 GMT
In English, please?
Pete
On Sep 19, 12:52 pm, bu alem n krali <bu alemin
kr...@discussions.microsoft.com> wrote:
> bu met n yarak larda d rt
>
[quoted text clipped - 30 lines]
>
> - Show quoted text -