Cloest Number (1 Viewer)

[carlnewboult]

Hi,

I have a spreadsheet (it can't be moved in access as that's the format the boss want's it in) which looks and the monthly average and then works out the difference between each date. What I am struggling with is how to then display this in a way which shows closest to furthest away. I have tried to sort this into order but it will place the positive numbers before negative.

Example

1
-2
-3
4

etc

obviously this would not be as exact but it should add to my description

Thankyou in advance

 

[Dave H]

Can you have another column that sorts based on the absolute value?

 

[carlnewboult]

Can you have another column that sorts based on the absolute value?

Thanks for responding how would I do that ? I think my brain has left me as I cannot see how to do it

Thanks

 

[shades]

Say that your data is in column B, then in an empty column, say H, put this formula in H2 (assumes data starts in row 2):

=ABS(B2)

Copy that down as far as the data, then sort based on column H.
________
VAPORGENIE VAPORIZER

 

[carlnewboult]

Say that your data is in column B, then in an empty column, say H, put this formula in H2 (assumes data starts in row 2):

=ABS(B2)

Copy that down as far as the data, then sort based on column H.

Thanks for that I have not heard of the ABS function.