using formula to tell when client last ordered

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

floridasurfn - 20 Jun 2006 03:30 GMT

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.

Reply to this Message

Biff - 20 Jun 2006 04:05 GMT

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

>i need a formula that can tell me the last time that a client placed an
>order
[quoted text clipped - 11 lines]
> the
> most recent date.

Reply to this Message

floridasurfn - 20 Jun 2006 15:31 GMT

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

> i need a formula that can tell me the last time that a client placed an order
> w/ my company
[quoted text clipped - 6 lines]
> something like countif j1 - j200 = joe's bakery & then sort g1-g200 for the
> most recent date.

Reply to this Message