Hi I have a column of dates, I need a helper column to count backwards for each set of dates starting with the latest as set 1.
Pleaser see attached sheet for example.
Thanks in a advance
JD
Hi I have a column of dates, I need a helper column to count backwards for each set of dates starting with the latest as set 1.
Pleaser see attached sheet for example.
Thanks in a advance
JD
John in C2 and copy down.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Cheers Fotis, brilliant as usual.
Many thnaks
John
Please see additional file with example including time column.
John
Sorry John. I missed your last post.
This looks that works.
Formula:Please Login or Register to view this content.
In D2 and copy down.
Hi Fotis, still not working as required, the number occurances are not displaying properly.
Please see attached example with your formula applied and also the desired result.
Cheers
JD
Formula:Please Login or Register to view this content.
This is why everyone should always go Greek, they are the fountain of all knowledge.
Cheers mate, brilliant.
JD
Thanks. We'll be waiting to see you in Greece!
Please see the attached worksheet.
Cheers
JD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks