• 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

Use our links to sign up and deposit on sites listed in this thread to get these bonuses:

  • FanDuel

    Get 1-month of RotoGrinders Premium for FREE (a ~$40value) by signing up through one of our links!

    Learn More
  • DraftKings

    Sign up for DraftKings using a RotoGrinders link & receive our DraftKings Premium content FREE for 1 month. That’s a ~$40 value! No DraftKings promo code necessary!

    Learn More
  • FantasyDraft

    FantasyDraft strives to put players first, with a mission to “provide a fun and fair experience for all.” To this end, the site has a well-built, easy-to-use interface and a the first of its kind in offering “Rake-Free” fantasy contests.

    Learn More

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. Our goal is to help all of our members make more money playing daily fantasy sports!

Bet with your head, not over it!
Gambling Problem? Call 1-800-Gambler