Sort working OK but adjacent value column not

Hi all,The code below sorts the figures out in each block of rows then places the position of that figure in the adjacent column,like this where the smallest number is 1 second smallest 2 and so on.
CI CJ
1 24
2 26
3 29
4 34
5 35
6 37

Please Login or Register  to view this content.

the problem arises when there are identical numbers(two or more in col j).In the following eg there are three identical
numbers in3, 4 and 5.And the code does a good job of placing them as all 3rd in position,but then instead of the final cell(184) being 4th it presents as 6th.Likewise if cells 1,2,3 were identical cell 4 would then present itself as 4th as opposed to 2nd,and so on.
1 143.0
2 144.0
3 145.0
3 145.0
3 145.0
6 184.0
does anyone have any suggestion as to modify the code to ensure that the cells values in the J cells are correctly reflected in th I cells adjacent
Kind RegardsBIF

Hi,

Why can't you just write integers chronologically in the adjacent row? After the data is sorted, delete the integer row and just add consecutive numbers. That might be a lousy solution but might be all you need.

Please provide a sample workbook showing BEFORE, AFTER, and CURRENT results.

Hi IronFelix,
Thanks for the reply. The blocks of six(or less) rows that are divided by an empty row that can run in hundreds of blocks.Typing in manually would take quite a long time
The code written so far manages a sort of hybrid chronology,but is not accurate because if identical numbers appear in the designated column (J here) although the postion column will identuify them as 1,2,3rd ect,it misses out the next chronological sequence.So if there were 3 identical number one's the next should be number two,but instead it shoots up to number 4.