Hi everyone,
I'm trying to calculate the following:
On 01/01/2020, the first event of the day occurs at 11:55 = rank 1, the 2nd event of the day occurs at 12:05 = rank 2 etc etc - but the rank resets at the start of each new day i.e. On 02/01/2020, 11:45 = rank 1, 12:15 = rank 2, 12:30 = rank 3 etc etc.
I've included a spreadsheet below, Col B is the result I'm looking for.
Any help would be much appreciated
Cheers
Mdn
Based on your sample answers...
=SUMPRODUCT((A2>A$2:A$99)/COUNTIF(A$2:A$99,A$2:A$99))+1
copied down
hmmm maybe not
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
OK try this instead. I missed the daily restart...
=IFERROR(IF(INT(A2)>INT(A1),1,IF(A2=A1,F1,F1+1)),1)
Lovely stuff FD, massive ty
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks