Forum Discussion
Top 5 if date is equal to a cell
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.
Does the attached file show the intended result?
- 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- 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!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.
