A Stickler of a problem

J

Jim

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
VBA - exporting serial letters to single documents 0
Is this possible? 1
Delete sheets code error requires object 2
Automation of scanned file storage based on content 0
Array with many cells from a row but not in order or together 11
Copy & paste range 4
Reply to thread 'Syntax error on looping through each cell 4

Top