Find most recent key from table

[Mrak123]

I currently have this formula:

ANY(SELECT(Backup[Batch Number],([Barcode]=(MAXROW("Backup","_ROWNUMBER")))))

This returns me the [batch number] that correlates with the most recent [Barcode] in the Backup table.

I need this formula to return the [Batch Number] that correlates with the most recent [Barcode] that also has the same USEREMAIL() in the [Listed User Email] column.

Something like this, but this is obviously wrong:

ANY(SELECT(Backup[Batch Number],([Barcode]=AND((MAXROW("Backup","_ROWNUMBER")),([Listed User Email]=USEREMAIL()))))

Any help would be greatly appreciated