Hi all,

Can anyone tell me if there's a quick formula that can be done with the
following, please, to show only the amount of times 'apples' appears in
a row at the bottom of the list? For example:

apples
grapes
bananas
apples
pears
apples
apples
apples

The formula should show '3'.

This list would be updated with further fruity developments, so the
formula should be able to adapt to show only the times 'apples' appears
at the bottom of the list in a row.

Would be most appreciated if anyone knows the answer.

Many thanks,
Dan.


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=525630