using formula to tell when client last ordered

[floridasurfn]

i need a formula that can tell me the last time that a client placed an order
w/ my company

all of our clients place multiple orders with us over the span of the year,
and many clients names are in the workbook. the formula needs to be able to
countif the name of client if correct and then sort the dates that client has
ordered- (another column) to provide the most current date

something like countif j1 - j200 = joe's bakery & then sort g1-g200 for the
most recent date.

[Biff]

Hi!

Try this:

Entered as an array using the key combination of CTRl,SHIFT,ENTER:

=MAX(IF(J1:J200="joe's bakery",G1:G200))

Format the cell as DATE.

Biff

"floridasurfn" <[email protected]> wrote in message
news:[email protected]...
>i need a formula that can tell me the last time that a client placed an
>order
> w/ my company
>
> all of our clients place multiple orders with us over the span of the
> year,
> and many clients names are in the workbook. the formula needs to be able
> to
> countif the name of client if correct and then sort the dates that client
> has
> ordered- (another column) to provide the most current date
>
> something like countif j1 - j200 = joe's bakery & then sort g1-g200 for
> the
> most recent date.

[floridasurfn]

thanks biff.. i am gonna repost a more elaborate question that will help w/
indirect references..

"floridasurfn" wrote:

> i need a formula that can tell me the last time that a client placed an order
> w/ my company
>
> all of our clients place multiple orders with us over the span of the year,
> and many clients names are in the workbook. the formula needs to be able to
> countif the name of client if correct and then sort the dates that client has
> ordered- (another column) to provide the most current date
>
> something like countif j1 - j200 = joe's bakery & then sort g1-g200 for the
> most recent date.

[floridasurfn]

thanks biff.. i am gonna repost a more elaborate question that will help w/
indirect references..

"floridasurfn" wrote:

> i need a formula that can tell me the last time that a client placed an order
> w/ my company
>
> all of our clients place multiple orders with us over the span of the year,
> and many clients names are in the workbook. the formula needs to be able to
> countif the name of client if correct and then sort the dates that client has
> ordered- (another column) to provide the most current date
>
> something like countif j1 - j200 = joe's bakery & then sort g1-g200 for the
> most recent date.