-
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,612
- 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
Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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
