Employees Hours

[GomaPile]

Hello there, I have a small question to ask if someone can kindly solved this for me please.

What I am trying to achieved here. A group of employees hours are being added up fortnightly, and would like a formula of some kind, from the lowest to the highest in the order from 1-8, even if there was 2 employees sharing or more the same hours they accrued, for eg;

order from 1-8:
20 - 1
35 - 3
60 - 8
55 - 7
40 - 5
40 - 6
30 - 2
35 - 4

Thanks
Goma (NASA)

 

[jeffreybrown]

How about...

=RANK(A1,$A$1:$A$8,1)+COUNTIF($A$1:A1,A1)-1

 

[T. Valko]

Hello there, I have a small question to ask if someone can kindly solved this for me please.

What I am trying to achieved here. A group of employees hours are being added up fortnightly, and would like a formula of some kind, from the lowest to the highest in the order from 1-8, even if there was 2 employees sharing or more the same hours they accrued, for eg;

order from 1-8:
20 - 1
35 - 3
60 - 8
55 - 7
40 - 5
40 - 6
30 - 2
35 - 4

Thanks
Goma (NASA)

One way...

Assuming your nmbers are in the range A2:A9.

Enter this formula in B2 and copty down to B9:

=COUNTIF(A$2:A$9,"<"&A2)+COUNTIF(A$2:A2,A2)

 

[GomaPile]

Thank-you all;

Thanks, T. Valko & effreybrown that works, awesome job and a pat on the back to you both

One way...

Assuming your nmbers are in the range A2:A9.

Enter this formula in B2 and copty down to B9:

=COUNTIF(A$2:A$9,"<"&A2)+COUNTIF(A$2:A2,A2)

How about...

=RANK(A1,$A$1:$A$8,1)+COUNTIF($A$1:A1,A1)-1

Thanks Again
Goma (NASA)

 

[T. Valko]

Thank-you all;

Thanks, T. Valko & effreybrown that works, awesome job and a pat on the back to you both





Thanks Again
Goma (NASA)

You're welcome. Thanks for the feedback!

 

[jeffreybrown]

Glad to see you got what you needed...good luck the rest of the way

 

[GomaPile]

Glad to see you got what you needed...good luck the rest of the way

will do mate! ...and many thanks with a big smile.