Thanks, Morrigan - it worked.
I came across a new problem. Let's say I have two columns.
Column A: AAABBCAABBCCCABC etc.
Column B: 00000001111111222 etc.
The numbering increases when the series starts repeating in column A.
I only want to count the A's, B's etc for the same number in column B.
I know I can easily do it with a Pivot table, but I would like to try
avoid that.
Thanks again,
Ari Bari
--
AriBari
------------------------------------------------------------------------
AriBari's Profile:
http://www.excelforum.com/member.php...o&userid=25043
View this thread:
http://www.excelforum.com/showthread...hreadid=388069