Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeating values Peach Excel Worksheet Functions 1 November 29th 09 02:45 AM
repeating values [email protected] Excel Worksheet Functions 2 June 12th 08 04:55 PM
can i stop repeating values? Haitham Excel Discussion (Misc queries) 2 August 3rd 06 09:01 AM
excluding repeating values neda5 Excel Discussion (Misc queries) 2 July 10th 05 11:59 PM
Repeating Values Elaine Excel Programming 3 March 1st 05 06:47 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"