I might be missing it Barbara, but I don't see the connection between my
question and your answer.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Barbara" wrote in message
...
Hi Bob,

Yes. As an example, I can create a table like this one:
--------------------------------------------------------------------------
----------
NUCLEO PED1 PED2 PED3 PED4 PED5 PED6
--------------------------------------------------------------------------
----------
CN CN
DIVERSOS PS VB VC VK VP XK
NUCLEO1 VS VV VF VJ VL
NUCLEO2 VR VX VG VI
NUCLEO3 VA VN VD
NUCLEO4 VO VZ

But I would prefer to enter these values on the formula!

"Bob Phillips" escreveu:

How do you know which group the codes go in?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Barbara" wrote in message
...
Hi,
I have a spreadsheet where one of the columns displays a code (ex: VA,
,
CN,
VF, VV,...)

I need to display in a new column the group of these codes.
ex:
VA+CN=Group1
VF= Group2
VV=Group3

Should anyone can give me a clue???
Thanks a lot,
Barbara