Extract unique items based on criteria

Hello everyone
I have a validation list of unique items of column A in cell F9
I need to extact the unique items for specific value (say 50 in F9) and the results to be in Column G

Here's the attachment to illustrate the desired results as example

Hi.

Enter this array formula** in e.g. G6, used to determine the expected number of returns:

=SUM(IF(FREQUENCY(IF(A$2:A$41=F$9,B$2:B$41),B$2:B$41),1))

Then enter this array formula** in G9:

=IF(ROWS($1:1)>G$6,"",SMALL(IF(FREQUENCY(IF(A$2:A$41=F$9,B$2:B$41),B$2:B$41),B$2:B$41),ROWS($1:1)))

and copy down until you start to get blanks for the results.

Regards


**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Thank you very much for this great formula and solution

Originally Posted by YasserKhalil

Thank you very much for this great formula and solution

You're welcome!