Hi Sabegirl,


Try using Countif.

If you make a table like below you can refer to the cell reference
=COUNTIF($A$1:$A$6,C1)

C1 "Bread" D1 =COUNTIF($A$1:$A$6,C1)
C2 "Milk" D2 =COUNTIF($A$1:$A$6,C2)
C3 "Milk" D3=COUNTIF($A$1:$A$6,C3)

Note use F4 to add the $ so when you drag the formula down the range
stays absolute

otherwise just type in the word in a cell and replace the cell ref with
"Bread"

=COUNTIF($A$1:$A$6,"Bread")

Hope this helps

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553000