I have a consolidated spreadsheet with all the Job Numbers and Employees, and have broken this spreadsheet out into separate spreadsheets based on Job Number. Currently, I have all employees assigned to the Job Number in Column B, and the week end in column C--F. Eventually, i would like to replace the hard coded list of employees with a query, but for the time being, I have a separate column with the following equation:
=IFERROR((VLOOKUP($A$1, 'Cameron-IS'!B1:F101, 5, FALSE)), "")
where: A1 contains the JN search string
Cameron-IS is the consolidated Job Numbers
Cameron-IS column B is the Job Number column
Cameron-IS column F is the employee name
5 returns the employee name
I drag this down until i get blanks, and then manually use the "data-->remove duplicates" to see the list of employees charging to this Job number, with out all the duplicates.
Is there a way to do this via formula - eg. an if statement that says if the name above matches what this one returned, go to the next row, etc?
Thanks!
You mean remove the duplicates via formula? In that case, you will need to have another helper column, put in a formula,then filter for the dups and delete them.Is there a way to do this via formula - eg. an if statement that says if the name above matches what this one returned, go to the next row, etc?
You can do this simply through macro by replicating what the "Data-> Remove Duplicates" does.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks