TheOneTheDave
New Member
- Joined
- Nov 18, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I've tried for quite a while to figure out the nomenclature of what I'm trying to do, and I am coming up at a bit of a loss. I hate being the guy that asks the same question, but I can't seem to figure out how to formulate my search to return the information I'm looking for. The long and short is, work has tasked me (a fumbling beginner) with creating an Excel based war board to track projects across multiple markets. I have been able to research and add in some automation, but I am completely lost in how to make Excel display X/X in a cell without it trying to divide the values.
To add a bit of context;
I have 20 total projects in one market. I have permits back on 12 of them. I am hoping to get Excel to output 12/20 onto the overview sheet in the workbook. I've found a bit about the MOD function, but I'm not sure if that is going to work the way that I need it to. Is there anyone who has encountered this?
To add a bit of context;
I have 20 total projects in one market. I have permits back on 12 of them. I am hoping to get Excel to output 12/20 onto the overview sheet in the workbook. I've found a bit about the MOD function, but I'm not sure if that is going to work the way that I need it to. Is there anyone who has encountered this?