Forum Discussion

Pedro_Duarte's avatar
Pedro_Duarte
Copper Contributor
Aug 11, 2023
Solved

Top 5 if date is equal to a cell

Hello    I need it to do something like this but with a formula i have this data to use, i can do it manualy but i have to do this montlhy   i tried this formula but it's not workin...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Aug 11, 2023

    Pedro_Duarte 

    I didn't understand what you want to do. Now i can give you the formulas for the columns Qte Acessos of your file. For columns Descrição i don't have a solution right now maybe an expert of the community can give you the formulas for these columns.

     

    =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),1)

    This is the formula for Top Intent 1. For Top Intent 2 and so on only the "1" in the end changes.

     

    =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),1)

    =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),2)

    =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),3)

    and so on.


     

Pedro_Duarte's avatar
Pedro_Duarte
Copper Contributor
Aug 11, 2023
the file is where i'm testing the formulas.
in the 1st image i posted is the intended result but i did it by hand with no formulas
  • Pedro_Duarte's avatar
    Pedro_Duarte
    Copper Contributor
    Aug 11, 2023
    i saw your 1st answer and i tried it before
    =ÍNDICE(Folha4!$B$2:$N$106;1;(CORRESP(B7;Folha4!$B$1:$N$1;0)))
    and it works for my top 1 that is not named top 1 it's in column C
    And the Top Intent 1 is on my data the top 2 so i tried this formula:
    =SE((CORRESP(B5;Folha4!$B$1:$N$1;0));(MAIOR((Folha4!$B$2:$B$106);(Resumo!$E$3+1)));)
    and it shows me the correct value for the top 2 on that day but when i try to use it on other days it only shows me the data from the day on the first row....
    And many thanks for the help!

    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Aug 11, 2023

      Pedro_Duarte 

      I didn't understand what you want to do. Now i can give you the formulas for the columns Qte Acessos of your file. For columns Descrição i don't have a solution right now maybe an expert of the community can give you the formulas for these columns.

       

      =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),1)

      This is the formula for Top Intent 1. For Top Intent 2 and so on only the "1" in the end changes.

       

      =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),1)

      =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),2)

      =LARGE(IF(Folha4!$B$1:$M$1=Resumo!B5,Folha4!$B$3:$M$106),3)

      and so on.


       

      • Pedro_Duarte's avatar
        Pedro_Duarte
        Copper Contributor
        Aug 11, 2023

        OliverScheurich 

         

        maybe you can help me with this formula also

         

        =ÍNDICE(Folha4!$A$2:$N$106;CORRESP(F5;Folha4!$A$2:$N$106;0);1)

         

        it's supposed to look for the value in that column and give me the "descrição".

        i think i'm locking soimething i shouldn't but i cant see what i did wrong in the formula

         

Resources