I'm looking to populate tables for specific tasks that my site performs and compare their performance against the other top sites in the company. I need to pull the site # and their performance based on the task, ranking them from first to last.
I'm looking to populate tables for specific tasks that my site performs and compare their performance against the other top sites in the company. I need to pull the site # and their performance based on the task, ranking them from first to last.
With what sort of regularity do you need to do this? How often is it updated? It seems like what you really want to do is just transpose a row of data and then sort it; which if this is a one time thing would be way easier to just DO than to try and write equations/a macro to do it for you.
I needed something to do on my lunch.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Kate,
I need to do this weekly, and we have about 50 different tasks and 14 sites to compare...plus, I'm lazy!
Perfect! That's exactly what I need! Thanks for the help, looking forward to breaking this down to see how it does what it does.
Hope your lunch was good!
Glad I could help out.
Lazy is the mother of all process improvements.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks