-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
reset countif
- Thread starter Methix
- Start date
that works great thanks!
on a similar note, if i have the amount of weeks summed up in a cell, how would i automatically switch 4 weeks to 1 month and 12 months to one year?
so it would go like this:
1 week, 2 weeks, 3 weeks, 1 month, 1 month 1 week, 1 month 2 weeks, ......
on a similar note, if i have the amount of weeks summed up in a cell, how would i automatically switch 4 weeks to 1 month and 12 months to one year?
so it would go like this:
1 week, 2 weeks, 3 weeks, 1 month, 1 month 1 week, 1 month 2 weeks, ......
Last edited:
Upvote
0
