Excel question for the hivemind: I've got a chart I update daily in which I input a value in a particular cell, and the value is then computed as an average in the next cell. There are a series of columns like this: Value, Average, Value, Average, and so on. (1/2)
Some columns, when I plug in the value on a given day, the next cell automatically fills with the appropriate formula. For others, I need to paste from the day before. The automatic ones just started doing it without me telling them to. How do I tell the others to do it? (2/2)
To clarify: The feature I'm trying to replicate is that sometimes Excel figures out that I'm going to want to put a specific formula in a certain cell, and auto-inserts that formula into a blank cell without me having to paste it in.
It's like Clippy, but actually useful. (And unobtrusive.)
To put it another way, when I fill in a value in (say) B32 I need to copy-and-paste the formula from C31 to plug it into C32, but when I type a number in in D32, E32 will automatically fill itself with the formula from E31. I want all the columns to do what E is doing.
Thanks all for suggestions! Unfortunately, the closest I've gotten to success is a couple of people saying "I've got spreadsheets that do that too, but I've never been able to figure out how to make it happen on purpose." Sigh. At least now I know it's a thing, and a mystery.
Holy crap this worked. It's not quite a way to replicate the behavior, but it's an entirely functional workaround. Yay!

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Angus Johnston

Angus Johnston Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @studentactivism

6 Mar
At the Javits Center for my first shot. Will update.
Arrived at the 36th Street Javits entrance at 2:42. Line extended past the entrance, but only barely—was in the building within about a minute.
About ten minutes after getting in the building, they checked my appointment sheet printout, then put me on the next line.
Read 33 tweets
6 Mar
This amendment would have barred all federal funding to schools and colleges that let ANY trans women or girls participate in women and girls' sports under any circumstances. Needed 60 votes, got 49. Murkowski and Manchin were only two Senators to flip.
And please don't come into my mentions defending this proposal on the grounds that trans women and girls' participation in sports is a complicated or hard question, because this proposal doesn't treat it as a complicated or hard question.
The premise of the Tuberville amendment is that the exclusion of trans women and girls from women's sports in educational settings should be absolute, and that the budgetary power of the federal government should be used to police that exclusion.
Read 6 tweets
3 Mar
Less than one percent of the cost of the bill. Manchin seems to be deciding that "occasionally being an asshole for no reason" is how he's going to make his mark between now and 2022.
And this really does seem to me to be a solid counterexample to the "Biden is using Manchin as a fig leaf to pursue his real goals" theory. (Which may well be legit in other contexts.)
There's no actual reason for anyone but Manchin to prefer the Manchin path here. It doesn't save money, create a better narrative, or target spending in any serious way. It's just a mechanism for Manchin to get a meaningless victory at the expense of Biden and the national party.
Read 4 tweets
1 Mar
So since @conor64 has QTed this in a weird way, let me say a bit more about it. My claim isn't—I think CLEARLY isn't—that McNeil "harmed" the teenagers in any way. It's that he was a poor choice of ambassador because he's not good at communicating with young people of their ilk.
I don't think McNeil's big sin in the Peru story is being evil. I think that his big sin is being an out-of-touch self-satisfied old doofus. And I say that as someone with out-of-touch self-satisfied old doofus tendencies myself.
When McNeil showed up in Peru quoting Tom Lehrer, making Jewish mother jokes, and saying "but what about blackface when BLACK people use it in AFRICA?", it was pretty much inevitable that he was going to come off as an annoying old weirdo.
Read 4 tweets
1 Mar
I would not have phrased this thread about Donald McNeil precisely as Mikki does, but ... yeah, basically, this.
Reading McNeil's posts, it does seem clear that he was pretty much fired, or at the very least that he quit in the face of a major, imminent, intentionally humiliating demotion.
But it's also really really clear that he should never have been assigned to that student trip to Peru, and that the fact that it blew up in his, and the Times', face was entirely foreseeable.
Read 7 tweets
28 Feb
Since Al Franken is trending again, let's remember that the allegations against him were multiple, varied, and serious, that he admitted to misconduct before resigning, and that even his coworkers andallies have described a longtime pattern of inappropriate behavior.
And if you're going to come into my mentions to argue that Al Franken was railroaded out of office in a way that should serve as a cautionary tale, please read this thread first. He gave his colleagues no basis on which to support him. FOR WEEKS.
I thought Franken was a really strong senator, by the way. I did my bit to help him get elected in his first campaign. And no, I don't think what he did was as bad as what Trump has done. And yet.
Read 8 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!

Follow Us on Twitter!