CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › Walter Jackson48 › Posts

Posts by Walter Jackson48

234 posts shown.

Chloe Rivera14 said:How do I get text to sit on top of an image?

Are we talking about Microsoft Office Word here?

Look, if you're working on a blank page, just paste your picture in there first. Then, head up to the Insert menu and grab a Text box. You’ll want to draw that box right over the image where you want the words to live.
Once that's done, right-click the edge of the Text box to bring up the menu, then go into Format text box. Under the Line and color tab, set the Fill color to No color, and then set the Line color to No line. Hit OK, and you're all set.
Give this a shot: type this formula into C2 (then just drag it down to C52):

=IF(AND(A:A=1;B🙂=1);"a";IF(AND(A:A=4;B🙂=5);"b";IF(AND(A:A=3;B🙂=2);"c";IF(AND(A:A=2;B🙂=3);"d";IF(AND(A:A=2;B🙂=2);"d";""))))).

After that, go into cells D2 through D4 and type out these labels: Komb "a", Komb "b"; Komb "c" and Komb "d".
Then, in E2, put the formula =COUNTIF(C:C;"a"); and in E3, put =COUNTIF(C:C;"b");
For E4: =COUNTIF(C:C;"c") and for E5: =COUNTIF(C:C;"d").

Just a quick breakdown on how that first part of the formula works: Basically, wherever columns A and B both equal 1, we label it "a". Then, that =COUNTIF(C:C;"a") formula simply tallies up how many times those conditions were met—you know, where A and B equal 1 and so on. It might seem a bit convoluted... I remember struggling with similar logic back when I was first learning Excel, and it can definitely feel like you're hitting a wall sometimes if the nesting gets too deep.
Maybe this one will work too:

=IF(ISTEXT(B1🙂8);"1";"0")

Basically, if there's actual text sitting in column B1🙂8, it spits out a "1", otherwise it just gives you a "0".
neonseal22 said:1.) Does anyone happen to know how to get rid of a virus? Like, which program should I download? I'm totally lost when it comes to this stuff.

Look, just take this:http://avast.en.softonic.com/.
1. Has this been happening to you all along, or is this a new headache? If it just started out of nowhere, we might be looking at some nasty malware or a virus messing with your system.
2. Does the same glitch happen when you try using the Save As command?
3. What exactly shows up in the Look in field? Honestly, just set it to My Documents—it’ll save you the trouble of hunting for your files later.
4. Check the field labeled what to write in the file of type field. You really ought to make sure it's set to Word Document (*.doc)
5. Go ahead and open Tools, then hit Options, move over to the Save tab, and verify that under "Save Word files as," it's also set to Word Document (*.doc)

6. Now, look, if you're just making edits to an existing file and you hit save, the document stays put and those changes are locked in. But if you haven't actually saved the progress and you just go ahead and click the X, everything you did is gone—poof.
If you're messing around with spreadsheets: just click on the cell where you want the text to go, head over to the Layout tab, find the Orientation button, and pick one of those three text directions.
Look, I don't see why we need to make things so damn complicated.
If you just take a second to format those cells where you're punching in the times—say, set them to h:mm first—then a basic SUM function will work perfectly fine. It’s not rocket science.
It’s like when you’re getting dressed in the morning; if you button the very first button on your shirt wrong, the whole thing is going to be crooked and look like a mess all day long.
1. Look, if you want this formula to actually function, you need to have the right converter enabled in your Add-ins. Here’s what you do: go to Tools, then Add-ins, find the Analysis ToolPak, check that box, and hit OK.

2. Honestly, just try running those time calculations on a fresh Sheet like people have been telling you to do. Once you've done that, make sure you format your cells as h:mm, and for the cell holding your final result, use the [h]:mm format. It works perfectly fine on my machine. Seriously... good luck with that mess!
restlessdrifter12 said:Is there some way in Excel to turn every one of those numbers into seconds?
Like, if I have 03:20, I want it to show up as 200 sec so I can just sum everything up without losing my mind.

Look, if you’ve got 03:20 sitting in cell A1, just pop this formula into B1 and see what happens: =CONVERT(A1;"mn";"sec")*24

Here's the breakdown:
"yr" is year; "day" is day; "hr" is hour; "mn" is minute; and "sec" is second.
restlessdrifter12 said:So, I was sitting there earlier, staring at my screen, just grinding through some data entry—you know how it is when you're deep in the weeds with a massive spreadsheet. I decided to go old school. Instead of letting the software do all the heavy lifting, I started manually typing out the formulas myself. Just me, the keyboard, and a whole lot of patience. And honestly? It’s infuriating. There’s something about that manual process that just sets my nerves on edge. You think you’ve got it perfect, you hit Enter, and suddenly everything breaks because of one tiny, microscopic typo. It feels like a complete waste of mental energy, yet here I am, doing it anyway, probably because I don't fully trust the automation to catch the nuance I'm looking for. It’s a bit like trying to fix a car engine with a toothpick when you have a full toolkit sitting right next to you. You know better, but you do it anyway. It’s maddening. I was staring at my screen for way too long this morning—probably shouldn't have had that third cup of coffee before starting the audit—and I found myself staring blankly at a massive spreadsheet. You know those days where even the simplest task feels like you're trying to solve a Rubik's Cube in the dark? Anyway, I was looking at this specific range, just trying to get the total for everything from row 4 down to row 88. It’s one of those basic things, really. Just `=SUM(E4:E88)`. Simple enough, right? But then I started thinking about how much time we waste on manual entry when these formulas exist. My old boss back in Chicago used to drive me absolutely insane because he wouldn't trust the software, insisted on doing everything by hand. Absolute madness. But yeah, that's the formula. Just a straightforward sum. Nothing fancy. The results are finally coming in. 0:00

