gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 696
- Office Version
- 2019
- Platform
- Windows
Hello,
Looking to match cell values in a range (shown below) if value matches in an ODD row in another worksheet (2nd range below)
CLE should be the only matching value. D:D has to be greater than 55%. The percentage value will change daily.
Match looking at ODD rows.
Looking to match cell values in a range (shown below) if value matches in an ODD row in another worksheet (2nd range below)
CLE should be the only matching value. D:D has to be greater than 55%. The percentage value will change daily.
NBA.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Home | ATS @ HOME | ||||||
2 | < 55% | Team | ATS Record | Cover % | MOV | ATS +/- | ||
3 | ORL | Orlando | 9-2-1 | 0.818 | 10.8 | 5.8 | ||
4 | MEM | Memphis | 12-4-0 | 0.75 | 13.3 | 8.3 | ||
5 | CLE | Cleveland | 11-4-0 | 0.733 | 12.9 | 3.7 | ||
6 | TOR | Toronto | 10-4-1 | 0.714 | -3.9 | 1.7 | ||
7 | HOU | Houston | 10-4-0 | 0.714 | 11.1 | 5.1 | ||
8 | LAC | LA Clippers | 10-6-0 | 0.625 | 4.1 | 3.6 | ||
9 | POR | Portland | 8-5-0 | 0.615 | -7.5 | -1.6 | ||
10 | GSW | Golden State | 7-5-0 | 0.583 | 2.6 | -0.1 | ||
11 | LAL | LA Lakers | 7-5-0 | 0.583 | 3.3 | -0.6 | ||
12 | DAL | Dallas | 7-5-0 | 0.583 | 8.6 | 2.1 | ||
13 | OKC | Okla City | 7-5-0 | 0.583 | 12.4 | 2.7 | ||
14 | NYK | New York | 6-5-1 | 0.546 | 11.3 | 2.7 | ||
15 | NOP | New Orleans | 7-6-0 | 0.539 | -4.8 | -1.5 | ||
16 | CHA | Charlotte | 8-7-0 | 0.533 | -3.7 | 1.8 | ||
17 | BRK | Brooklyn | 6-6-0 | 0.5 | -6.3 | -1.6 | ||
18 | MIA | Miami | 6-6-0 | 0.5 | 6.5 | 2.8 | ||
ATS Trends |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B3:F32 | Expression | =AND(ISODD(ROW(Favs!$A3)),MATCH($A3,Favs!$A$3:$A$33,0),$D3>=0.55) | text | NO |
Match looking at ODD rows.