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"
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"
Last edited by marreco; 11-06-2012 at 05:31 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
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
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
Hi.
Moo the Dog its function coincided with the criteria, it was perfect!
Thanks to the two who helped me!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks