gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
Hello,
Insert Column when cell changes value in Row 1:1. There are many columns (QN:QXY)
Thank you.
Insert Column when cell changes value in Row 1:1. There are many columns (QN:QXY)
Thank you.
| NBA.xlsm | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| QL | QM | QN | QO | QP | QR | QS | QT | ||||
| 1 | Sat, Dec 11, 2021 | Sun, Dec 12, 2021 | Sun, Dec 12, 2021 | Sun, Dec 12, 2021 | Sun, Dec 12, 2021 | Sun, Dec 12, 2021 | Sun, Dec 12, 2021 | Mon, Dec 13, 2021 | |||
| 2 | Denver Nuggets | Milwaukee Bucks | Brooklyn Nets | Dallas Mavericks | New Orleans Pelicans | Minnesota Timberwolves | Orlando Magic | Miami Heat | |||
| 3 | San Antonio Spurs | New York Knicks | Detroit Pistons | Oklahoma City Thunder | San Antonio Spurs | Portland Trail Blazers | Los Angeles Lakers | Cleveland Cavaliers | |||
| 4 | DEN | MIL | BKN | DAL | NO | MIN | ORL | MIA | |||
| 5 | SAN | NYK | DET | OKC | SAN | POR | LAL | CLE | |||
2021-2022 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| QL4,QN4:QT4 | QN4 | =VLOOKUP(QN$2,$B$2:$D$79,3,0) |
| QL5,QN5:QT5 | QN5 | =VLOOKUP(QN$3,$C$2:$E$79,3,0) |
