latest date
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?
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
On Sep 17, 1:20 pm, hitesh wrote:
help need
hi
i have a list of disconnection customer. in that list the disconnection date
is repeated. means disconnection is made more than 2 time. it is difficult to
know the latest date of disconnection so pls help to
the latest date of disconnection of particular customer
|