Announcement

Collapse
No announcement yet.

best way to get ADP into draft spreasheet?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • best way to get ADP into draft spreasheet?

    I'm searching for the best way to get ADP as a column into my master spreadsheet. Ideally, I'd love it to be a column included in the export but without that, what have other people used to easily get that data in?

    I'm not an Excel master but what I've been doing is copying ADP from another source, and trying to line it up by sorting by alphabetical on both data blocks. This is a bit of a pain as there are never the exact same entries so it requires some manual cleanup.

    Excel experts out there have an easier way they can point me towards?

  • #2
    Yes, use VLOOKUPs. You can search Excel help, or read this HQ article:

    http://www.baseballhq.com/using-excel-vlookups
    MiLBAnalysis.com / @NickRichardsHQ

    Comment


    • #3
      perfect. Thanks Nick!

      Comment

      Working...
      X