If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula
I don't know too much about formulas, but need a formula
to look at a column of numbers and give me the number that repeated most often, and how many times it repeated. Hope that made sense. Thanks. |
#2
|
|||
|
|||
See if this works:
For the first formula, use "Mode". For example, in B1 enter: =Mode(A1:A50) replacing your range for A1:A50. For the second formula, use "Countif", entering in B2: =countif(A1:A50,B1) -----Original Message----- I don't know too much about formulas, but need a formula to look at a column of numbers and give me the number that repeated most often, and how many times it repeated. Hope that made sense. Thanks. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a SUMPRODUCT formula to COUNTA active... | BeSmart | Worksheet Functions | 8 | March 27th, 2004 03:36 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Offset formula | Frank Kabel | Worksheet Functions | 5 | March 15th, 2004 09:50 PM |
Dynamic formula to sum across rows | turtleman2 | Worksheet Functions | 5 | March 8th, 2004 08:11 PM |
Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |