View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oleg[_2_] Oleg[_2_] is offline
external usenet poster
 
Posts: 1
Default I need to analyze last value of each row and get top 10 of repeating values


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