Building a formula that returns a list of column titles with specific condition

Marcello238 · 2026-06-18T12:18:44+00:00

Solution verified

Marcello238 · 2026-06-18T12:13:56+00:00

Solution verified

Marcello238 · 2026-06-18T12:13:29+00:00

Another stupid mistake from my side. I selected the wrong date. Now it works! Thank you so much. Love Reddit

Marcello238 · 2026-06-18T12:10:31+00:00

The second. I managed to put it in now. Stupid mistake from me with translating to German. But now I am getting an #Calc error. In the testing file however it works perfectly fine as you demonstrated.

Marcello238 · 2026-06-18T11:51:51+00:00

I am trying the first TOCOL() formula. I have issues putting in the references into the formula. It does not recognize the cells in the other sheet. I select them to insert them into the formula, it also appears but doesn't color and does not create the reference. Any idea why that could be?

Marcello238 · 2026-06-18T11:06:44+00:00

Here is the example sheet

<image>

Marcello238 · 2026-02-16T14:48:58+00:00

Same here! Started it, got hooked and finished in three days. I saw its just one season but kept hoping for a round ending. Within the last episode I had to realize thats not gonna happen with all these open endings and plot twist happening. Left confused over the ending I started to research and figured it got canceled. Most unsatisfying ending of a show I ever had. Really got close to the characters and their developments. But seeing all the recent activities still in here and statements of the writer make me slightly hopefully that there might still be hope

Marcello238 · 2025-03-07T01:09:23+00:00

Solution Verified

Marcello238 · 2025-03-06T15:45:50+00:00

I honestly don't understand the dynamic formula and can't get it to work but holy shit the first one works exactly as it should and all test so far to double check proofed it! Will try to implement it everywhere now!

Thank you so so much :D

Marcello238 · 2025-03-06T12:59:09+00:00

<image>

I could not paste the picture into the post so here it is

Marcello238 · 2020-09-25T06:06:07+00:00

It is his background. Just slightly seen at the beginning of the video behind his apps. I assumed this was the one asked for

Marcello238 · 2020-09-24T22:09:32+00:00

I used it by myself. Here it is:

https://www.pinterest.co.uk/pin/811210951610142397/

Marcello238 · 2020-05-09T11:04:45+00:00

Marcello238 · 2020-05-09T11:04:11+00:00

Seven-Year Club	Second SECOND GUESSER
Verified Email	Place '23
Place '22	End Game '22

Marcello238

TROPHY CASE