| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas!
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
Sorry,
The column NUCLEO is the value that I want to insert. So when Excel finds a value VS, I want him to return "NUCLEO1" "Barbara" escreveu: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
Ok,
Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
Is the text such as
GROUP1 VS;VV;VJ;VL all in one cell, or many cells? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Ok, Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
GROUP1 is in one cell; the others are together in another cell.
"Bob Phillips" escreveu: Is the text such as GROUP1 VS;VV;VJ;VL all in one cell, or many cells? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Ok, Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
=INDEX(Sheet2!$A$1:$A$20,SUMPRODUCT(--(ISNUMBER(SEARCH(Sheet1!B1,Sheet2!$B$1
:$B$20))),ROW(Sheet2!$B$1:$B$20))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... GROUP1 is in one cell; the others are together in another cell. "Bob Phillips" escreveu: Is the text such as GROUP1 VS;VV;VJ;VL all in one cell, or many cells? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Ok, Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
Sorry again but can't make it work. Can you explain me this formula so that I
can adapt it to my sheets? "Bob Phillips" escreveu: =INDEX(Sheet2!$A$1:$A$20,SUMPRODUCT(--(ISNUMBER(SEARCH(Sheet1!B1,Sheet2!$B$1 :$B$20))),ROW(Sheet2!$B$1:$B$20))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... GROUP1 is in one cell; the others are together in another cell. "Bob Phillips" escreveu: Is the text such as GROUP1 VS;VV;VJ;VL all in one cell, or many cells? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Ok, Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas!
The SUMPRODUCT gets the row number of the variable in B1 from the list on
sheet2 column B, and passes that to the INDEX function to get the value from sheet2 column A -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Sorry again but can't make it work. Can you explain me this formula so that I can adapt it to my sheets? "Bob Phillips" escreveu: =INDEX(Sheet2!$A$1:$A$20,SUMPRODUCT(--(ISNUMBER(SEARCH(Sheet1!B1,Sheet2!$B$1 :$B$20))),ROW(Sheet2!$B$1:$B$20))) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... GROUP1 is in one cell; the others are together in another cell. "Bob Phillips" escreveu: Is the text such as GROUP1 VS;VV;VJ;VL all in one cell, or many cells? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Barbara" wrote in message ... Ok, Let's see if my english will be fine enough... (LOL) The groups will be defined perhaps in a new sheet: Ex: GROUP RESULT ---------------------------------- GROUP1 VS;VV;VJ;VL GROUP2 VR;VX;VI GROUP3 VA;VN GROUP4 VO;VZ So in my main sheet, when in column B Excel finds VL, it should return the value GROUP1 in column A. Hope that I was clear. Thanks, Barbara "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
