Possible Index/Match and/or Duplicate/Ignore??

Hello,

I have a payroll workbook that utilizes Vlookup to pull employee pay rates, insurance deductions, project information, expense data, etc. Employees can work on multiple projects w/in a pay period and the spreadsheet reflects this with a different row for each project. See below:


Excel1.jpg


For accounting purposes, we will filter by Employee and then sum the totals. However, the insurance deduction only needs to be counted once in the totals row. I cannot figure out how if that's possible.

The value (insurance deduction) pulls from another worksheet and the current formula is =VLOOKUP(B8,EmployeeRates,4,FALSE),"")

Welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Well. This took about 30 seconds to create. Is this what you need? If not, can you explain on this sheet??

=IF(COUNTIF($A$2:A2,A2)>1,"",VLOOKUP(A2,I:J,2,FALSE))

Wow! I do believe that worked. Now what can I add to get rid of the #N/A in my empty cells AND the totals row? I am so impressed.

=IFERROR (myformula,"")

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Hmmmmmm, okay it took the formula but now it's doing something strange to the numbers. Gonna investigate and see how best to show the issue.