Filter Array Based On Two Criteria

[Maconi]

I'm attempting to filter a column based on two different criteria. One of the criteria is static (matching a single number in a specific column) and the other criteria is dynamic (matching an array of numbers to a column).

I can pull the criteria separately, but when I attempt to combine them to filter the results further I get an error.

Pull All Of ID 43079's Units:

=FILTER(C:C,B:B=43079)

Pull Last 20 Unique Dates for 43079:

=INDEX(UNIQUE(FILTER(A:A,B:B=43079)),SEQUENCE(20))

Filter 43079's Units By Last 20 Unique Dates (broken):

=FILTER(C:C,(B:B=43079)*(INDEX(UNIQUE(FILTER(A:A,B:B=43079)),SEQUENCE(20))))

Any assistance is appreciated. I'm sure it's a simple fix, I just can't wrap my head around it.

 

[SunnyAlv]

Like this?

=CHOOSEROWS(UNIQUE(CHOOSECOLS(FILTER(A:C,B:B=43079),1,3)),SEQUENCE(20))