Forum Discussion

Jupiter1's avatar
Jupiter1
Copper Contributor
Jan 26, 2021

Formula to find value between rows with matching data

Hi All,   I'm trying to get a formula that retrieves an amount from Sheet 1 based on looking at the dates between rows specified for each persons ID. The problem I have is the format of data, as th...
Formulas and Functions
Jupiter1's avatar
Jupiter1
Copper Contributor
Jan 26, 2021

HiRiny_van_Eekelen 

 

Luckily I have access to filter and unique function....so I'm excited it is achievable.

 

Look forward to learning more

 

Thanks

  • Jupiter1's avatar
    Jupiter1
    Copper Contributor
    Jan 27, 2021

    HiRiny_van_Eekelen

     

    Fantastic....That is amazing!!!! It works like a dream now.

    Thank you so so much for all your help.

     

Resources