ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is this possible? (https://www.excelbanter.com/excel-programming/275683-possible.html)

Jim[_22_]

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!







Ron Rosenfeld

Is this possible?
 
On Fri, 29 Aug 2003 19:29:18 -0500, "Jim" wrote:

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!






What was the matter with my answer of two days ago?


--ron


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com