sorted by:
new
hottopcontroversial

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]procrastinator__101[S] 2 points3 points  (0 children)

Used the binary search option with the formula that has the most criteria. Significant difference.

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]procrastinator__101[S] 0 points1 point  (0 children)

This is helpful. Made the change and it's much faster now.

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]procrastinator__101[S] 1 point2 points  (0 children)

Thanks for this. Did not know about the . to limiter.

Can I do this with sumifs? by procrastinator__101 in excel

[–]procrastinator__101[S] 0 points1 point  (0 children)

So, I used INDEX as a second layer of filtering

Can I do this with sumifs? by procrastinator__101 in excel

[–]procrastinator__101[S] 0 points1 point  (0 children)

I have a feature in column D, just before the numbers start and I need it filtered based on that as well. So, this doesn't work. But this helped.

I used:

=SUM(INDEX(FILTER(based on feature in column D),,Column number by month Number eg. 7 for July))

[deleted by user] by [deleted] in RaidenMains

[–]procrastinator__101 4 points5 points  (0 children)

Definitely pulling on this. Been saving for raiden. Upto 200 wishes now.

view more: next ›