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 

 

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?
    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Mar 16, 2020
      Glad to hear your query is resolved 👍🏻
      Sure.. you can post as new question on the tech site..
      Regards, Faraz
      • Juan_Ochoa_Crespo's avatar
        Juan_Ochoa_Crespo
        Copper Contributor
        Mar 16, 2020

        thanks ExcelExciting 

        I am trying to multiply a range of values that are between dates using product(if(and(

        but it diesn't worhk. It works only with product(if(, but when I add and it does not work.

        Please see excel with example. Cells marked in yellow is the result I want to obtain, however you can see in cell marked in red that it doesn't work 

Resources