In English, please?

Pete

On Sep 19, 12:52 pm, bu alem n krali <bu alemin
wrote:
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- Hide quoted text -

- Show quoted text -