Freeze a counter’s value

%3CLINGO-SUB%20id%3D%22lingo-sub-2585139%22%20slang%3D%22en-US%22%3EFreeze%20a%20counter%E2%80%99s%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2585139%22%20slang%3D%22en-US%22%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20the%20following%20situation%3A%20I%20have%20a%20list%20of%20future%20potential%20projects%20that%20we%20could%20be%20hired%20to%20do%2C%20and%20then%20I%20keep%20track%20of%20how%20many%20we%20have%20actually%20been%20hired%20for%20on%20a%20counter.%3CBR%20%2F%3E%3CBR%20%2F%3EUsing%20this%2C%20I%20would%20like%20to%20record%20what%20was%20the%20value%20of%20the%20counter%20at%20the%20end%20of%20each%20month%20(kind%20of%20like%20freezing%20the%20value%20of%20the%20counter%20at%20the%20end%20of%20each%20month).%20Is%20this%20possible%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAlternatively%2C%20I%20guess%20I%20could%20also%20count%20how%20many%20projects%20we%20were%20hired%20for%20each%20month%20and%20then%20add%20them%20up%20to%20get%20a%20cumulative%20count%2C%20but%20I%20don%E2%80%99t%20know%20how%20to%20count%20that%20in%20an%20automated%20way%20either.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20will%20be%20extremely%20welcomed!%20Thanks!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2585139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2585652%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20a%20counter%E2%80%99s%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2585652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1112253%22%20target%3D%22_blank%22%3E%40sergi0%3C%2FA%3E%26nbsp%3BMany%20ways%20to%20achieve%20this%2C%20and%20it%20all%20depends%20on%20how%20exactly%20your%20data%20is%20structured.%20If%2C%20for%20example%2C%20you%20have%20a%20list%20of%20projects%20with%20at%20least%20a%20column%20for%20the%20win%20date%2C%20you%20could%20create%20a%20pivot%20table%20that%20counts%20all%20the%20projects%20won%20by%20month.%20The%20attached%20workbook%20contains%20a%20simplified%20example%2C%20with%20data%20in%20one%20sheet%20and%20a%20summary%20in%20another.%20Perhaps%20something%20you%20can%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20makes%20no%20sense%20at%20all%2C%20please%20upload%20a%20workbook%20with%20a%20representative%20sample%20your%20data.%20and%20please%20mention%20the%20Excel%20version%20you%20are%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi all,

I have the following situation: I have a list of future potential projects that we could be hired to do, and then I keep track of how many we have actually been hired for on a counter.

Using this, I would like to record what was the value of the counter at the end of each month (kind of like freezing the value of the counter at the end of each month). Is this possible?

Alternatively, I guess I could also count how many projects we were hired for each month and then add them up to get a cumulative count, but I don’t know how to count that in an automated way either.

Any help will be extremely welcomed! Thanks!
2 Replies

@sergi0 Many ways to achieve this, and it all depends on how exactly your data is structured. If, for example, you have a list of projects with at least a column for the win date, you could create a pivot table that counts all the projects won by month. The attached workbook contains a simplified example, with data in one sheet and a summary in another. Perhaps something you can use.

 

If this makes no sense at all, please upload a workbook with a representative sample your data. and please mention the Excel version you are on.

 

 

@sergi0 

A file (no image) template (without sensitive data) from you, as well as the Excel version and operating system, would be advantageous.

Describe your project in detail on the basis of this file.

You get a quick and precise solution proposal and the helper does not need to invest time for the basic one. This helps everyone indirectly.

 

You would like tenders vs. surcharges per month, that would be the basis. but what about the tenders? which are public and which are secret?
How are the awards awarded, directly or indirectly?


However you know better than I how many questions could arise, so state what exactly you want.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)