From: Kerry on 7 Apr 2010 04:48 I am looking to be able to put values in the order of 1 to 5 in a range of cells based on the order of values in another range - as an example the values in range (row) one may be 12,36,25,40,19 which would result in this being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense
From: Mike H on 7 Apr 2010 04:55 Hi, Let's assume these numbers are in A1 to E1. Put this in A2 and drag right =RANK(A1,$A$1:$E$1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Kerry" wrote: > I am looking to be able to put values in the order of 1 to 5 in a range of > cells based on the order of values in another range - as an example the > values in range (row) one may be 12,36,25,40,19 which would result in this > being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense
From: Pete_UK on 7 Apr 2010 08:57 Suppose you had those values 12, 36, 25, 40, 19 in cells A1 to E1, then you can put this formula in A2: =RANK(A1,$A1:$E1) and copy this across to E2 to give you the numbers you require. Hope this helps. Pete On Apr 7, 9:48 am, Kerry <Ke...(a)discussions.microsoft.com> wrote: > I am looking to be able to put values in the order of 1 to 5 in a range of > cells based on the order of values in another range - as an example the > values in range (row) one may be 12,36,25,40,19 which would result in this > being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense
|
Pages: 1 Prev: Sum and multiply at the same time? Next: How do I do a drop down box with calender in excel? |