Duplicate items

Navya08

I have an expense sheet , and i need to check duplicate expenses from all employees

1) i need to identify same amount, same transaction date,same employee id but different payment method personal credit card or cbcp.

2) same amount, same employee id but diff payment method .

can someone help me how can  i get through this and highlight the duplicates with yellow

Untitled spreadsheet.xlsx

davidskaife

Hi @Navya08 

You could try this as one way of doing it; using the Summerize tool group by the required fields (Amount, Transaction Date, Employee ID) and count Employee ID. Then create a Duplicate field using the Formula tool, where if Count is > 1 then its a duplicate, otherwise its ok. Finally join it back onto the original data using the same fields you grouped by.

Duplicates.yxzp