Forum Discussion

Juan_Ochoa_Crespo's avatar
Juan_Ochoa_Crespo
Copper Contributor
Mar 16, 2020
Solved

Find a date and multiply Nº rows before

Dear All: I need to find different dates of a list, find its value and multiply the 12 previous rows. See example Thank you!  enero 1999 3,84%     31/12/1999 31/12/2000 febrero 1999 0,...
excel
  • ExcelExciting's avatar
    ExcelExciting
    Mar 16, 2020

    Hi Juan_Ochoa_Crespo 

     

    Please see the attached sample file for your reference and the formula reads as below in the screen shot

     

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

ExcelExciting's avatar
ExcelExciting
MVP
Mar 16, 2020

Hi Juan_Ochoa_Crespo

 

Could you please explain what is your desired result. Just manually add the result It will be easy to understand your query.

 

Regards, Faraz Shaikh

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Mar 16, 2020

      Hi Juan_Ochoa_Crespo 

       

      Please see the attached sample file for your reference and the formula reads as below in the screen shot

       

       

      Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

      If you find the above solution resolved your query don't forget mark as Official Answer.

      • Juan_Ochoa_Crespo's avatar
        Juan_Ochoa_Crespo
        Copper Contributor
        Mar 16, 2020
        Thank you so much!. Great help!!
        Do you mind if I send you another question?

Resources