game_federer
New Member
Hi All,
I have uploaded a file and I need some help regarding the application of filters on my data.
In the U column you can see the values over which my filter needs to work.For finding out summation of a column I used SUMIFS which is working just fine. Now I have 2 questions:
1. How can I use those filter values over a column which is not numerical, say reco_all. I want the reco_all value that occurs the max amount of times using the filters given. (Also, these filters are dynamic as those values will change as the user might choose to change them.)
2. Also, what if I have 1000000 rows of similar data and I want just the top 10 rows according to the filters? Is there a way to get just the top 10 or 20 rows?
Thanks in advance for your help. Cheers.
I have uploaded a file and I need some help regarding the application of filters on my data.
In the U column you can see the values over which my filter needs to work.For finding out summation of a column I used SUMIFS which is working just fine. Now I have 2 questions:
1. How can I use those filter values over a column which is not numerical, say reco_all. I want the reco_all value that occurs the max amount of times using the filters given. (Also, these filters are dynamic as those values will change as the user might choose to change them.)
2. Also, what if I have 1000000 rows of similar data and I want just the top 10 rows according to the filters? Is there a way to get just the top 10 or 20 rows?
Thanks in advance for your help. Cheers.