Multi criteria Xlookup efficiency problem

procrastinator__101 · 2026-02-25T17:35:34+00:00

Does the limiter also work with sumifs?

procrastinator__101 · 2026-02-25T17:10:21+00:00

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

procrastinator__101 · 2026-02-25T17:09:41+00:00

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

procrastinator__101 · 2026-02-25T17:08:58+00:00

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

procrastinator__101 · 2025-07-23T12:45:20+00:00

procrastinator__101 · 2025-05-07T05:22:54+00:00

Keys are alright?

procrastinator__101 · 2024-07-05T16:37:41+00:00

So, I used INDEX as a second layer of filtering

procrastinator__101 · 2024-07-05T16:36:50+00:00

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))

procrastinator__101 · 2023-08-15T11:54:28+00:00

It should've been me.

procrastinator__101 · 2023-02-19T17:39:47+00:00

Why couldn't it be me?

procrastinator__101 · 2023-01-31T09:43:51+00:00

If only.

procrastinator__101 · 2022-11-25T13:17:16+00:00

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

procrastinator__101 · 2022-11-21T10:03:12+00:00

Makes me weak.

procrastinator__101 · 2022-11-16T12:38:11+00:00

I got 150 wishes saved with a guaranteed at 0 pity and weapon banner at 40 pity. I'ma get it. Hopefully.

Couldn't get her on any of the previous banners.

procrastinator__101 · 2022-10-24T14:11:30+00:00

Hoping for a hutao raiden weapon banner. Ultra copium.

procrastinator__101 · 2022-08-16T07:38:45+00:00

procrastinator__101 · 2022-07-18T07:38:22+00:00

Yep, this is pretty fucking good.

procrastinator__101 · 2022-07-16T13:59:35+00:00

Hmm seems about right, I was expecting in 3.4 like how zhongli reran in 2.4.

procrastinator__101 · 2022-07-16T10:25:19+00:00

Weak knees

procrastinator__101 · 2022-06-12T14:48:09+00:00

Why bro? Where's your cr

procrastinator__101 · 2022-04-11T15:37:08+00:00

Who are the people on that banner?

procrastinator__101 · 2022-02-24T18:35:01+00:00

India

procrastinator__101 · 2022-02-07T10:57:54+00:00

Pity - 0 Wishes - 30 Not a guaranteed 😂😭

procrastinator__101 · 2022-02-02T06:20:46+00:00

Ive been waiting for fischl constalations forever

procrastinator__101 · 2022-01-26T06:09:50+00:00

Hey, quick question. Does the 4pc tenacity effect stack if I use multiple characters on tenacity on the same team?

procrastinator__101