VN
Board Regular
- Joined
- Aug 19, 2003
- Messages
- 83
How can I build the description as below sample ?
I would like to make a description by using concatenate cell by cell as sample. Condition of Concatenation -> New Description have to refer the numbers that is store at the top in each column.
I use this formula now :-
How can I build the description in column B as below sample ?
Thank you.
I would like to make a description by using concatenate cell by cell as sample. Condition of Concatenation -> New Description have to refer the numbers that is store at the top in each column.
I use this formula now :-
Code:
=CONCATENATE(INDEX($D5:$N5,1,MATCH(1,$D$2:$N$2,0))," ; ",INDEX($D5:$N5,1,MATCH(2,$D$2:$N$2,0))," ; ",INDEX($D5:$N5,1,MATCH(3,$D$2:$N$2,0))," ; ",INDEX($D5:$N5,1,MATCH(4,$D$2:$N$2,0)))How can I build the description in column B as below sample ?
Thank you.
| 0Test.xls | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | |||
| 1 | |||||||||||||||
| 2 | Selectorderby==> | 1 | 2 | 4 | 3 | ||||||||||
| 3 | |||||||||||||||
| 4 | Description | Header_1 | Header_2 | Header_3 | Header_4 | Header_5 | Header_6 | Header_7 | Header_8 | Header_9 | Header_10 | Header_11 | |||
| 5 | A;W;W;H | A | I | W | F | H | W | Q | D | Q | X | V | |||
| 6 | H | V | T | Z | ] | ^ | [ | [ | T | R | O | ||||
| 7 | A | C | Z | I | L | ^ | C | U | Q | D | N | ||||
| 8 | H | V | O | O | B | R | V | E | J | W | K | ||||
| 9 | U | ^ | K | H | ^ | ] | R | M | D | E | E | ||||
Sheet2 | |||||||||||||||
