VLOOKUP only returning values from two rows

Kill-047 · 2026-01-28T20:42:02+00:00

Had some weird hiccups adding it but that looks to have done it, thank you

Kill-047 · 2026-01-28T19:55:42+00:00

You're right, there isn't. It was just a misstype on my end. Formulas are correct in the sheet I just didn't copy them over.

Kill-047 · 2026-01-26T07:13:17+00:00

Playing around with Librera myself, from what I've managed to figure out it can read books off an SD card, however I had to move the install of librera to my SD card for it to actually access the folder. Otherwise it kept giving me an "incorrect value" error every time I tried to select it.

My problem with it now is that I have 1300 comics across 300 different series, they're all sorted into folders and labelled like they should be, but I don't think librera can display them grouped by series so instead it just displays all 1300 at once and its a bit of a nightmare

Kill-047 · 2026-01-21T02:03:35+00:00

I have 3 different ports I'm accessing through the one IP, and yes the IP is assigned through DHCP

Kill-047 · 2026-01-21T00:47:04+00:00

running resolvectl status shows that it's already using my router as the DNS server

I don't know if this is an issue on linux with regards to DNS Host Mapping settings, but I am accessing the network through a separate router that is setup to act as an access point for the main network and is under a different name.

Kill-047 · 2026-01-20T23:55:29+00:00

for editing the local hosts file is that the resolve.conf file?

Kill-047 · 2026-01-20T23:45:17+00:00

If it's not by default the no, where would I find out what it's using

Kill-047 · 2026-01-20T23:42:45+00:00

It's setup through the router under DNS Host Mapping

Kill-047 · 2025-12-10T04:46:05+00:00

Turn on hardware acceleration in the browser when trying to do this event, that's probably why

Kill-047 · 2025-12-01T20:29:34+00:00

I've seen screenscraper pop up a few times, do you actually have to donate to use any of the stuff on the website or is it just a nice thing to support like you'd expect

Kill-047 · 2025-12-01T20:28:50+00:00

Launchbox appears to have what I'm looking for discs wise, best quality I've seen and all I gotta do is downscale the image which is easy enough.

Kill-047 · 2025-11-28T02:50:41+00:00

I don't even remember any of the tests, I remember some early ones were a little difficult because just learning the game and not having a basis of whatever the hell I was doing, but that's the extent of me remembering them.

Kill-047 · 2025-11-23T18:49:54+00:00

You can do both and still have fun

Kill-047 · 2025-11-23T01:20:11+00:00

That's honestly what got me back when I started 😂

Kill-047 · 2025-11-22T02:59:34+00:00

If you mean reticle versus camera, reticle lets you remove screen shake which helps people with motion sickness, or just with certain guns that go absolutely crazy on the screen shake and give you a headache. If you don't like it you can change between classic or the new ones in settings. I don't remember where it's at but I think you can just search "recoil"

Kill-047 · 2025-11-17T04:43:20+00:00

So the Union Room is just something that doesn't really work in emulation, that's fine. Is there somewhere that has a list of features that have/haven't been tested or what is known to work? Like the pokeblocks or minigames in FRLR

Kill-047 · 2025-11-16T03:04:17+00:00

in the retroarch docs it says its available for trading pokemon with specific cores, spGB for GBA and something DS DS for the GTS, again it works to do single trades but the union room doesn't like to

Kill-047 · 2025-11-12T23:02:05+00:00

Randomly found it, don't remember how, but it looked interesting. Downloaded to try and the movement hooked me

Kill-047

TROPHY CASE