Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'd like to see if I can set up a counting system for counting the number of
occurances in a series of cells. For example, I have a row with the following (it's a team schedule): 1 x 3 5 x 10 3 x 9 11 x 12 4 x 5 I'd like to see how often a number would appear. In this case, the number 1 would appear 1 time, the number 3 appears twice. Thanks, Gil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Subtotal counting formula in cells | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting filled cells in excel | Excel Worksheet Functions | |||
Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions |