gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
Hello,
Count Dupes only once. If its duplicated 2 or 3 times, then count 1.
Dupes in V:V. Insert formula U214.
Thank you.
Count Dupes only once. If its duplicated 2 or 3 times, then count 1.
Dupes in V:V. Insert formula U214.
Thank you.
Wagers.xlsm | ||||||
---|---|---|---|---|---|---|
U | V | W | X | |||
213 | Dupes | Team | W/L | SPRD | ||
214 | MIL | W | -9 | |||
215 | TOR | W | -12 | |||
216 | LAC | L | -9 | |||
217 | LAC | L | -8 | |||
218 | MIL | W | -8.5 | |||
219 | PHX | L | -8 | |||
220 | UTA | W | -8 | |||
221 | MIL | W | -10.5 | |||
222 | PHX | W | -8 | |||
223 | SAC | L | -8 | |||
224 | BOS | L | -8 | |||
225 | GS | W | -8.5 | |||
226 | MIL | W | -10 | |||
227 | BRK | W | -8 | |||
228 | MIL | W | -10.5 | |||
229 | PHX | L | -10 | |||
230 | UTA | W | -9 | |||
231 | BRK | W | -8.5 | |||
232 | LAC | L | -8.5 | |||
233 | MIL | L | -9 | |||
NBA |
Cell Formulas | ||
---|---|---|
Range | Formula | |
V214:V233 | V214 | =INDEX($H$2:$H$10009,AGGREGATE(15,6,ROW($H$2:$H$10009)-ROW($H$1)/($J$2:$J$10009<=-8),ROW()-ROW($V$213))) |
W214:W233 | W214 | =INDEX($A$2:$A$10009,AGGREGATE(15,6,ROW($H$2:$H$10009)-ROW($H$1)/($J$2:$J$10009<=-8),ROW()-ROW($W$213))) |
X214:X233 | X214 | =INDEX($J$2:$J$10009,AGGREGATE(15,6,ROW($H$2:$H$10009)-ROW($H$1)/($J$2:$J$10009<=-8),ROW()-ROW($X$213))) |