Creative Wednesday... how have you been creative recently?

Oh! I never thought of Excel formulas as being creative!

I recently worked a few formulas for my department metrics. We track each type of request with acronyms and my director wanted a way to capture these at the end of each quarter, so she asked me to look at it. At work they call me an Excel guru, but it’s just because I’m not afraid to search the internet and try things out. The formula I used constantly updates when info is changed, so today is the day I get to capture the numbers for last quarter. Fingers crossed it works as intended!

There’s probably an easier solution out there, but that would likely require a subscription to some outside company and my university is trying to save money.

Edit: I logged in and it worked! Hooray!! 🥳