0
I have a site where generates statistics in . txt, this txt after and generated in excel with all the results. My goal is to create a top of the most viewed articles. This and example:
In the notebook you have:
ID | Nome artigo clicado
1 Rato
Knowing that will exist more than 100 equal ids, I want excel to check and make count of the same id...
txt files are in csv? Separated in what way? Spaces and line breaks?
– danieltakeshi
They are set in this way example 230:car are separated by ":"
– Joao
But my question is not Ssaa, pk I have already created excel, just want in excel I own create a function that check the repeated , contains and make a Top10 gender of the most counted
– Joao
Have you tried using a dynamic table with counting and filtering by value in "10 More" ?
– Isac
This is what I was going to say, do like in the @Isac tip. Create a dynamic table and sort the values from the highest to the lowest or the top 10. Or a VBA function to import . txt automatically and sort the data in a matrix. You can find various functions to work with vectors and matrices on Cpearson.
– danieltakeshi