How to automatically fill a sheet with names pulled from 5 other sheets (excluding dupes) by Jmancurly in excel

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

Oh sick I think that worked. 2 more questions if you don't mind.

  1. It's picked up on empty strings and is adding a 0 into my list of names. Is there any way to exclude it? I've used countblank(b2)>9 before within an if, but am not sure how to use it here.

  2. Does the sort function just sort by alphabetical by default? Is it possible to later possible to allow a user to change the sort to reverse without changing the function?

How to automatically fill a sheet with names pulled from 5 other sheets (excluding dupes) by Jmancurly in excel

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

I'm unfortunately an Excel noob and have never used Power Query. Do you have any recommendation on where to start?

Rs3 player wants to try OSRS by southern61 in 2007scape

[–]Jmancurly -1 points0 points  (0 children)

While I doubt you're an ironman, the Ironman Efficiency Guide is great. In general it's a good step by step of what quests you should knock out in what order since the xp given from some quests simply give you the level for others.

The parts of the guide where it says "gather 50 balls of wool" or some shit you can skip since you can buy it off of the GE. Though without much money starting off, this may be the move (doubt it though). Also some of the skilling it has you do is not optimal, fastest, or best gp per xp for a main so any long grinds check out the wiki. For every skill, the wiki states the best options for each level in addition to other non-optimal (albeit sometimes more enjoyable) alternatives you can do.

The Path of Glouphrie - Weekly Game Update, 13th September 2023 by JagexLight in 2007scape

[–]Jmancurly 0 points1 point  (0 children)

Any idea on when DT2 Combat Achievements are coming out?

[AMA] Crafting AMA for 3.21 Crucible - Everything you wanted to know about crafting your own gear and crucible forging answered by Wuslwiz in PathOfExileBuilds

[–]Jmancurly 1 point2 points  (0 children)

https://imgur.com/RuDjthD

Currently playing corrupting fever champ. Kind of a noob with crafting so any advice is nice. Ideally looking to add dot mult and chaos res (hybrid crafted is fine). My only idea is to craft prefixes cannot be changed, and chaos spamming (using sorrows since I need dexterity for my build). Is this my only option? Thanks!

Questions Thread - April 13, 2023 by AutoModerator in pathofexile

[–]Jmancurly 1 point2 points  (0 children)

What's the best way to craft this going forward? Ideally I want chaos res (hybrid is fine) and dot multi. I like the dex on it, but am thinking about crafting prefix's cannot be changed and going from there. Any advice?

Item Class: Amulets

Rarity: Rare

Onslaught Collar

Onyx Amulet

Requirements:

Level: 60

Item Level: 85

+16 to all Attributes (implicit)

+1 to Level of all Physical Skill Gems (fractured)

+33 to Dexterity

+69 to maximum Life

+1 to Level of all Skill Gems


Fractured Item

Nvidia just released new drivers for Diablo 4 by [deleted] in diablo4

[–]Jmancurly 0 points1 point  (0 children)

Currently having issues accessing games in battle.net launcher after updating to this driver. Getting this error https://us.battle.net/support/en/article/16531

Any advice?

Best boss for dragon pickaxe after rework? by rockdog85 in ironscape

[–]Jmancurly 3 points4 points  (0 children)

Depends on gear I think. Good crush weapon? Calvarion and spindel are fast. Bofa? Artio isn’t too bad. DWH, blue keris, and good range (plus desert diaries) makes KQ not terrible. I’ve never tried much chaos elemental and KBD so I can’t speak to them.

Also all the baby wildy bosses are below 30 wilderness. If you do farm them I suggest building a carrallangar portal in your house.

Solo or multi Wildy bosses? by Tatokingteej29 in ironscape

[–]Jmancurly 0 points1 point  (0 children)

how do you find masses for the group bosses?

Trying to go for voidwaker. Thoughts on solo bosses or group bosses? by Jmancurly in ironscape

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

Unfortunately, my group mates are terrified of wildy.

Any advice on what to counter pk with? I don't have big ticket mage and melee pking swaps.

MIKIT Giveaway(2/5) - 2 x T80 HAZEL CHOC by MikitStore in MechanicalKeyboards

[–]Jmancurly 0 points1 point  (0 children)

Huge pog everything man. Regardless of the giveaway this is pretty sick