Function does not extract values ​​correctly

[marreco]

Hi.

I need to understand why my formula is extracting wrong values ​​that I need to extract bseado on 2 criteria

The criteria are "I2" and values ​​greater than zero in column "E"

[Stewpid]

Marreco,

Not sure why your formula isn't working correctly, but it seems way too advanced for what you're trying to do. See the attached with solution formulas that don't require you to use an array formula.

Hope this helps.

Extrac_Incorrect.xlsx

[Moo the Dog]

See my edited sheet attached. I made a few changes:
- I inserted a helper column in column A. Formula in A2 is: =SUM(A1,AND(D2=$J$2,F2>$K$2)) then filled down.
- Changed the value in K2 to just 0, instead of >0 since the formula I use needs it that way
- Changed the formula in cell K3 to: =MAX(A2:A15)
- Changed the array formula in I4 to: =IF(ROWS(I$4:I4)>$K$3,"",VLOOKUP(ROWS(I$4:I4),$A$2:$F$15,COLUMNS($I4:I4)+COLUMNS($I4:I4),0)) then filled right and down.

Works like a charm. Let me know if you have any questions.

I also easily accomplished what you want with an Advanced Filter, however, Filters don't automatically update, so code works better for instant refresh of results.

- Moo

[marreco]

Hi.
Moo the Dog its function coincided with the criteria, it was perfect!

Thanks to the two who helped me!