Select Random Sample from Prior Day with Specific Criteria

[SoldOnTheRoad]

I apologize for a duplicate/similar post, but my prior post was not answered correctly/sufficiently.

I have a large data set, with 22 employees that tracks their daily transactions. I want to obtain a random sampling of 1 transaction per person from the prior day.

Column A = Transaction Number (unique identifier)
Column B = Date of Transaction
Column C = Employee Name (all unique)

On a new sheet, I'd list each of the employees names and want ONE transaction number to appear next to their name.

I'm thinking I'd add a new column D for =rand() to assign each number a unique value, but I'm struggling with a formula to pull one transaction, per person, from the prior day. I'm thinking a combination of VLOOKUP, IF, and MAX; but I can't seem to get it right.

 

[Rijnsent]

Hi SoldOnTheRoad,

from this link: https://www.extendoffice.com/documents/excel/3212-excel-random-selection-with-criteria.html

=INDIRECT("A"&LARGE(IF($B$2:$B$25=$F$1,IF($C$2:$C$25=$G$1,ROW($A$2:$A$25),0),0), RANDBETWEEN(1,COUNTIFS(B2:B25,F1,C2:C25,G1))))

The conditions in this example are in G1 and F1, comparing it with columns C and B respectively.

Cheers,

Koen