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

I think you need to assume that we are not mind readers or conversant with
whatever you are talking about. Pls give a detailed explanation of what you
want with before and after examples.

--
Don Guillett
SalesAid Software

"NoviceinEXCEL" wrote in message
...
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

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

In the absense of any detail, try this idea

Sub categorize()
For Each c In Range("b2:b12")
Select Case c.Value
Case Is = "Sun", "Tues", "Thur": x = 3
Case Is = "Mon", "Wed": x = 4
Case Else
End Select
c.Offset(, 4) = x
Next c
End Sub


--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
I think you need to assume that we are not mind readers or conversant with
whatever you are talking about. Pls give a detailed explanation of what you
want with before and after examples.

--
Don Guillett
SalesAid Software

"NoviceinEXCEL" wrote in message
...
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