| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 68178 | 2006-04-20 04:18:00 | Excel Formula | rny (6943) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 447882 | 2006-04-20 04:18:00 | Can anyone help with the formula required to recognise and count the number of times a specific value is reached on a line in a spreadsheet? The spreadsheet is for a sportsclub and records scores, and we need to be able to count the number of times a particular score is reached. rny. |
rny (6943) | ||
| 447883 | 2006-04-20 04:52:00 | =countif may be the function your looking for. | gcarmich (10068) | ||
| 447884 | 2006-04-20 05:00:00 | I also suspect the "frequency" command may be what you need. Use Excel Help for details on using it, its not really possible to be specific as we don't know what your spreadsheet layout is. |
godfather (25) | ||
| 447885 | 2006-04-20 06:37:00 | Thanks, will try both. rny. |
rny (6943) | ||
| 1 | |||||