Look, if you’re absolutely hell-bent on making sure that specific cell—E89, for those following along—actually pulls the calculation you're looking for, then fine. If that’s how you want to play it, just go ahead and plug this formula directly into E89:

So, you take this formula: =IF(E4:E88="", "", SUM(E4:E88)). But here’s the thing—it won't just work if you lazily hit Enter like most people do. You have to be precise. You need to hit Ctrl + Shift + enter. If you don't, the whole thing falls apart. Once you actually do it right, the formula transforms into something that looks like this:
I was staring at my screen this morning, nursing a lukewarm cup of coffee and trying to make sense of this mess, when I realized how much time we waste on manual data entry. It’s maddening. Truly. You spend hours clicking through cells only to realize the math is off because of one stray typo. I’ve been tinkering with this little formula lately: {=IF(E4:E88="";"";SUM(E4:E88))}. It’s a simple enough logic—essentially telling Google Sheets to look at a specific range and, if there's nothing there, just leave it blank instead of cluttering the view with zeros or errors. If there *is* data, then go ahead and give me that sum. It keeps things clean. It keeps things tidy. And honestly, in a world where everything feels like it's falling apart, I'll take a little bit of organized digital space whenever I can get it. Why does anyone still do this manually? I saw a guy at the office yesterday—total dinosaur—trying to add up an entire column using a handheld calculator. A calculator! I almost lost my mind right then and there. We have tools for this. We actually have them. Use the logic, save the headache. It's not rocket science, though sometimes it feels like it when you're dealing with poorly structured spreadsheets.
Charles Cox60 said:but can you actually list out every single combination?

How about this: Put the numbers 1 through 20 in column A, then go into cell B1 and drop in this formula: =IF(A1=1;"";COMBIN(A1;2)). Once that's set, just drag the formula down from B1 all the way to B20.
Arthur Ramirez20 said:I was wondering how to skip the title page when setting up page numbering?

Just go to Insert, then Page Numbers, and make sure you uncheck "Show numbers on first page."
restlessheron19 said:I'm looking for a formula that would...
make the cell next to a zero empty

Just pop this formula into B1: =IF(A1=0,"",A1). Look, here’s how that works in plain English: if there's a zero sitting in A1, then B1 shows up blank. If it’s anything else, B1 just grabs whatever value is in A1. Once you drag that formula down the rest of column B, it’ll go through the whole list and clear out every cell in column B whenever it hits a zero in column A. Simple enough, right?
restlessheron19 said:Yeah, that might help... Thanks!

Look, what I was getting at regarding hiding those values—that was specifically about locking down the formula bar and protecting your data so nobody can just mess with it. If you actually want the numbers themselves to be invisible to the naked eye, there are two ways to go about it:
1. Just hide the columns entirely (go to Format, then Cells, then Columns, and hit Hide—you can always bring them back later with Unhide) and
2. You could select the actual numbers or expressions in the cells and just change the font color to white.
Hopefully, one of those does the trick for you.

(I was rushing through my last reply because I was pressed for time.)
Maybe this will get you moving in the right direction:

So, here’s the deal. You’re going to use cell A1 as your little control switch—just type in a 2 or a 3 there. Then, you've got your data sitting in columns B and C, which you want to see show up over in column D. To make that happen, go ahead and pop this formula into D1: =IF($A$1=2;B🙂;IF($A$1=3;C:C;"")). Once you've done that, just grab the corner and drag it down to cover all the rows you have in B and C. Simple enough, right?

Basically, once you toggle that number in A1 to a 2, column D starts pulling everything from column B. It works just like that.

If you don't want all those messy source numbers cluttering up your view, you can just hide them.🙏 Just select the columns, head over to the menu, find Protection, and make sure you check the box next to Hidden, then hit OK.
Dana Diaz8 said:Hey, I was hoping someone could help me out with something pretty basic tonight.

Give this a shot: Say you have numbers ranging from 0 to 360 typed into A2, then just pop this formula into cell A1:

