Calculate changes in percent
Hello there and thanks for reading my post!
I would like to find out the percentages of people that changed organization, manager or role in an Excel spreadsheet.
I hope to create formulas that show the changes in percent and update when the information is edited. I am currently interning for a company and would like to be hired full time, and you could help a lot!!
I attached a sample worksheet (the actual data is confidential of course).
Thanks for reading my post!
Julia
| Attachment | Size |
|---|---|
| Example.xlsx | 9.48 KB |
| ExampleExcelEXperts.Com_.xlsx | 9.67 KB |
solution attached
solution attached.. and good luck with the internship.
- the solution is achieved by 4 things:
1. count the non-blank cells
2. count the cells with no change
3. Calculate the % of no change
4. 1- (point 3 above) = % with changes
If any of your fellow interns would like to know more about Excel, I recommend taking a look at our tips: Excel -100 tips
solution
You absolutely nailed it!
That's awesome! Thank you so much!!!
I have another question but I will post it seperately.
Thank you so much! Yaaay