User Profile
John74Racing
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Counting number of times the same entry has been entered in the previous 7 days.
mtarler I am pretty green in excel and searched the formula. So the whole sheet is to manage an online poker game, a pretty large one at that. In column A we enter transaction values of Chips added, payments made, cashouts, and payer fees for every night they play. The time stamp is an important piece to mark what happened, when, with the formula I found it updates the timestamp if the enter is edited in column A. so if someone went and altered a payment from a few days ago it would timestamp today and i could see a discrepancy. so not sure if thats the best formula but it seems to be working well. I am more than willing to share the file with someone but i dont want to post it publicly.1.9KViews0likes0CommentsCounting number of times the same entry has been entered in the previous 7 days.
Looking for a function that can count the number of times the same value entry has been entered in the previous 7 days. Or even better would be from Sunday at 6:00am to Sunday 5:59am. We have a transaction list that has money in and money out, there are player fees that are added per night of play, but the fee is capped at a certain number. We enter our transactions with an auto timestamp using: =IF(A10<>"",IF(AND(B10<>"",CELL("address")=ADDRESS(ROW(A10),COLUMN(A10))),NOW(),IF(CELL("address")<>ADDRESS(ROW(A10),COLUMN(A10)),B10,NOW())),"") I would like to have a cell that shows how many times player fees have been added during the weekly window. A3 starts a transaction dollar, B3 Timestamp using the function above, C3 Memo I would place the formula in D3.2.2KViews0likes9Comments
Recent Blog Articles
No content to show