• smutpeddlers

    Anyone use excel to build lineups and know how to check if their are duplicates with our doing it manually by row?

  • slcseas

    Conditional Formatting > Highlight Cells Rules > Duplicate Values.

  • smutpeddlers

    @slcseas is that able to show if there are duplicate lines, not just duplicate value, in a set of let’s say 150 lineups…….

  • bhodgman

    I don’t play FD, but if you use DK, they assign a unique number to each player for each contest. You can thus use vlookup to isolate those specific numbers, and then use the sum feature for all players in that lineup (by row).. then sort that column by the your sum value to help identify any duplicates).

    (and since you can only play one QB and one DST, you can sort by those two criteria first, to make it even easier).

    I’ve found VLOOKUP an ABSURDLY useful feature for lineup building… same with COUNTIF to identify my exposures…

  • X Unread Thread
  • X Thread with New Replies*
  • *Jumps to your first unread reply

Subforum Index is the home of the daily fantasy sports community. Our content, rankings, member blogs, promotions and forum discussion all cater to the players that like to create a new fantasy team every day of the week.

If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537) (IL). Gambling problem? Call 1-800-Gambler (NJ/WV/PA), 1-800-9-WITH-IT (IN), 1-800-522-4700 (CO) or 1-800-BETS OFF (IA). 21+. NJ/PA/WV/IN/IA/CO/IL only.