I need to analyze last value of each row and get top 10 of repeating values

O

Oleg

I need to analyze last value of each row and get top 10 of repeating
values

For example
A B C D E F G H I J
-------------------------------
1|112 4 8 ...... 3
2|55 54 ...... 3
3|1 7 3 2............9
4|82 977 15................................10
5|45 477............................................9
6|77 2244..........................9
7|557 4458..............................9
8|78 428...................................10
9|44 326.........................10


In result I want to get TOP
1. 9 (4 times)
2. 10 (3 times)
3. 3 (2 times)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top