Forum Discussion
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...
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?