Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula question
OK, here is the problem:
I have a worksheet, a very large worksheet that looks like this: Column a 1 1 1 2 2 2 2 2 3 3 3 I need a formula that tells me how many ones, how many 2s, and how many 3s are in the column. I have about 1 million numbers and need to apply the formula to the entire column. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula question
=COUNTIF(A:A,ROWS($B$1:B1)) and copy down
-- Gary''s Student - gsnu201003 "Ed" wrote: OK, here is the problem: I have a worksheet, a very large worksheet that looks like this: Column a 1 1 1 2 2 2 2 2 3 3 3 I need a formula that tells me how many ones, how many 2s, and how many 3s are in the column. I have about 1 million numbers and need to apply the formula to the entire column. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula question
On Fri, 14 May 2010 06:28:01 -0700, Ed wrote:
OK, here is the problem: I have a worksheet, a very large worksheet that looks like this: Column a 1 1 1 2 2 2 2 2 3 3 3 I need a formula that tells me how many ones, how many 2s, and how many 3s are in the column. I have about 1 million numbers and need to apply the formula to the entire column. Thanks For just 1's, 2's and 3's, you could use countif: =countif(a:a,1) If there are a large number of unique numbers, you might want to look at using a Pivot Table. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
Formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
If Formula Question | Excel Worksheet Functions |