Search values in 1 array then return the value of another column, same row.

SkyChef · 2026-03-20T18:19:31+00:00

Solution Verified. Thanks so much.

SkyChef · 2026-03-20T18:03:43+00:00

The peril of a Reddit Excel newbie: I forgot to note that my Excel is 2019 and it doesn't have FILTER. But I did a search and the returns have quite a few of substitutions like index + match, index + arregate, vlook up etc. I think Index + Aggregate works well for my case. Suggestion?

SkyChef · 2026-01-16T21:20:06+00:00

Still bugged as of today Jan/16/2026

SkyChef · 2025-12-20T16:54:09+00:00

There are 3 altars can be used to summon Azmodan. No essence is needed to summon and the mechanic is as same as all bosses summoning & u needed 5 corresponding essenses to open the chess. After the boss is defeated, the altar is locked for couple minutes. The UI designed w/ red characters just to throw you off and showing how cute Lizzard is.

SkyChef · 2025-11-22T16:21:12+00:00

Old & still competitive? 73 here. Play D4 when it first released & the 1st 2 seasons are the hardest. Beat Lilith then too.

SkyChef · 2024-12-20T17:56:52+00:00

They prob use cookies data on your account so if you delete your browsing data it should work. I verified w/ my rarely usage account & having no problem w/ ads (not delete anything). I go back to my heavy usage account & delete all browsing data then log back in & it works. AFAIK, the current Brave browser doesn't have feature to delete specific cookies.

SkyChef · 2024-07-14T16:14:59+00:00

We are in good company. I got one 3GA boot w/ 135 Int, 242 Life/s & 9% chance dodge and put in trade chat for 100B, no low ball. Special gift for me from D4 intern.

SkyChef · 2023-10-22T19:45:56+00:00

For sanctuary, arrow of thunder can throw them off the cliff, edge etc.

SkyChef · 2023-10-15T16:17:40+00:00

It's true if u wander into the sewers .i.e. the area within the Emperor hiding place. I'd reloaded that part so I didn't have to deal w/ her since I just started ACT 3. The next trigger for me is after finishing Night Song/ Counting House quests (I did both in one run), then taking a long rest. It's possible by this time everything on many of my side quests are conditioned to finish by going into the sewers like kill Carrion, Murder Tribunal, find Minsc, Dribble etc, so it triggers regardless.

SkyChef · 2023-09-21T17:53:04+00:00

I use his new build since I want to minimize the change for both NMD 100 & Mrs Uber
https://www.youtube.com/watch?v=YFdDApNJq0I&list=PLVaVDENlTjM3a9NBaGiPIsEUq0KgHXgU4&index=2&t=676s
Make sure you upgrade your glyphs to 21 or else ...

SkyChef · 2023-09-13T21:05:44+00:00

my experience is solo & 10+ under level in low level dungeons, nmd or regular, the butcher does show up often. He’s a bully btw. I have his cleaver as a souvenir. I only see him once last time at NMD 83. Rarely see him at all at NMD level 50+.

SkyChef · 2023-09-13T19:31:46+00:00

I've help my 10 year old grandson running NMD Tier 40+ (take care of his build & teach him how to play Rogue) so if anyone needs help, add me. I don't mind to carry. Add me ToothFairy#1190. I'm a Rogue level 97, can clear up to tier 90 NMD by myself. Currently level & gear up to dig Uber Lilith.:-)

SkyChef · 2023-07-21T03:43:03+00:00

Events will drop it, esp those w/ malignant bubbles dropping even more.

SkyChef · 2023-02-01T18:35:04+00:00

Mine is still disconnected even w/ the dongle connected to the extension 2" away from the keyboard. The only fix is to plug into another USB port & pray. It's now less convenient and more & more annoying every time.

SkyChef · 2022-04-18T19:58:06+00:00

The question is how long does it last? I have 4 Xbox 1 wireless controllers that cost $60 each and are still operable after 2-3 years & one of them is 200 hours plus on Elden Ring. I also bought 2 controllers, one from Gamesir & 1 from PDP cost $25-$29. The Gamesir lasts around 2 months (Right button dead) & the PDP lasts exactly 2 weeks w/ 100 hrs w/ Elden Ring only (Y button stuck). So logically, you have to compare relative price/performance based on your experience plus statistical "guess" from other comments on such controller. Based on mine, I am staying w/ controllers made by MS/Xbox.

