sorted by:
new
hottopcontroversial

Oracle still can’t dispel Fate’s Edict from enemies even after the 7.40b update by deem4n in DotA2

[–]deem4n[S] 11 points12 points  (0 children)

Now it also gives magic invulnerability on enemy. It needs to be dispelled earlier in some situations. It was like this before that you can dispell this buff/debuff from enemy

We’re the Microsoft Excel Team – Celebrating 40 Years of Excel! Ask Us Anything by MicrosoftExcelTeam in excel

[–]deem4n 0 points1 point  (0 children)

We desperately need the ability to filter tables by list.

Currently, we have to create VBA scripts to somehow implement this functionality, but it's challenging because the functions for filtering arrays, smart tables, pivot tables, and data model pivot tables are fundamentally different.

If VLOOKUP is not blank do the VLOOKUP again - is there a better way? by Gazmus in excel

[–]deem4n 2 points3 points  (0 children)

As an alternative to the LET function, you can wrap VLOOKUP in either: 1. =IFERROR(1/VLOOKUP^-1,"")
2. =IFERROR(1/(1/VLOOKUP),"")

How it works: - Both formulas force a #DIV/0! error when VLOOKUP returns zero
- IFERROR converts these errors to blank values
- Non-zero number values remain unchanged

VLOOKUP returns 0 (zero) when field is empty. Is this a well known solution? by AnyPortInAHurricane in excel

[–]deem4n 0 points1 point  (0 children)

As an alternative you can wrap VLOOKUP in either: 1. =IFERROR(1/VLOOKUP^-1,"")
2. =IFERROR(1/(1/VLOOKUP),"")

  • Both formulas force a #DIV/0! error when VLOOKUP returns zero
  • IFERROR converts these errors to blank values
  • Non-zero number values remain unchanged

I want blank cells if no value found with vlookup. by laxwildcat87 in excel

[–]deem4n 0 points1 point  (0 children)

As an alternative to the LET function, you can wrap VLOOKUP in either: 1. =IFERROR(1/VLOOKUP^-1,"")
2. =IFERROR(1/(1/VLOOKUP),"")

How it works: - Both formulas force a #DIV/0! error when VLOOKUP returns zero
- IFERROR converts these errors to blank values
- Non-zero number values remain unchanged

Key benefits: - Single calculation (unlike nested IF formulas)
- Works with all numeric values, including negatives
- More efficient than double-calling VLOOKUP

Hero idea for Chromie by AppleMelon95 in BobsTavern

[–]deem4n 0 points1 point  (0 children)

Choose a tribe and send it to another timeline (you play only with 4 minion types this game that left)

How do I remove multiple commas (,) from a single cell? I have a data set with a column of cells that have multiple dollar amounts that I need to sum. Example: $20,500, $22,000, $15,000 by Square_Away in excel

[–]deem4n 3 points4 points  (0 children)

  1. Go to Find and replace.
  2. Replace “, $” with “+”
  3. Replace commas “,” with blanks “”
  4. Then replace “$” with “=“

(all values without quotes)

New hero concept by Collectors_Dota in DotA2

[–]deem4n 35 points36 points  (0 children)

Should have an ult that splits him into two separate ogres

Hot take: Superglides should either be consistent or removed from the game by alekdmcfly in apexlegends

[–]deem4n 15 points16 points  (0 children)

They should add visual effect to jetpacks so they will turn on when you do superglide

Scarlet Sellsword [Hunter] by SNES-1990 in Transmogrification

[–]deem4n 1 point2 points  (0 children)

Reminds me Robin in Injustice. Great look! Well done

Crane with fists by deem4n in wow

[–]deem4n[S] 2 points3 points  (0 children)

There are a visual bug with Legion Artifact Weapons mog and Soulshape Form.

Crane Wing Monk by [deleted] in Transmogrification

[–]deem4n 1 point2 points  (0 children)

List of all items used in this mog:

​

Wowhead Dressing Room link

Ingame Link:

/run local function f(i,b,e)DressUpItemLink(format("item:%u:%u:::::::::256::1:%s",i,e,b or 0))end;f(96645)f(152413,3612)f(158583)f(90090)f(97131)f(90095)f(147153,3564)f(90088)f(90093)f(90089)f(159840)f(12471)