I have a database with hundreds of names - some repeat customers - which
is set up as follows:

Column A Column B Column C Column D
Dates First Names Last Names A Formula??

- Each row in the database has Date, First Name, Last Name. (More added
each
day)

- the same name is often used several times during the year - hence
another row in
the database.

- is it possible to have a formula in Column D that will say "yes" if it
is
the
most recent(latest date) transaction for that name for the year so far or
"no" if
there is another transaction for that same name farther down (later date)
in the year.

Important! - if a transaction for John Doe is entered, for example, on Feb
5, the formula needs to say "Yes" in Column D. But if a new transaction, for
John Doe again, is entered on May 23, then the one on Feb 5 needs to change
to "No" since is no longer the most recent transaction (for John Doe)PLUS
the May 23rd transaction now needs to say "Yes" - until(if there is one) a
later one is entered, in which case, it will to change to "No".

Thanks for any help
Jim