| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Occurences In range
I have a range in a worksheet and need to progmatically determine the
number of occurences of each piece of data. Can anyone help me out please. As an example cells A1:A10 might contain: A1 Fred A2 Peter A3 Peter A4 Fred A5 John A6 Simon A7 Paul A8 Mark A9 Luke A10 Simon I need to return: Fred 2 Peter 2 John 1 Simon 2 Paul 1 Mark 1 Luke 1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of Occurences In range
Hi
you can use COUNTIF worksheet function in code itself see Chip's site at cpearson.com hth Tim -----Original Message----- I have a range in a worksheet and need to progmatically determine the number of occurences of each piece of data. Can anyone help me out please. As an example cells A1:A10 might contain: A1 Fred A2 Peter A3 Peter A4 Fred A5 John A6 Simon A7 Paul A8 Mark A9 Luke A10 Simon I need to return: Fred 2 Peter 2 John 1 Simon 2 Paul 1 Mark 1 Luke 1 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| Count Number of occurences of several texts in a range of cells | Excel Worksheet Functions | |||
| How to count the occurences in my range with 2 characters only? | Excel Worksheet Functions | |||
| counting occurences in data range (e.g 31-60) | Excel Worksheet Functions | |||
| How do I count the number of alpha occurences in a range? | Excel Worksheet Functions | |||
Linear Mode
