TroyAtWork

I use Excel for many engineering calculations. Using underscores to denote subscripts and carets to denote superscripts is so sloppy and takes up precious horizontal space.

Ugly and expanded vs. clean and compact... come on!

This isn't the most egregious example, just the one I was working on right now. Usually I use ASCII characters if it's just numbers in the sub/superscript, but there is no superscript decimal point so I'm out of luck here with my ^0.33 in the formula. (And I don't love the 0.33 exponent either but that's straight from a building code formula that I have to follow.)

I know there has to be some deeply complicated reason this has never

On 11/15/2021, Robert Williams went 0-2 from the floor against the Cleveland Cavaliers. Since then, he has shot ≥50% in 82 straight regular season games.

• 10 of those games he shot exactly 50%

• 17 of those games he shot 100%

• 1 of those games he played 15 mins and didn't attempt a field goal (so I guess it's technically more accurate to say he "didn't shoot <50% from the floor in his last 82 games played")

More stats over those 82 games:

• He has shot 336/454 (74.0%) total

• 88.3% of his FGA are within 5-ft of the rim

• Of his 84 misses, 19 of them were due to being blocked

• 67.6% of his makes were assisted, 32.4% were unassisted

• He was assisted by Marcus Smart 55 times, Jay

Fuck every asshole that clogs up apartment rental websites with their single rooms.

Say if in A1 is the equation:

= A2 + A3

-

Then in B1 I have the equation:

= A1 + 7

-

I am hoping there is an easy way to take the "A1" in this equation and swap it with "A2 + A3" so the resultant is:

= A2 + A3 + 7

-

Obviously this is a very simplified version of something I would like to do on a larger scale. Using find/replace is not what I'm looking for; I would be using this for equations with multiple cell references.

I know you can highlight a cell reference and use F9 to get its end result, but I'm hoping there is a way to replace a cell reference with its actual formula.

Thanks!

If one of the cells was the number 12 and one cell was the text "12" then we could easily tell the two apart with ISTEXT and/or ISNUMBER

And if one cell is 12 and the other cell is "=12" then we can use ISFORMULA

And I could cheat it a little and format one as 0 "inches";[Red]0 "inches" and the other as just 0 "feet" so that the CELL("format") function would output "F0-" for inches and "F0" for feet.

I'm guessing that's as far as I can take it without VBA though, right? I wish there was someway to be like =CUSTOMFORMAT(A1,"0 ""inches""") that would output TRUE for A1 and FALSE for B1. Any hidden functions I don't know about?

Thanks!

(Excel 2019)

#Players 6'6" or taller, 500+ minutes in a season without recording a block:

• Semi Ojeleye: 950 minutes in 2020-21 (age 26)

• Michael Redd: 770 minutes in 2011-12 (age 32), his final season of an injury-riddled career before retirement

• Dale Ellis: 567 minutes in 1999-00 (age 39), his final season before retirement

• Al Harrington: 511 minutes in 2013-14 (age 33), his final season before retirement

• Zoran Planinic: 511 minutes in 2004-05 (age 22), busted out of the league after the following season

#Players this season without a block:

• Semi Ojeleye (6'6") – 950 minutes

• Tyler Johnson (6'3") – 684 minutes

• Brandon Goodwin (6'0") – 620 min

####Isaiah Thomas:

• 56 career blocks ÷ 15,320 career minutes × 36 = 0.132 blocks per 36 minutes

####Semi Ojeleye:

• 13 career blocks ÷ 3,639 career minutes × 36 = 0.129 blocks per 36 minutes

Bonus fun fact of the day: Semi Ojeleye has the same measured standing reach as Nik Stauskas.