gezza07

modmodmod

A place for members of r/pewpewpewpewgt to chat with each other

You can split a Ring of Health (15hp) into ring of regens (2* 10) for greater health regen in one round. Could make a difference early on!

Dismissing elves doesnt dismiss IO

You can use two wizards to complete a 3star Druid Syrnergy. For example you can use Rubick + Dark Willow with Treant and Furion to upgrade Enchantress.

Upgrade the Enchantresss using the Druid Synergy for extra income. You get back 3 gold for the cost of 2.

If you are lose streaking hold onto your treasures until later creep rounds. They will give you a chance at the greater item levels Pretty sure this is incorrect !

Let me know any i missed here.

New patch out. Pretty crazy update and feels like alot more action especially early game. Rook + Queen lobbies are really interesting right now but alot revolve around 3 starring $1/%2 cost units after you dismiss at around round 13/15.

A really popular strategy was Warriors + Gods

Mars + Tiny + Tusk + Oracle + Jugg + Rubick + Dark Willow + Slardar in that order.

Really fun to play cause you get to roll lots before level 5 to get everthing 3 star. Jug gets mana items and should stay spinning the whole time.

What are your thoughts on the patch?

I just had an Ogre's game present itself and went for that. Was fun as I had to adapt on the fly. I've theory crafted this build but never done it until now.

Doom 3 didn't hurt. What fun builds have you tried win or lose?

https://reddit-uploaded-media.s3-accelerate.amazonaws.com/images%2Ft2_6q0hw%2Fc7znzh0xh1l41

Rotating between rook and King at the moment. I play a more eco style when everybody else seems to be very agressive however I will chuck in some cheeky round 5 -6 rolls if I have a good pair /s.

Fav build is beasts + war and hunters ( even they they are shit). I fucking hate elves and treant in particular.

Bring back SF.

any info would be great!

Do all duplicates get an Aqir unit spawned? How does the star of the unit get selected and the unit itself? I also read that once you have a 3 star unit you won't receive that unit ever again is that true? Sorry Do summons get Aqir units (ld bear)? Do summons count towards ogre bonus (Lycan wolves? Does other multicast replenish mana or simply refresh like refresher ?

Any help appreciated

Hi All,

I have trailing commas at the end of an my spreadsheet through a formula that returns "" when false. [=If(statement,TRUE,"")]

I am also using ActiveWorkbook.Save as, FileFormat :=6 in a macro that saves the file as tab as a CSV (ready for import into another program)

Is there any way, either through editing the IF statement or my macro for my CSV file to not save the blank commas trailing at the end of the spreadsheet (they will always be at the end). At the moment, I have added a filter to my macro that finds blanks in the columns and deletes the row. Whilst it works, I feel like there is a much smarter solution out there! Am using Excel 365.

Thanks office warriors!

Hi All,

I need help finding creating a formula the returns the closest number in a range in.

For example, I type 12 against a list of {10,15,25} and it would return 12. If i type in 13, it would return 15. I have found a solution using array formulas but would like to avoid that if possible.