Forum Discussion

Skymaze's avatar
Skymaze
Copper Contributor
Sep 13, 2022
Solved

Excel Sort Data by criteria

I have a list of employees that populates their rates.  I rank them by best rate.  I would like to be able to split the rank list to staff in different departments.   So if I have 10 people ranked bu...
excel
Formulas and Functions
Macros and VBA
  • Martin_Weiss's avatar
    Martin_Weiss
    Sep 14, 2022

    Hi Skymaze,

     

    ok, then I completely misunderstood you at first. You want the asignment column to be calculated, not the rank column.

     

    I found a relatively complex solution that should do the trick:

     

    =IF(OR(
    AND(ISODD(D9),(D9/2)<=$C$5,D9<=($C$5+$C$6)),
    AND(ISEVEN(D9),(D9/2)>$C$6,D9<=($C$5+$C$6))),"Receive",
    IF(OR(
    AND(ISEVEN(D9),(D9/2)<=$C$6,D9<=($C$5+$C$6)),
    AND(ISODD(D9),(D9/2)>$C$5,D9<=($C$5+$C$6))),"Ship",""))

     

    I'm sure some clever guys will find an easier solution, but for me it seems to work. Just give it a try.

Resources