Hi I need a formula that will look at a list of dates and names and list the dates in order (the latest would be the most recent and then work backwards).
I have attached a sheet for reference.
Cheers in advance
JD
Hi I need a formula that will look at a list of dates and names and list the dates in order (the latest would be the most recent and then work backwards).
I have attached a sheet for reference.
Cheers in advance
JD
Uk date format I suspect from your location?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If you sort the data, like you want, i get a diffeant answer.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Special K, yes I use the Uk date format.
Hi oeldere, please see the attached amended sheet, I had made a mistake on the original.
Cheers
John
E3=B3&"_"&COUNTIFS(B$3:B$11,B3,C$3:C$11,">="&C3)
Try this and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
@john dalton
same problem, so you should define better how you come to the result.
Cheers nflsales, top result mate, thaks for everyones input, I willll bear that in mind oeldere for future posts,
Most appreciated john
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks