Copy Column To New Sheet Based On Conditions

  • I have a sheet that contains department numbers and individual users. There may be multiple users in one department number. I would like to transfer those department numbers to a new sheet for price calculation per department. How can I copy the department numbers, but only have one entry per department number?

    Ex. Sheet 1
    Dept Name
    0014 Sue Brown
    0014 Joe Smith
    0015 Jane Smith

    Ex. Sheet 2
    Dept Cost
    0014 25.15
    0015 20.00

  • Re: Copy Column To New Sheet Based On Conditions


    Create a Pivot Table to get a list of Departments, then use VLOOKUP with the Pivot Items as the lookup values and the data in Sheet as the lookup range.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!