| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count number of times a text occurs
I want to count the number of times a text occurs in a range and then put
1,2,3,ect in a cell adjacent to the occurance. Apple 1 Apple 2 Apple 3 Apple 4 Banana 1 Banana 2 Banana 3 I can use the count function but it doesn't seem to help with the numbering. It seems like it should be simple but it probably isn't. Thanks for any help. -- Lee |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count number of times a text occurs
Try this, copied down
=COUNTIF($H$2:H2,H2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Lee" wrote in message ... I want to count the number of times a text occurs in a range and then put 1,2,3,ect in a cell adjacent to the occurance. Apple 1 Apple 2 Apple 3 Apple 4 Banana 1 Banana 2 Banana 3 I can use the count function but it doesn't seem to help with the numbering. It seems like it should be simple but it probably isn't. Thanks for any help. -- Lee |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count number of times a text occurs
Thanks, it works very well. I don't understand why but it does work.
Thanks, Lee "Don Guillett" wrote in message ... Try this, copied down =COUNTIF($H$2:H2,H2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Lee" wrote in message ... I want to count the number of times a text occurs in a range and then put 1,2,3,ect in a cell adjacent to the occurance. Apple 1 Apple 2 Apple 3 Apple 4 Banana 1 Banana 2 Banana 3 I can use the count function but it doesn't seem to help with the numbering. It seems like it should be simple but it probably isn't. Thanks for any help. -- Lee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| Count the number of times a name occurs in a column | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
Hybrid Mode
