Filter results by formulas according to 1 or 2 or 3 criteria

[fleyd]

Hi

I have the need to save some data, but i want a easy way by formulas that will filter the results according to 1 or 2 or 3 criteria, like the file attached. Is this possible?

The results should by the name of the movie, according i choose the director, the year or both, or all 3 criteria.

Can anyone help? Thanks in advance.


PS - Sorry if i cant answer to any questions fast, but i will do it once i can/have time.

[sandy666]

Maybe it will help you
Choose appropriate D-function and adapt formula from the range below 17 row.

Note for MOD: I don't want to describe ALL D-functions and formula
this is an example and not reflect OP's needs

Please Login or Register  to view this content.

[Glenn Kennedy]

One way, using this array formula in P2, copied across and down:

Please Login or Register  to view this content.

[shukla.ankur281190]

Try

I8

Please Login or Register  to view this content.

Check the attached file.

[fleyd]

Sorry for the late reply. Thanks to everyone who helped, itīs perfect.

Thanks!!

[sandy666]

Thanks for the feedback and mark thread solved