What to do with ties,

1 occurs 10 times
2 occurs 9 times
3 occurs 8 times
4 occurs 8 times
5 occurs 8 times
6 occurs 8 times

What is the range of your integers. 0 to 100 as an example.

the list is in both column A and B?

--
Regards,
Tom Ogilvy

"flex zax" wrote in message
...
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!