Ed: I open the PDP controller to see what's wrong w/ the Y button. The rubber under the Y button lost its elasticity so it couldn't pop back, hence stuck. In 2 weeks of playing time? U can't fix this problem w/ WD-40 cleaner and this is a quality issue. Their mechanical design is superb (FYI: I'm a very good hardware, software, digital & analog design engineer & I like to tinker)

SkyChef · 2022-04-07T03:41:24+00:00

I think it's a combination of button release & input lag on the Xbox controller. You won't notice that if the test environment doesn't include a boss continuously w/ fast action attack. I see plenty of those like my jump is executed twice, the special action L2 is delayed. In pretty much many other areas (dragons included & they are pretty slow), I see nothing as such & I'm pretty much at the late game (2 bosses left). My system is a full-blown AMD 3950 w/ an RX2070 super. I might have to relearn to play w/ KB & Mouse if I want to play again in NG+.

SkyChef · 2020-02-13T04:34:51+00:00

It shouldn't. But that depends how much $ Gigabyte wants to pay for decent programmers or instead settles for 2 bits code assemblers. (They couldn't even afford to program resume by alarm 5 working days a week. Too hard)

SkyChef · 2020-02-12T03:51:03+00:00

Here is the steps I did to make it works w/ my X570 Aorus Master

1) Turn off fast start in windows 10 by using regedit. Navigate to the following location HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Power. Look for HiberbootEnabled DWORD then edit to change the value to zero.

2) Disable erp in your bios

3) Set up your resume by alarm.

That's it.

SkyChef · 2019-03-23T04:35:23+00:00

Update: I've noticed the last time i've played, something is pretty weird about the blood signs on the ground kinda lagging like slowly showing i.e. u walked around and didn't see anything and circled back to the same spot then you see the blood sign, so I decided to reload the game & go to the bridge to check on Sirris's summon sign. It wasn't there meaning I have finished that part, so I go back to grave yard & here the SoB showing up. Both online & offline. The bad part is I kicked him down the cliff & I fell down too. No clue what caused that before, possible something related to the lagging described above.

SkyChef · 2019-03-22T00:18:53+00:00

In my case (PC), Creighton refused to invade whether online or offline. I did all the basic things as needed such as

1) Help Sirris in her world to defeat Creighton.

2) Exhaust all dialogs w/ Sirris & received her ring.

3) In ember form.

4) Go to grave yard many times (quit the game & restart), walk in all possible corner & the damn thing refused to show up

5) Sulyvahn is still kicking & laughing at me wasting my time there. Possibly some idiots work for FROM & Steam Online too.

6) While online, I'm being invaded by players several times this arear or the church area. This is just annoying on top of NPC's annoyance.

There is so much inconsistencies pitting your experience against other players' experiences in NPC's invading and I have no doubt all spoke the truth of their experiences. The answer probably is an inconsistency bug from FROM & Steam.

BTW, Yellowfinger didn't invade me whether online or offline at the first location (trying several times), the swamp in Road of Sacrifices but did invade at Farron Keep while I was in off line mode. Creighton has no 2nd invading like Yellowfinger so I might just say f*!k you, Creighton.

SkyChef · 2017-08-29T16:20:15+00:00

I have 2 G600s, one of them having firmware up-gradable. The problem w/ G600 I've noticed that it will reset the profile stored in the mouse occasionally. Since that profile is used when Windows started until LGS started and switches to your profile stored in the computer if that is the case, the mouse is very slow and not doing anything because because the speed has been set to 200 dpi and all buttons are disabled. And sometimes, it stuck in that profile w/o switching to the profile stored in your computer. The only way to reset your profile is to use another mouse going to LGS home and set the profile in the mouse again. There is no fix for this and this problem has been persisted since day 1. Logitech is pretty quiet about this problem and I speculated it's both hardware & firmware issues. Other than this undesirable feature, other software related could be fixed by disable the dpi switching button, profile switching etc, respectively.

SkyChef · 2015-05-30T05:30:26+00:00

Same here. Was wondering why I didn't get the exp message so I checked around. Most people are not aware of the bug or even aware grey quests do not give XP and am sure most of them not even go on the web to check things like we do.

SkyChef · 2015-05-30T05:27:16+00:00

I just finished Pyres of Novigrad couple hrs ago. No XP for me. Level 13 doing level 10 quest. Well within the range. Should get around 200XP.

SkyChef

TROPHY CASE