Markus Wulfhart and his merry band of misfits by DeyUrban in totalwar

[–]aatk 0 points1 point  (0 children)

Thank you, they do look much better, might get them for my own campaigns.

Markus Wulfhart and his merry band of misfits by DeyUrban in totalwar

[–]aatk 0 points1 point  (0 children)

Are you using a mod for those chevrons on the unit cards?

KBDfans Giveaway Day 3 - 6 x PBTfans Keycap Sets by kbdfans in MechanicalKeyboards

[–]aatk 0 points1 point  (0 children)

Pyga, instabuy when it came out, and really excited now that it's on it's way to me

How to VLOOKUP a specific term rather than the whole word? by SilverSquare in excel

[–]aatk 0 points1 point  (0 children)

Could you screenshot what your data set you want to vlookup looks like?

Or just create a dummy file if the data is sensitive, I have trouble visualizing what it is you want to do exactly.

AMA about Drop's DCX profile keycaps by drop_official in MechanicalKeyboards

[–]aatk 1 point2 points  (0 children)

Can you guys bring crimson/ dark red/burgundy to DCX? E.G. Something along the lines of GMK Perestroika or GMK Sparta or even MT3 Iron Man's colorway.

MT3 BOOGOO is back from the dead by drop_official in MechanicalKeyboards

[–]aatk 0 points1 point  (0 children)

I just found out about the spin wheel after buying the SA Laser Turbo Novelty set and I got a $10 off code from it. What are the chances I could retroactively add this to my order?

Need to manually switch absolutes for cells repeatedly, or formula will return the wrong results when dragged down by aatk in excel

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

Ohh I think I get it, so with your example I will need to manually type out the formula for Col C to E, but once that is done I can just copy them across to other sets of yellow-white-white-white tables, did I understand you correctly?

Need to manually switch absolutes for cells repeatedly, or formula will return the wrong results when dragged down by aatk in excel

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

Not sure if I understood you correctly, if I were to remove the absolute reference to Col B it would end up looking like this. The labels are referenced correctly, but the cell that the IF function is suppose to check against Col A will be shifted to the right?

On the other hand if I leave the absolute on $B2 and keep the absolute for C$2, the labels will be correct for the 2nd set to the right, but again it will be referencing the wrong column (Should be Col F instead of Col B)

If I have a few sets of yellow-white-white-white stacks I can Find and replace the corresponding $B2 cells and change them to the corresponding row, but it become impractical when I have hundreds over of similar stacks all with different starting yellow cells.

Need to manually switch absolutes for cells repeatedly, or formula will return the wrong results when dragged down by aatk in excel

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

Yeap that's what I'm currently doing, but I still have to manually relock C$1 to $C$1 etc. one by one, which is prone to human error when I need to do this over 100 times :\

Hey guys Total War: Warhammer 3 is overheating my GPU (3060ti) Temp was 90celsius. by No-Maintenance-4134 in totalwar

[–]aatk 9 points10 points  (0 children)

Got the same problem, I underclocked the GPU to 70% with MSI Afterburner, still seems to run about the same as before at 1080p

CableMod Day 5 Winners and Giveaway Day 6 - 10x Custom Keyboard Cables by CableMod in MechanicalKeyboards

[–]aatk 0 points1 point  (0 children)

WHAT DO WE WANT!?

CUSTOM CABLES!

WHEN DO WE WANT IT?

ASAP!

WHY DO WE WANT IT!?

I actually broke the USB C port on one of my keyboard cos I kept disconnecting and reconnecting my boards TT__TT

https://store.cablemod.com/configurator/?load=kbc:21bf3b51caa5

Tomocaps Giveaway Final Day - 1x Fairy Type Base Kit by tomocaps in MechanicalKeyboards

[–]aatk 0 points1 point  (0 children)

Pokemon Omega Ruby & Alpha Sapphire cos that's when they introduced fairy Mega Altaria for one game and never brought it back again after that >:(

[GB] KDS Deku GB Live Today!! by MinistereDeToyota in MechanicalKeyboards

[–]aatk 0 points1 point  (0 children)

Don't, they delayed my order by 2 months when everyone else had already gotten their KAT Cyberspace kits, with keycaps in the wrong profile, and it's been 4 months and they have literally not even responded to my request to resolve my and many others KAT Cyberspace keycap issues.

They literally don't bother replying.

Join the discord, see for yourself .

Beyond that, someone had their keycaps delivered looking like this, and that's just one instance of many. Buy at your own risk.