how to extract unique itesm based on date

[m9vukyem]

please find attchment

 

[herofox]

Hello ... You can Use This Function

=IFERROR(INDEX($A$2:$A$290,AGGREGATE(15,6,ROW($A$1:$A$313)/(MATCH($A$2:$A$290&$B$2:$B$290,$A$2:$A$290&$B$2:$B$290,0)=ROW($A$1:$A$313)),ROWS($1:1))),"")

 

[m9vukyem]

Thank you can please explain why you use 313 rows instead of 290

 

[herofox]

thanks ,,By chance, there is nothing specific that you can change if you want

 

[AlanSidman]

You can use the remove duplicates function in Power Query. Here is the Mcode as a result of that action

let

    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

    #"Changed Type" = Table.TransformColumnTypes(Source,{{"BATCH", Int64.Type}, {"Txn Date", type date}}),

    #"Removed Duplicates" = Table.Distinct(#"Changed Type")

in

    #"Removed Duplicates"

 

[Peter Bartholomew]

As a 365 user

= UNIQUE(data)

 

[bosco_yip]

Or,

Copied A1:B29 >> paste to E1:F29 >> press "Remove Duplicates" >> OK >> OK

 

[GraH - Guido]

Bosco offering a non formula solution? This forum keeps surprising me

 

[Peter Bartholomew]

It always happens; just when you think you have everyone stereotyped, someone steps out of line!

 

[GraH - Guido]

Another ways is to use advanced filter. But seems not as solid as removing duplicates after having copied the range.
EDIT:
Need to define the criteria range correctly (I kind of forgot about it).
sorry, wrong picture attached