Ranked column of numbers (1 up to 15) which come up as 1,2,3,3,5,6,7,8,9,9

**Securitysports** · 11-04-2013, 01:14 AM

Hello,

Looking for someone who knows how to fix this issue.

Book 2 is attached.

I have in column B

183
127
183
107
143
176
173
138
198
163

I have in column C and values of column C ranked in column D

19 05
31 08
17 02
33 09
26 06
15 01
33 09
30 07
18 03
18 03

What I am hoping to have listed in columns B, C & D is:

183 19 04.1
127 31 07.1
183 17 02.1
107 33 09.2
143 26 05.1
176 15 01.1
173 33 09.1 -- 9.1 because 173 > 107
138 30 06.1
198 18 03.1 -- 3.1 because 198 > 163
163 18 03.2

Is there a formula that would make this possible?

**FDibbins** · 11-04-2013, 01:53 AM

Securitysports, without anyone knowing where the 0.401 etc comes from, they would have no idea what you are talking about. That is why I have asked to stop posting duplicate threads, and to continue on the previous 1.

This is essentially a continuation of...
http://www.excelforum.com/excel-form...olumn-a-b.html
Please continue on that thread, and stop posting duplicate threads

This thread is now closed

Ranked column of numbers (1 up to 15) which come up as 1,2,3,3,5,6,7,8,9,9

LinkBack

Thread Tools

Display

Ranked column of numbers (1 up to 15) which come up as 1,2,3,3,5,6,7,8,9,9

Re: Ranked column of numbers (1 up to 15) which come up as 1,2,3,3,5,6,7,8,9,9

Thread Information

Users Browsing this Thread

Similar Threads

Excel puts ranked column of cells in wrong order used =MATCH(LARGE(D:D,ROW()),D:D,FALSE)

[SOLVED] Want to link ranked of cells in 1 column w/values in corresponding cells of another column

[SOLVED] Getting Excel 2007 to list the cell numbers of the top five ranked numbers in a column.

[SOLVED] Choosing highest ranked value in a row text and numbers

Row and column labels of ranked data

Bookmarks

Bookmarks

Posting Permissions