Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating values | Excel Worksheet Functions | |||
repeating values | Excel Worksheet Functions | |||
can i stop repeating values? | Excel Discussion (Misc queries) | |||
excluding repeating values | Excel Discussion (Misc queries) | |||
Repeating Values | Excel Programming |