grouping function

[mtsf26]

hi all.i just wondering is it possible if i have data al,bl,cl group as local ; ai,bi,ci group as industry and ah,bh,ch group as hara. example:
al | local |
ai | industry |
cl | local |
thanks in advance.

[Bob Phillips]

I think some more explanation is required, that is not at all clear (to me).

[mtsf26]

hey thanks for reply...
let say..i have a few data in column A...ai,bi,ci,ah,bh,ch,al,bl and cl..
then in column B:
if in column A data is ai,bi,ci then in column B written INDUSTRY.
if in column A data is ah,bh,ch then in column B written HARA.
if in column A data is al,bl,cl then in column B written LOCAL.
and so forth..

[Bob Phillips]

Try this formula

=IF(OR(A2={"ai","bi","ci"}),"INDUSTRY",IF(OR(A2={"ah","bh","ch"}),"HARA",IF(OR(A2={"al","bl","cl"}),"LOCAL","")))

[mtsf26]

hey thanks for the solution.it work.. :)