Expiry date Formula & AutoFilter VBA

[nasoor123]

Dear All,

In the attached file, can someone help me with the following:

1-why the formulas shaded in pink are not working?

2-why the formulas shaded in yellow are working, while the ones shaded in green are not working. Also, if I put these parentheses {}, like in the yellow shaded formulas, the pink formulas turns into a text.

3-Can you pls write a small VBA for me that auto filters to me any cell I want in the database in the attached file? This VBA should do the same thing as the AutoFilter function in Ecxel.

Many thanks for your help and support and I look forward to receiving your reply

Nasser
Dubai

[contaminated]

In F23 should've been

=MIN(IF((D23=D5:D18)*(E23=E5:E18),G5:G18))

In F23 should've been

=MAX(IF((D23=D5:D18)*(E23=E5:E18),G5:G18))

In F27 and G27 formulas work properly., just confirm them with <Ctrl>+<Shift>+<Enter>[/

ALL YOUR FORMULAS NEEDS TO BE CONFIRMED WITH <Ctrl>+<Shift>+<Enter>

[nasoor123]

Many thanks for your help. It is now working.
What about the AuotoFilter function through VBA. Can you pls help me with that?
Many thanks again.
Nasser