next smallest non unique

[abanky]

I have a calculation that assigns each row a number like this

Column B
B4 1
B5 8
B6 9
B7 1
B8 2
B9 2
B10 3
B11 3
B12 4

I'm looking for my row 3 to look like this
c3 1 d3 2 e3 3 f3 4 g3 8 h3 9 i3 9 j3 9 k3 9

I can't seem to get the small function to put them in the order i want

Thanks, Andrew

 

[barry houdini]

Hello Andrew,

Try putting this formula in C3

=MIN(B4:B12)

and then in D3

=MIN(IF($B4:$B12>C3,$B4:$B12),MAX($B4:B$12))

confirmed with CTRL+SHIFT+ENTER and copied across

 

[abanky]

it blows up for me in the first part of the calculation