duplicate expense

Hi
Is it possible please to help to show exceptions where we have the following condition - who are charging the same expense type, as follows

a) different staff (column a)
b) charge the same amount (column H) -
c) same currency (column I)
c)for the same expense type (column F)
d) for the same travel period (column D and E)

Can the exception (all data in the rows) be copied to new tabs, or I can do this manually.'Here we should have 2 tabs - one for flight exception and 1 for the meals.

Hi,

I'm using AGGREGATE (Excel 2010 or more recent version) to simulate a kind of filter.

In A2 of first sheet (meal) to be copied across

=IFERROR(INDEX(Sheet1!A$1:A$100,AGGREGATE(15,6,ROW($1:$100)/(COUNTIFS(Sheet1!$H$1:$H$100,Sheet1!$H$1:$H$100,Sheet1!$I$1:$I$100,Sheet1!$I$1:$I$100,Sheet1!$D$1:$D$100,Sheet1!$D$1:$D$100,Sheet1!$E$1:$E$100,Sheet1!$E$1:$E$100,Sheet1!$F$1:$F$100,"Meal")>1),ROWS($A$1:$A1))),"")

Same formula in the second sheet (taxi)

=IFERROR(INDEX(Sheet1!A$1:A$100,AGGREGATE(15,6,ROW($1:$100)/(COUNTIFS(Sheet1!$H$1:$H$100,Sheet1!$H$1:$H$100,Sheet1!$I$1:$I$100,Sheet1!$I$1:$I$100,Sheet1!$D$1:$D$100,Sheet1!$D$1:$D$100,Sheet1!$E$1:$E$100,Sheet1!$E$1:$E$100,Sheet1!$F$1:$F$100,"Taxi")>1),ROWS($A$1:$A1))),"")

Please refer to the attachment.

I hope it could be a first help.