View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SKR SKR is offline
external usenet poster
 
Posts: 4
Default HOW DO I COLLECT TEXT DATA FROM A COLUMN

I have a worksheet of about 400 rows and 5 columns. Most of the data is
repeated with varying values. I need to calculate / separate data for each
item in the column. How do I do that? Iam using excel 2003. - for this
problem I tried to use the find command. But I am not able to save or copy
the data displayed. Any help is welcome.