Extracting data from one page to another under Multiple conditions Without repetition

[Hany ali]

Dear All ,Please I Want to get the date drom Data sheet to Total Sheet by Multiple Condition Without repetition as you sea in Photo by date start to end & Tour Name with Supplier Name
thanks Alot

 

[herofox]

hi ... You can get what you want with this formula

=IFERROR(INDEX(Data!$D$2:$D$325,AGGREGATE(15,6,ROW($A$1:$A$325)/(MATCH(Data!$D$2:$D$325&Data!$E$2:$E$325&Data!$K$2:$K$325,Data!$D$2:$D$325&Data!$E$2:$E$325&Data!$K$2:$K$325,0)=ROW($A$1:$A$325)),ROWS($1:1))),"")

and this one to get total for any fingers

=SUMIFS(Data!$A:$A,Data!$F:$F,"<="&$G2,Data!$F:$F,">="&$F2,Data!$D:$D,$D2,Data!$K:$K,$E2)

 

[Hany ali]

thanks alot for you mr Herofox thats what i want exactly.... but is possible by VBA Code