I want to eliminate rows where the result is "FALSE", and drop-down menu with unique only

As per the attached spreadsheet, I am trying to construct a graph of price performance of different products over time.

The user should enter the name of the animal in the drop-down menu in cell F1 (how do I make only 1 - unique of each animal?)

I would like the result to display as per the area highlighted in yellow. My formula produces many "FALSE" results, so my graph does not work.

Clear both E4 & F4 & out this in E4 only

Formula:

Please Login or Register  to view this content.

Originally Posted by Fluff13

Clear both E4 & F4 & out this in E4 only

Formula:

Please Login or Register  to view this content.

Thank you @Fluff13. This works. I don't know why, but I am about to study the function =Choosecols, which I have not used before.

Forgot about the drop down, in a cell (say J2) put

Formula:

Please Login or Register  to view this content.

and in the drop-down use =J2#

Originally Posted by Fluff13

Forgot about the drop down, in a cell (say J2) put

Formula:

Please Login or Register  to view this content.

and in the drop-down use =J2#

Got it. Thanks. I will now adapt to my much larger spreadsheet.

Glad to help & thanks for the feedback.