-
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,751
- 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
Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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
