| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting numbers in a series
Hi Everyone
I have a problem that's driving me crazy. Say this is my data set Row 1: 1 2 3 4 Row 2: 2 5 6 1 Row 3: 2 4 1 8 Row 4: 2 3 6 7 I want to find how many times the numbers 1 and 2 appear in each row. In the dataset above, the answer would be 3 (i.e. rows 1, 2 and 3). In my real dataset, I have 1090 rows. Anyone got any ideas??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't sum a series of numbers | Excel Discussion (Misc queries) | |||
| Part 2 - Counting series of text/number sequence | Excel Discussion (Misc queries) | |||
| Counting a series of text and/or numbers within columns | Excel Discussion (Misc queries) | |||
| Series of numbers | New Users to Excel | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Threaded Mode
