Drag down same value at multiple points in a column
Results 1 to 2 of 2

Thread: Drag down same value at multiple points in a column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Drag down same value at multiple points in a column

    Hello,

    This is what my file looks like:




    Date Inv# Dept Vendor Ref# Check# Payment Date Amt Paid Inv Amt Manager Name
    11/01/2014 300699 IT COOL33 11111 11/10/2014 $2,000.00 $2,528.00 SMITH BILL
    11111 11/10/2014 $500.00 SMITH BILL
    11111 11/10/2014 $20.00 SMITH BILL
    11111 11/10/2014 $5.00 SMITH BILL
    11111 11/10/2014 $3.00 SMITH BILL
    355999 HR AIR44 22222 11/10/2014 $600.00 $1,025.00 ATKINS WADE
    22222 11/10/2014 $300.00 ATKINS WADE
    22222 11/10/2014 $100.00 ATKINS WADE
    22222 11/10/2014 $20.00 ATKINS WADE
    22222 11/10/2014 $5.00 ATKINS WADE



    What I want to do is drag Columns B, C, D, and H (Inv#, Dept, Vendor Ref#, and Inv Amt) such that I can drag-down the same value until I reach the next value and then duplicate that value down. I would like to automate that process, since I'm dealing with tens of thousands of rows.

    So, if I did that with Column B, for example, it would now look like this:





    Date Inv# Dept Vendor Ref# Check# Payment Date Amt Paid Inv Amt Manager Name
    11/01/2014 300699 IT COOL33 11111 11/10/2014 $2,000.00 $2,528.00 SMITH BILL
    300699 11111 11/10/2014 $500.00 SMITH BILL
    300699 11111 11/10/2014 $20.00 SMITH BILL
    300699 11111 11/10/2014 $5.00 SMITH BILL
    300699 11111 11/10/2014 $3.00 SMITH BILL
    355999 HR AIR44 22222 11/10/2014 $600.00 $1,025.00 ATKINS WADE
    355999 22222 11/10/2014 $300.00 ATKINS WADE
    355999 22222 11/10/2014 $100.00 ATKINS WADE
    355999 22222 11/10/2014 $20.00 ATKINS WADE
    355999 22222 11/10/2014 $5.00 ATKINS WADE


    As noted, this will be done for tens of thousands of rows. If I were to do it manually, it would take lots of time and the potential for error is high.

    There are multiple points were the value changes in a column and a new value needs to be dragged down until the next value. Columns "check#", "payment date", and "manager name" already have been duplicated.

    Are there any shortcuts for doing this?

    Let me know if I need to clarify anything.

    Thanks!

  2. #2
    Board Regular
    Join Date
    Dec 2009
    Location
    Yorkshire, UK
    Posts
    87
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Drag down same value at multiple points in a column

    You could enter this formula into cell J2 and copy down across to column L and down the to the final row of data:

    =IF($E2=$E1,J1,B2)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •