View original (French)

Ranking by a criterion or rank if.

eygalayes -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
I am a farmer and I want to extract from a cattle database the birth rank of each calf (calf 1, 2...) according to each mother. I need this reference to calculate the calving/calving interval for each mother based on the recorded births.
A RANGSI formula would suit me perfectly.
I would also like to use the formula today but static without the update.
Thank you.
Configuration: Windows XP / Internet Explorer 7.0

2 answers

  1.
    Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Hello,

    I don't understand your presentation very well because it lacks details, but if you need a condition, I could suggest
    =IF(your_condition,RANK(),"")
    if your condition is met, it calculates the rank; otherwise, it leaves the cell empty.

    Have a nice day
    --
    Every problem has a solution... you just have to be persistent.
    1
    1. eygalayes
       
      Hello and thank you for this response.
      I will try to be clearer.
      Each line corresponds to an animal, and I want each line to have a cell that indicates the birth rank of that animal (in the line) compared to its siblings. The criterion (which could correspond to a formula if) is the mother, who is located on a higher line.
      -1