Forum Discussion

DanT-N's avatar
DanT-N
Copper Contributor
Jan 18, 2024

Can I rank my data in this unique way?

 I have a tracker (not pictured) and this picture you see is the overview of the tracker and updated in real time. I categorise the data from the tracker into these 9 slots    time done  poi...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 19, 2024

Hi DanT-N 

 

There might be something to do (below ranking is auto. when [Time done] is updated):

 

Depends on where/how your data are stored, which version of Excel you run...

Feel free to follow recommendations in Welcome to your Excel discussion space!

  • DanT-N's avatar
    DanT-N
    Copper Contributor
    Jan 19, 2024
    Also I understand how u got the time to rank but how did u get the score/percentage to follow and automatically write below? Not sure on that one
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jan 19, 2024
      What version of Excel do you run? I did it with 365 and can share it...
      • DanT-N's avatar
        DanT-N
        Copper Contributor
        Jan 19, 2024
        Yea I’m on 365 too
  • DanT-N's avatar
    DanT-N
    Copper Contributor
    Jan 19, 2024

    Lorenzo Hi yea thanks for trying 

     

    I’m sure there’s a way to do it I’ll keep asking around aha 

     

    I’ll have a look at that discussion space  too thanks 

Resources