Selecting values from low to high

**jumbobaboon** · 05-16-2013, 11:06 AM

Dear forum members,

I'm new to this forum so hi everyone

Let me explain the problem I'm currently having: I want to select values of one column and arrange them from low to high. I already selected the sort menu, but the problem is that values are selected based on digits, not on absolute values. I attached a screenshot to make things more clear.

Hopefully you could tell me what to do.

Kind regards,

Jeroen

jeroen example.png

**XOR LX** · 05-16-2013, 12:22 PM

Hi Jeroen,

If you could post a small sample of your workbook rather than a screenshot it would be of benefit.

Regards

**newdoverman** · 05-16-2013, 12:26 PM

Use a helper column. Assuming that your data is in columns A and B enter this formula (enter the range that you have) in column C and copy down the length of your data.

Formula:

Please Login or Register  to view this content.

Substitute your actual range in place of $b$1:$b$6 then select all the columns and sort on column C

**jumbobaboon** · 05-16-2013, 02:50 PM

Thanks for your replies.

@newdoverman, I applied your formula. I'm still experiencing problems, I'm using column A and B. I stated the formula as following:
=RANK(B1,$B$1:$J$360,1) but it gives me a #VALUE! problem when executing it. I guess something is wrong with B1 in the formula. B1 is actually the first value in the column B.

@all: I'll attach the example worksheet as requested.

example worksheet.xlsx

Thanks in advance!
-Jeroen