Ranking Utility Add-In for Excel

Ever wanted to just find out who or which person, event or item tops the list without having to do all kinds of sorting in Excel, putting in formulae, or asking someone else to do it wondering whether they've done it right?

The truth is, sometimes we like the data we input, in the order in which it was put into a document. And when that order is tampered with, we no longer know where we are. If you're like me or some of my colleagues, and feel 'lost' when your information is turned on its head, this is the tool for you.

The ranking Utility is an Add-in for PC or MAC. (This product comes with a quick guide for installing Add-ins in PC and MAC computers). And we've added a neatly accessible menu to your Excel menus to help you access this functionality with the click of a button.

(*An Add-in is a tool that complements your existing Excel spreadsheet program by being available to any workbook you open in Excel) This means that whenever you have data that needs to be ranked, no matter which spreadsheet the data resides in, the add-in is available to you and you can process that data right there and then. That includes opening up a fresh spreadsheet! It is programmable VBA code and you must have your macros enabled in order for the Add-in to run.

So to learn what this utility does, let's look at a simple scenario to explain what happens:

Suppose you have the name of your contestant, Product, item etc in one column and the associated scores, prices, data etc in another column on the same row as the name. (See the image associated with this product for an example.)

What does the program need to know?
1. The column where the Data is
2. The row where the Names begin (Name and associated data must be in the same rows.)
3. The column where to put the rankings (Will start with the same row as specified in 2.)

The data in the first 2 parts determines what the program puts in the 3rd specified part.

* All data is inserted in a user-friendly form.

But there's more...