I've just read what I had written and it didn't make sense - very sorry!

It might be easier if i just explain my scenerio.

The code represents a course that I run.
The date represents the date that it ran.
The spreadsheet is a complete list of all the people I have
attending/attended these courses.
There is usually 60+ people attending each course.
More than one course can occur on one day.

What I would like is (if it is possible) to have a list on a seperate sheet
of the most recent dates with the course name next to it. This would mean
there maybe duplicates of dates when there is more that one course on that
day. Then next to them dates and course names I would be able to SUM results
of that day in other boxes using the rest of the data on the original
spreadsheet.

Your first coding was great - but it did not reflect when more than one
course occured on one date.

Many thanks for your time on this - very much appreciated!


"GoBow777" wrote:


Adam;651370 Wrote:
Hi thanks very much for your help -

one problem

I need to see duplicates of the date still if they have different
codes.

Sorry, should have put that in my first question.

Adam:

Im still a bit confused when you say, €œI need to see duplicates of the
date still if they have different codes€�. Im guessing you mean to say,
€œI need to see duplicates of the date regardless of the different
codes€�? I hope Ive got that right. Populate column AA with this
formula.

Code:
--------------------
=IF(OR(A2="",G2=""),"",IF(COUNTIF($G:$G,G2)1,RANK ($G2,$G:$G,0)+ROW()/100000,""))
--------------------


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
GoBow777