ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A Stickler of a problem (https://www.excelbanter.com/excel-programming/275502-stickler-problem.html)

Jim[_22_]

A Stickler of a problem
 
Is this possible?

Column A Column B
Column C
100's of Different Dates 100's of Different First Names
Last Names(100's of them)

- 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 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!






All times are GMT +1. The time now is 03:27 PM.

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