Custom sorting method Excel VBA

Question

I have a column of numbers, that have to be sorted like this:

I have one number in A1, which is the precise value from I start -e.g. 10 and then I have numbers like: 9, 8.1, 11, 6, 10.5

My goal is to sort them from the least different. It means:

10, 10.5, 11, 9, 8.1, 6.

In Java it would be done by compareTo function. Is there something like this is VBA?

Pragmateek · Accepted Answer · 2012-12-20 08:04:10Z

4

If no cleaner way exists you could try the following workaround :

define a distance function like this : abs(x - from) and sort by its results, maybe in a temporary/hidden sheet if you want to apply sort in a transparent manner.

edited Dec 20, 2012 at 8:04

answered Dec 19, 2012 at 22:31

Pragmateek

13.6k9 gold badges80 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Doug Glancy Over a year ago

+1 that seems clean enough to me :). I'd just put it in a column, hidden or otherwise, in the same sheet. (You might want to edit the first word of your answer for future generations.)

Collectives™ on Stack Overflow

Custom sorting method Excel VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related