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
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 26, 2021

Jupiter1 Are you familiar with "Get&Transform Data" (a.k.a. Power Query)? Then, it will be not so difficult to extract the information you need. 

 

Alternatively, if you are an MS365 subscriber with access to the latest functions like FILTER and UNIQUE, it's relatively easy as well with some helper columns.

 

 

  • 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