Automatic sequential count of entries in a month?
Hello,
I am trying to populate a column that assigns a sequential number for each row based on the entry date specified in another cell. These users DO NOT want to use Pivot Tables (for whatever reason). Here is an example of the end result I am trying to achieve:
DATE COUNT 7/5/2016 1 7/20/2016 2 7/21/2016 3 8/2/2016 1 8/5/2016 2
Any help is greatly appreciated!
Try
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
You rock Olly! Thank you!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks