Forum Discussion
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 working i already tried a few changes but no result can any of you help me with this?
=SE(B5=Folha4!B1:N1;(MAIOR(Folha4!B$2:N$106;Resumo!E3));)
column c is top 1 (= to welcome Wich is allways top1 for the date wich is in in cell B$5:B$16 )
top intent 1 is top 2 (= to top 2 for that date)
i used this one for the top intent 1 wich is top 2 of data
=SE(B5=Folha4!B1:N1;(MAIOR(Folha4!B$2:N$106;Resumo!E3+1));)
and i need to show the name of tops on descrição cell for that value of top.
i know 2 diferent formulas this one should be easy i just need to use corresp formula to go look for the name on that value .
Can someone please help me with this?
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.
7 Replies
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!
