View Single Post
  #1   Report Post  
sroehl
 
Posts: n/a
Default extracting numerical data

I have cells in my worksheet containing results from using ="text"&COUNTIF...
For example, one cell contains "exc 9", because there are nine times "exc"
is seen in the column. I want to know if I can extract the numerical data
from these cells to use in pie charts. Excel 2002 SP-2.