Jul 25 2021 03:14 PM
Jul 25 2021 11:23 PM
@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.
Jul 26 2021 12:05 AM
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)