Identify is a little vague. Are you trying to aggregate based on finding CU
in a field. If so then check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Check out example 9 at the bottom.
If you just want to know if a cell is contains CU then you can use Find or
Search. Look them up in help.
--
HTH...
Jim Thomlinson
"pa1971" wrote:
I would like to identify only the values in a spreadsheet with "CU" included
in them. That "CU" could be at the beginning, end or middle of the values in
the column. In access I could use the LIKE feature. Is there anything
similar in Excel to identify them?
Thank you!