-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copy string from one row/cell to rows
- Thread starter milanoke
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,768
- Office Version
- 365
- Platform
- Windows
How about
| Fluff.xlsm | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | ||||||||||||
| 2 | ||||||||||||
| 3 | number= | ,id= | 33 | ,adress=" | "; | |||||||
| 4 | ||||||||||||
| 5 | 3216 | 10.177.252.227 | number=3216,id=33,adress="10.177.252.227"; | |||||||||
| 6 | 5463 | 10.177.252.228 | number=5463,id=33,adress="10.177.252.228"; | |||||||||
| 7 | 2156 | 10.177.252.229 | number=2156,id=33,adress="10.177.252.229"; | |||||||||
| 8 | 2346 | 10.177.252.230 | number=2346,id=33,adress="10.177.252.230"; | |||||||||
| 9 | 4499 | 10.177.252.231 | number=4499,id=33,adress="10.177.252.231"; | |||||||||
| 10 | ||||||||||||
Data | ||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| J5:J9 | J5 | =LET(c,FILTER(C5:C2000,C5:C2000<>""),g,FILTER(G5:G2000,G5:G2000<>""),BYROW(CHOOSE(SEQUENCE(,7),B3,c,D3,E3,F3,g,H3),LAMBDA(br,CONCAT(br)))) |
| Dynamic array formulas. | ||
Upvote
0
Solution
Excel Facts
Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Fluff, it works
thank you very much !
Upvote
0
is it possible to automatically change background color of new cells in row J?
Upvote
0
found solution
thanks anyway.
Upvote
0
Similar threads
- Solved