=IF(AND(A2>0;A290;A2180;A2
There are probably more elegant ways to handle this, honestly.
Peter Hill4 said:=VALUE(INT((C5*1.1)*1.22)+IF(((C5*1.1)*1.22)-INT((C5*1.1)*1.22)

Look, you need to swap those symbols. For the div>
I don't even know where to begin with this one. It’s just... it's a lot. I was sitting here, staring at my monitor, trying to make sense of some data, and I realized how much time we waste on things that shouldn't even be complicated in the first place. You know what I mean? It’s like when you’re driving down a highway in Chicago and suddenly someone decides to merge without looking—just total chaos for no reason. That's what most of these discussions feel like lately. Just aimless. Anyway, I'm here. I'm around. Let's see if we can actually get something useful out of this. [User Name] says:
So, I was staring at my screen for way too long this morning—probably should have grabbed another coffee before diving into this mess—and I realized I’ve been wrestling with a formatting nightmare in Microsoft Word. It’s one of those things that feels like it should be simple, right? Just a click and you're done. But no. Life isn't that easy. I'm trying to figure out how to flip a table on its head—you know, taking it from landscape orientation to portrait, or vice versa. Basically, transposing the whole thing. If you're stuck in that same loop of frustration, here’s the deal. Word doesn't actually have a "transpose" button built directly into the table tools like Microsoft Excel does. Yeah, I know. It’s infuriating. You'd think after all these years of software development, they'd add a single button for this, but apparently not. The workaround—and honestly, the only sane way to do it without losing your mind—is to play a little game of musical chairs with Microsoft Excel. Here is what you do: First, highlight your entire table in Word and just copy it. Simple enough. Then, open up a blank Microsoft Excel spreadsheet. Paste your data there. Once it's sitting in the cells, select the range again and hit copy. Now, this is the crucial part: don't just paste it back. Go to a new spot in the spreadsheet, right-click, and look for the "Paste Special" options. You're looking for the icon that says "Transpose." Click that, and boom—your rows are now columns and your columns are rows. Once it looks the way you want in Excel, just copy that newly flipped table and paste it right back into your Word document. It’s a bit of a dance, a bit of a hassle, and frankly, a waste of perfectly good keystrokes, but it works. It beats trying to manually move every single cell one by one. I tried doing it manually once back when I was working on a massive report for a client in Chicago, and let me tell you, I nearly threw my laptop out the window. Don't be like me. Use the Excel trick.

So, here’s how you flip it from vertical to horizontal:

Alright, so here’s how you get started. First, just open up a blank Microsoft Word document. Once that's sitting there on your screen, go ahead and use the Drawing tool to sketch out a text box. Once you've got that box placed where you want it, just right-click right inside the frame, and then select Add text. That's really all there is to it for this step.
So, here’s the thing. You want to flip that table into a horizontal layout? Fine. First, you grab the table you’re working with and just copy the whole thing. Then, you open up a fresh, empty spreadsheet—just a blank canvas, really—click right into the area where you want it to go, and hit Paste. Now, pay attention, because this is where people usually trip up and lose their minds. Once it's pasted, you need to right-click on that frame, head into "format AutoShape...", then navigate over to "color and Lines." From there, you’re going to hunt down the white color option and hit OK. That’s the trick. That’s how you hide the frame entirely. It’s a bit of a workaround, I know, but sometimes you just have to bend things to your will to get the result you actually want.
Right-click on the border again, then hit Paste. Simple enough, right? Or at least, that’s what they tell you in those overly polished tutorials that never seem to account for how temperamental this software actually is. Honestly, sometimes I feel like I spend more time fighting with the interface than actually getting any real work done. Just click the border, right-click, paste. Don't overthink it.
Alright, let's get things moving. First thing you need to do is open up a completely fresh spreadsheet. Once that's up, go ahead and flip the orientation to landscape. I usually set my margins to about 0.4 inches—just enough breathing room, you know? Set that, hit OK, and we’re ready to roll.
So, I was looking at this new spreadsheet earlier—just one of those things where you think you've got a handle on the workflow, right? Anyway, here’s the drill if you want to get it right: You hit Edit, then go ahead and do a Paste Special, select the Picture (GIF), and just click OK. Simple enough, I guess. Or so they tell you.
So, here’s how you handle it. You take your cursor and hover it right over that little green circle sitting just above the frame. Once you hit it, the icon should flip into this circular arrow. Give it a left-click and just rotate it ninety degrees to the left. Boom—there’s your table, rotated. It might need a tiny bit of extra tweaking to get everything looking perfect, but once you dial that in, you're done. Simple enough, right? Even if it feels like these programs make the simplest tasks feel like a chore sometimes.
Raymond Collins18 said:Walter Jackson48, thanks, but I don't think this is actually working right.

Look, there’s a chance you might still be running that first formula I sent over—the one where I used the range A1:A6 during my initial testing. I had to go back and tweak things later on to expand the scope to A1:A50. I just finished inputting some new values from A43 through A50, and sure enough, it's correctly summing up those last four numbers now.
Henry Lewis37 said:Well, thanks a lot, everyone...

I’m glad I could help you out, really, but I just can’t wrap my head around why you’re still insisting that Forest's corrected formula isn't working. It’s simple logic—you can’t just plug it into F27; it has to go in G27. Just a little more persistence here would go a long way...