It’s wild how much a high-stakes legal fight can absolutely wreck a person's health. I’ve seen people lose so much vitality just from the stress of being stuck in the system for months. Does anyone else think the pressure of these types of trials is becoming a health crisis in itself?
I’m wondering if anyone has actually managed to fix this Bluetooth mess on Windows 10 over the last year. My laptop just won't recognize anything... not my phone, not my headphones... I'm not going to repeat everything Christian Cooper3 already said, but man... I wasted three hours of my life last night on absolutely nothing. p.s. My wife's Lenovo running Windows 8 works perfectly fine... meanwhile, my Asus wouldn't recognize a horse if it walked right in front of it. bye
I’ve seriously never run into this before—I can't seem to unhide the first 600 rows for the life of me. What's going on here? Any ideas, Kyle Johnson2? The usual tricks just aren't working. Anyone else dealt with this? I really need a fix ASAP. Thanks!
Maybe you didn't quite catch my drift. So, here's the deal: I'm copying a formula with relative references twenty rows to the right, and if I use absolute references, I have to manually rename all those columns. When I've got something like 30 different formulas using relative addresses, I was looking for a way to flip them all to absolute without typing out every single $ sign by hand. I know there's that F4 shortcut, but I think there might be another way? I can't recall.
Wait, did you seriously think I didn't know how to add a $ to a single formula? 🙂.
edit: Okay, you totally understood me—I see it on your end now F4. And there I was, searching on Google in English, haha. Honestly, I needed this so badly at work today. I wasted a whole hour just typing everything out manually like a total amateur. It was a nightmare.
Clicking around is such a drag, isn't it? But honestly, using ALT + TAB makes everything so much smoother. It just lets you glide right between your open windows without any hassle.
Edward Foster23 said:Benjamin Wilson7! What’s wrong with Ivana_C's tutorials? They're actually great. If you think you can do better, go ahead and prove it. Better work is the best way to critique someone, right?
Man, you seriously need to head back to school and brush up on some basic literary devices and figures of speech. It's honestly scary how narrow-minded you're being here. Moving on.
Man, your suitcase is absolutely packed with stuff like that. It’s not just a few little snippets either; it’s basically the entire internet universe. You really went overboard trying to help her out there, didn't you? - Honestly, arguing about whether this thread should be open... it's pointless. You wouldn't even notice if it happened, since the "top topics" section is basically a dumpster fire anyway. And those tutorials by Ivana_C? Please, they belong in the trash, which is exactly why they're buried in the junk folder.
Taylor Parker5 said:.......... maybe I can set him up to work for me for the greater good.
🙂 That would just be working for his own benefit, wouldn't it? So, nope—nothing to see here, if you ask Suleiman the Magnificent. And hey, 😘 good luck on your exam!
Kyle Johnson2, you're actually against the law? Seriously? He's right here serving his community service sentence. The guy robbed some jewelry store. He got two years of probation plus four years of community service.
On the first sheet where you want that total of 99 other numbers to show up: 1. Just click AutoSum, and you'll see the =SUM() function pop up. 2. Next, head over to Sheet2, hold down the Shift key, and then click on the very last sheet, Sheet99. (Why use "Shift"? It lets you select everything from the first one—Sheet2—all the way to the last one, Sheet99, in one go. That’s what we call grouping. If you used CTRL instead, you'd just be picking random sheets like Sheet3, 5, or 17.) 3. Go straight to cell B68 and hit Enter. 4. Your formula bar will look like this: =SUM(Sheet2:Sheet99!B68). Basically, it's giving you the sum of all those B68 values at once.
- Or, you could just type the formula in manually, but honestly, trying it with the Shift key is much better practice. - There are plenty of other ways to do it, but I think this method is your best bet.
Cvetko and Corn When you're replying to the post above, there’s really no need to quote the whole thing. What's with three posts taking up half a page??? One guy has over 8,000 posts, while the other barely has ten. I mean, Cvetko might still have a chance, but Corn is a lost cause at this point. And all of this is just on an "IT" PDF... if this is how they act here, can you imagine what the rest are like?
Maybe you were using periods instead of commas for your decimals? Just a guess. Once you get those numbers in there, either I or someone else will take a look at it.
Try wrapping it in an IFERROR function (if you're using Microsoft Excel 2007) or maybe ISERROR if you're on the older Microsoft Excel 2003. For example:
=IFERROR(PRODUCT(A1*B1*C1)+PRODUCT(A1*D1*E1),0)
And hey, instead of that zero at the end, you could just use empty quotes "" if you prefer.
I'm curious, why is the original file acting up? Wouldn't it be way easier if you just used the one that actually works instead of this one?
Is everything formatted as numbers, or did some cells accidentally get set to text?
hollowstag7 said:I really need some help here. I’m attaching a file as an example (it explains more in the sample itself). I'm trying to figure out how to copy content as Values.