| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 34514 | 2003-06-15 22:37:00 | Excell Question | jeep (1673) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 152807 | 2003-06-15 22:37:00 | I have a list of numbers, some of which re-occur. Has excell a function which will count the number of unique numbers? eg list - 1,2,3,3,4,5,5 --> count=5 |
jeep (1673) | ||
| 152808 | 2003-06-15 22:56:00 | Offhand I would say no, apart from sorting the list by the number range and using Data - Subtotals Its a messy solution though. |
godfather (25) | ||
| 152809 | 2003-06-16 00:38:00 | Hi jeep Are the numbers in sequence eg will the same numbers be bunched together in corresponding cells of the row/column or will they be spread out with other numbers between. Also, if the numbers are not in sequence, are you able to sort them. Craigb |
Craigb (688) | ||
| 152810 | 2003-06-16 03:52:00 | If your data range contains only numbers or blank cells, and not text, the following formula will work. Edit "A1:A10" to suit your own data. =SUM(N(FREQUENCY(A1:A10,A1:A10)>0)) HTH |
Russell D (18) | ||
| 1 | |||||