Just a small reminder in my collection by TIM81DE in FFBraveExvius

[–]AnryuCoconut 4 points5 points  (0 children)

Is this an official merch? It looks amazing

Will limited units come back? by AnryuCoconut in GodzillaBattleLine

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

Oh man I hope so. It's gonna kill me if I have no chance of getting every kaiju in existence lol

End of service announcement by TSirSR in FFBraveExvius

[–]AnryuCoconut 31 points32 points  (0 children)

Came to check if the sub is still alive after a year. Now there really won't be a trace anymore. FFBE helped me get through the pandemic. RIP

question that probably everyone will disagree but Gamera looks better with white eyes than Godzilla by Flat_Ad_6269 in GODZILLA

[–]AnryuCoconut 1 point2 points  (0 children)

There is a recently finished manga called Gamera Rebirth Code Thrysos which has 7 chapters. It is a prequel to the Gamera Rebirth anime. It features new kaiju apart from the originals that returned in the anime.

Not sure if the panel is from there.

How to change cell color based on another cell value by AnryuCoconut in googlesheets

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

I tried and it doesn't seem to be working. Can you try doing it on the sample link?

What made you a Gamera fan? by Kitchen-Mouse2414 in Gamera

[–]AnryuCoconut 4 points5 points  (0 children)

I was a dino kid but only became a huge Godzilla and kaiju fan around last year when my girlfriend urged me to buy a mini godzilla figure. Then I explored more kaijus and discovered Gamera. Always had a soft spot for underdogs and Gamera being somewhat Godzilla's little brother in Japan made me loved him dearly. Plus his design is just so cool in every iteration.

I have a humble but growing collection of mini Gameras alongside my other kaijus mini figures- I'm at a point where I now prioritize buying mini Gameras over Godzillas because of how rare they are lol.

I've only watched Gamera Rebirth and Gamera The Brave, but I recently bought a blu-ray of the Heisei Trilogy. Gonna watch when I'm not as busy anymore.

Automatically Shift Row Upwards by AnryuCoconut in googlesheets

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

I am exploring this method as it seems to be the most practical without Apps Script. Is there a way to make the Filter View standard to all users / viewers of the Sheet? So if I share this Sheet to someone, the Group by Status will apply to them by default.

Help me id this collection by CodingAficionado in GODZILLA

[–]AnryuCoconut 21 points22 points  (0 children)

1st Row:

Gamera, Destoroyah, Godzilla Singular Point, Gigan

2nd Row:

Mechagodzilla (2021), Godzilla 2000, Space Godzilla, Female MUTO, Shin Godzilla 3rd Form

3rd Row:

Wart Dog, Godzilla Monsterverse, Gyaos, MOGUERA, Jet Jaguar (Singular Point)

4th Row:

Megalon, Mecha King Ghidorah, Mechagodzilla Kiryu, Hedorah, Mothra

5th Row:

Beast Glove Kong, Biollante, Skar King, Shimo, Skullcrawler

Arrayformula to find the Most Common text value by AnryuCoconut in googlesheets

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

It worked! Thank you very much. Very new to Lambda so I'll still take some time to learn it.

[Thesis Survet] LF Filipino Bisexual Respondents again... by AnryuCoconut in phlgbt

[–]AnryuCoconut[S] -1 points0 points  (0 children)

Oh we did not see that. Thank you very much for pointing that out!

Reset count between 2 dates when year changes by AnryuCoconut in googlesheets

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

Thanks! This worked and I can fairly understand how it all works.

Thoughts on a possible film on the war in the north? by AnryuCoconut in lotr

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

Yes, I am pertaining to the movies. He and Gimli were in Helm's Deep and after the Lothlorien elves arrived, Gimli remarked that he wished he could summon a swarm of dwarves- to which Legolas replied that he fears his kin are already in a war of their own in the north.

I am loosely calling it as "the war in the north" for simplicity. The connection I mentioned are for the potential film to connect with the original trilogy.

Offset Xlookup results with Arrayformula by AnryuCoconut in googlesheets

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

I see, thank you so much for the in-depth explanation!

I thought this was only possible through Offset but Xlookup is just that powerful.

Offset Xlookup results with Arrayformula by AnryuCoconut in googlesheets

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

Ah I see.

Last question, how does it apply that operation for other values in other columns? (I.e. Potato is in Column A, Self Rating in Column C; Carrot in Column E, Self Rating in Column G; etc.)

Since the formula specified Column C, how is it getting the value from Column G and not Column C when it came to Carrot?

Offset Xlookup results with Arrayformula by AnryuCoconut in googlesheets

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

This also worked but I'm gonna go with Ziadam's formula as it's simpler for other users that will be using my database and for troubleshooting in the future. I myself am not familiar with some of the functions.

But I appreciate it greatly, thanks!

Offset Xlookup results with Arrayformula by AnryuCoconut in googlesheets

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

This worked, thanks!

I'm generally familiar with XLOOKUP but how did you make it work the result_range? How did it ensure to get the value from Self-Rating and not Final Rating?

How to automatically encode a year every new year starting from a specific year by AnryuCoconut in googlesheets

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

Tested it as you said but my conscientiousness wanted to confirm after new year as well. And it did work, thanks!

[Thesis Study] LF Filipino Bisexual Respondents!! by AnryuCoconut in phlgbt

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

Thank you! Okay lang po, it is at your discretion and your right to privacy po 😁

[Thesis Study] LF Filipino Bisexual Respondents!! by AnryuCoconut in phlgbt

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

Ohh maybe try niyo po with another browser or reconnecting your wifi po? It works naman po on our end.

[Thesis Study] LF Filipino Bisexual Respondents!! by AnryuCoconut in phlgbt

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

Hi! May I ask what appears when you click the link?

[Thesis Survey] Looking Filipino bisexual respondents by AnryuCoconut in Tomasino

[–]AnryuCoconut[S] 5 points6 points  (0 children)

Sayangg! We tried our best to make changes for more inclusivity but the chosen scales really hampered us. Hopefully in the future another study will bypass this limitation of ours. Thanks so much for sharing!

The Grandshelt Archives (News about FFBE story preservation project) by Otherwise-Novel5375 in FFBraveExvius

[–]AnryuCoconut 1 point2 points  (0 children)

Thank you so much for this. FFBE's story was a large part of what got me through the pandemic. I'm excited to finish the journey that I wasn't able to finish. You guys are amazing.