-
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
Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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
