Make that Your data in A1:B9...

"Jim May" wrote in message
news:R2fNf.192789$oG.154674@dukeread02...
With your data in A1:A9 I entered in Cells C1
=A1&B1

and in D1 =COUNTIF($C$1:$C$9,C1)

and copied down

Maybe?

"huntingbugg"
wrote in message
...

I am trying to count the number of items times two words are displayed
next to each other in two different columns
For example below:

Cat Leg
Dog Arm
Horse Leg
Dog Arm
Cat Leg
Horse Arm


Is there a formula that I can use to count the number of times cat and
leg apear next to each other


--
huntingbugg
------------------------------------------------------------------------
huntingbugg's Profile:
http://www.excelforum.com/member.php...o&userid=32019
View this thread:
http://www.excelforum.com/showthread...hreadid=517719