View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_22_] Jim[_22_] is offline
external usenet poster
 
Posts: 23
Default Is this possible?

Is this possible?

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)

- a 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(last) transaction for that name for the year so far or "no" if
there is another transaction for that same name farther down in the year.

thanks for any help!!

Jim, again!