Shanmu has brought this to us :
Below is the scenario. I have 2 columns. Column A has some article Ids
(IS123, IS1234, etc.). Column X has Solutions provided to customer,
where this article Id would be a reference (substring.)
I need the to compare each article Id (column A) with all solutions
provided (Column X) and get the count of occurrences of each article Id
in Column B.
Please Help!!
-Shanmu
The COUNTIF() function is what you need, and usage can be found under
the Function Reference in online help.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion