Go ahead and type an equals sign into cell B1 on Sheet 2. While that cursor is still blinking, just hop over to Sheet 1 and click on the cell you want to pull data from—let's say A1, like you mentioned—and you'll see the formula pop up right there in Sheet 2 (B1): =Sheet1!A1. Basically, it’s grabbing those details from Sheet 1, and if you need more, you can just click and drag it down to copy the pattern.
- Or, you know, you could just manually type that formula into Sheet 2 (B1). I just wanted to show you how a formula actually "builds" itself. - And once it's there, you can toss in plus signs, minus signs... whatever you need!
Take a look at the EULU. It should clearly state whether you're allowed to use Home & Student for commercial work, but my gut tells me the answer is no.
For round two: 1. You really need to specify which version of Microsoft Office you're using (like 2003, 2007, or 2010) 2. It would be great if you could be a bit more specific when you use terms like "edit." Can we try to pinpoint the actual issue? For example, are we talking about how to set the page numbers, how to adjust the header, or maybe how to fix paragraph indentation? Something like that....
Walter Jackson48 said:"Knowledge isn't about memorizing everything to know it; true knowledge is knowing exactly where to find the answer." And if I ever mess up, I'm always ready to apologize.
That definitely isn't what knowledge means. People who think like that usually barely scrape by with Cs in college. "Omnia mea mecum porto" basically just means you're carrying your whole library around with you.
You're just spreading bad vibes with an attitude like that. Just relax and take a page out of Julius Caesar's book. What apology? To whom? Who even asked for one? Do you even know who wrote these instructions? Try digging through the PDF history—that's where the solution is (just like on the linked page). But hey, look at me, being all smart now! Not really! And don't get so worked up; it’s honestly not worth it.
Look, just pass this off to a buddy who actually knows their way around this stuff, or maybe a friend of a friend? It shouldn't be this hard to find someone who can help—I mean, in a place like America, everyone seems to know someone, right? Working with version 10 is honestly so much smoother.
p.s. try typing that error code straight into Google and see what comes up. There are probably a dozen different ways to fix it.
Kyle Johnson2 said:Alright, that wasn't quite what I meant. I'm actually more curious about that Word document itself. 😉
I'm thinking this is all down to Windows Rights Management. It lets the author set up restricted access, which basically locks certain features—like preventing someone from printing, in this case (though you can also block copying or editing).
If that's really what's happening, then there isn't a "legal" way around it, as far as I know—even regarding that other thing mentioned earlier.
For Word 2007, you just go to Prepare -> Restrict permission -> Restricted access.
Kyle Johnson2 said:I don't see any reason to doubt it if the law was transcribed straight from the Federal Register. I mean, at the end of the day, she could have just gone to a government website and copied—or even printed out—the specific law herself, right?
The only real issue here is that we’re dealing with a cleaned-up version of the Law. You won't find anything like this in the Federal Register. They just publish the Laws and any subsequent amendments as they come out. Registered companies handle all the polished, finalized versions of these texts, and they charge a premium for it. But you can't just go around publishing them publicly—there'd be no point in doing the work if anyone could grab it for free, which is exactly why those protections exist. Honestly, trying to keep up with the federal laws and all their constant amendments on the official government websites is an absolute nightmare. It’s nearly impossible to stay current when there isn't a single version of the law available that hasn't been cluttered by endless updates and supplements.
I have a ton of data organized in tables in Excel! Everything is laid out in columns—so you've got column one, then column two, then three, and so on. Now, I really need to move all those data points into one single, massive column. Any idea how to do that? 😁
12 a 44 b - If these four pieces of data are each in their own column (A1 through D1), both of these formulas in E1 will give you the exact same result: 12a44b
Formula 1 in E1: =A1&B1&C1&D1 or maybe Formula 2 in E1:=CONCATENATE(A1;B1;C1;D1) - Once you type it into E1, just click and drag it down the column.
- With that first formula, if you want some breathing room, you can add spaces like this: =A1&" "&B1&" "&C1&" "&D1 => 12 a 44 b
David Flores78 said:Is Excel actually the right tool here, or should I be looking at something else?
The only thing Excel can't help me with is in the bedroom... what a shame! If I could just program one "macro" onto a button, I'd be a total legend. But hey, for managing your addresses? Honestly, I'd give anything for that kind of utility.
I've got two different "groups" of data sitting in two separate columns.
The thing is, the second group actually includes everything from the first group, plus some extra stuff. So the groups aren't equal in size, but they share those common elements.
Is there a way to "sort" these two columns so that the matching items line up on the exact same rows? And where the second column has those extra pieces of data, could I just have blank rows in the first column?
Or, at the very least, can I get the matching data onto the same rows and just push all the leftovers to the bottom?
It's all numbers, so I could easily sort them by value if that helps anything.
Thanks a million!
Since the second group contains everything from the first, try this: add a helper column with serial numbers for your first group. Copy those numbers over to the second group, but leave the cells blank for any new data you're adding to that second set. In that second group, you can manually insert cells between the matched data points wherever you need to—just make sure those new spots don't have a serial number assigned.
Then, simply sort both groups based on that serial number column. This should force all those extra entries in the second group to drop down to the end. It’s pretty straightforward, provided you set up the first group before you start adding the extras to the second one.
She knocked out the first round by nesting an IF statement using AND, and honestly? Problem solved. Now, let's see if he actually understands how function nesting works.
Home -> Editing -> Sort & Filter -> once you apply filters, head over to ->Number filter -> then select Between (this lets you show rows where the value falls within a specific range—just plug in your numbers, decimals, etc.), one of those essential Excel tools.
You're missing the point here. It’s not about deleting rows—of course they aren't doing that. They're just hiding them, leaving behind exactly what you need to see, from start to finish.
