I'm not sure if I titled this thread correctly.
Anyways, so I have data in Col.A that sometimes repeats itself.
I need to count how many times it repeats in Col.A with a numerical value in Col.B.
I've attached the following image for visual reference.
In the image below on the right, I've manually filled in the numbers, but there has to be a formula that will let me do this as I have thousands of lines to do this to.
http://farm7.static.flickr.com/6089/...4233260018.jpg
Hello & Welcome to the Board,
Try this copied down...
=COUNTIF($A$27:A27,A27)
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks