How to use COUNT
Category: [Excel] Demo Available
How to use COUNT
Requirement:
Column A has number or a word for e.g cell A1 has 1000, A2 has again 1000 ,A3 has 2000 and so on...
I need a formula in B column which will show me exactly how many times its appeared in A column, i dont need the sum count of a word or number .
| asdf | 1 |
| asdf | 2 |
| asdf | 3 |
| asdf | 4 |
| asdf | 5 |
| asasas | 1 |
| asasas | 2 |
| asasas | 3 |
| dev | 1 |
| 1000 | 1 |
| 1000 | 2 |
Solution:
=COUNTIF($A$1:A1,A1)
Obtained from the OzGrid Help Forum.
Solution provided by AliGW.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to COUNTIF using input cell as range depth |
| How to use SUMPRODUCT and COUNT question for unique associations |
| How to work with complex COUNTIFS |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.