gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 684
- Office Version
- 2019
- Platform
- Windows
Hello,
If any cell in a range1 is equal to any cell in range2, then insert comment to range1 cell.
Thank you.
If any cell in a range1 is equal to any cell in range2, then insert comment to range1 cell.
Thank you.
NFL.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Range1 | |||||
2 | IND | |||||
3 | DEN | |||||
4 | NYG | |||||
5 | GB | Range2 | ||||
6 | PIT | KC | ||||
7 | BUF | SF | ||||
8 | LAC | BUF | ||||
9 | CLE | PHI | ||||
10 | HOU | |||||
11 | JAX | |||||
12 | CHI | |||||
13 | TB | |||||
14 | TEN | |||||
15 | WAS | |||||
16 | SF | |||||
17 | CAR | |||||
18 | PHI | |||||
19 | ARZ | |||||
20 | DAL | |||||
21 | LAR | |||||
22 | CIN | |||||
23 | BAL | |||||
24 | LVR | |||||
25 | KC | |||||
Test2 |