I need to analyze last value of each row and get top 10 of repeatin
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)
__________________
Ole
--
Ole
-----------------------------------------------------------------------
Oleg's Profile:
http://www.excelforum.com/member.php...nfo&userid=400
View this thread:
http://www.excelforum.com/showthread.php?threadid=52049