LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default MOST & LEAST OCCURRING INTEGERS !

I need help with the following please:

1. In sheetA Range("A2:B200") there is a price list (integers). I need
a macro that will loop through the range and list the 4 integers which
appear most in the range. The macro should list these 4 most occuring
integers in Range("C2:C4")

2. Also, I need a second macro that will list the 4 least occurring
integers in the same range("A2:B200"). This list should be placed in
Range("D2:D4)

I will greatly appreciate any assistance. Thanks.
~Flex~

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
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
Sum items occurring in a month and year Saylindara Excel Discussion (Misc queries) 3 November 23rd 09 03:11 PM
Countif - How do I count the number of job titles occurring in a l dsmith@organic Excel Discussion (Misc queries) 3 October 26th 06 07:33 PM
count number occurring within specific date range Ducky Excel Worksheet Functions 1 July 11th 06 06:49 AM
most frequently occurring value Pivotrend Excel Discussion (Misc queries) 3 December 23rd 05 11:57 AM
A list of Consecutive Integers, can I search for missing integers CM Excel Worksheet Functions 4 September 2nd 05 06:38 PM


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

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

About Us

"It's about Microsoft Excel"