Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum items occurring in a month and year | Excel Discussion (Misc queries) | |||
Countif - How do I count the number of job titles occurring in a l | Excel Discussion (Misc queries) | |||
count number occurring within specific date range | Excel Worksheet Functions | |||
most frequently occurring value | Excel Discussion (Misc queries) | |||
A list of Consecutive Integers, can I search for missing integers | Excel Worksheet Functions |