NoobQ: Rank function treats negative values as positive values. Help!

Post a workbook with sensitive data removed and explain in context.

It worked fine for me. Remember that using ,0) means it ranks small to large (I referenced the sort order in M1)...

	L	M
1	Descending -->	0
2	-1	8
3	0	7
4	1	6
5	2	5
6	3	4
7	4	3
8	5	2
9	6	1

M2 down contains =RANK(L2,$L$2:$L$9,$M$1)

Or ascending...

	L	M
1	Asacending --->	1
2	-1	1
3	0	2
4	1	3
5	2	4
6	3	5
7	4	6
8	5	7
9	6	8

Attachment 270698 Not sure if it worked or not. That is pretty much the gist of what information I'm using. Any help will be appreciated! Thank you guys!

There. I think this one will work. Sorry about that!

Thanks for the file.

I dont see what the problem is, it looks to me to be working perfectly?
C4=-2530 with a rank of 9 (the smallest)
C8 = 14 749 with a rank of 1 (the largest)

Can you point out which rankings you think are wrong please?

The places it's not working is for the 'Bedding' and 'Delivery' sections on Sheet 3. See how it ranks the -5,ooo one as Rank 1 in the 'Bedding' And puts the only negative value used in 'Delivery' as Rank 7, even though it is clearly supposed to be Rank 9. It's being screwy with the negatives =P

1. rank on value, not %
2. I would suggest that you keep the same sequance in your table - value column then rank column