Hello
I'm currently trying to work out how to provide a list of ranked options with the description of the option returned.
On the attached, on the worksheet 'Opportunities Master' I will have a list of opportunities with options to score them against criteria with a simple criteria scoring (1 to 3). Column H then returns the average score.
On the worksheet 'Opportunities Ranking', I want to return the list according to their rank and will be using Index-match functions to return details about them (have a bit more info in the sheet).
The problem I have, is that where a value is the same, it returns the first occurence it comes across. So if 3 options all score 2.20, it will just return the first one in the list 3 times.
I want to find a way to create a unique score (so something like adding the average and then a series of "000000001" plus the row number or something. But when I have tried there are two issues:
1) if the average is a whole number, it doesn't include a decimal point (so an average score of 2 would return "200000000001" rather than "2.00000000001"
2) the 'Opportunities Ranking' sheet doesn't seem to recognise them anyway so is blank.
If there is a better way of doing this, I'm happy as long as it is fit for purpose. I don't really want to use VBA.
Help please
Steve
Ps the list of opportunities would be much longer, hence the need for this.
Bookmarks