View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How can I make categories out of my data?

Try adding a new column to your data field and typing in it the "category"
for each row........then later, this column can be used for sorting, and/or
Autofiltering to bring all the like rows together..........

hth
Vaya con Dios,
Chuck, CABGx3

"NoviceinEXCEL" wrote:

I would like to create categories, like in SPSS when we use the "compute"
fonction. I would like to compute the existing data into new categories