Excel 2007 : Looking Up values from another sheet, removing duplicates

[Christy :)]

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!

[arlu1201]

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 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.
You can do this simply through macro by replicating what the "Data-> Remove Duplicates" does.