One way you could tackle this is by adding a helper column—let's say Column I. In cell I1, you’d plug in this formula: =IF(AND(E1:E10=1;H1:H10=3);1;""), then just drag that formula down to I10. After that, pop this into I11: =COUNTIF(I1:I10;"1"). There are probably much more elegant ways to handle this, honestly.
(Sorry, I'm a bit late to the party here. I didn't catch your solution earlier.)
Laura Thomas28 said:How on earth do I make this vertical line in Word???
Look, I might have a solution for you if you're struggling: Go to Format, hit Columns, and set your page layout to two columns—you know, like a standard newspaper setup. Once you've got that, just grab the Drawing tool, pick the Line option, and simply draw a vertical line right down the middle of the sheet. It’s not rocket science, really.
velvetviper22 said:Hey there! I've got a bit of a situation with Word. I dropped a text box into my document, but now I'm stuck—for some reason, I can't change the font at all! It's just completely unresponsive. Anyone know how to fix this??
Are we talking about the style or the actual size? And does it actually look wrong when you print it out on paper?
Dennis Sanchez84 said:I have a quick question regarding Word.
You know, if you're looking to get your Table of Contents to actually line up with those page numbers—without everything looking like a total mess—you can also handle it this way:
First you handle the formatting, then you hit the Tabs, and finally, you just put it right into the field. I’ve been staring at my screen for forty minutes now, just absolutely losing my mind over this one tiny, insignificant setting. It’s the tab stop position. You’d think, wouldn't you, that after decades of software evolution, something as fundamental as where a cursor lands would be intuitive? But no. I was sitting here in my home office—coffee gone cold, by the way, which is just my luck today—trying to format a simple memo. I thought, "How hard can it be? Just hit the tab key." Well, apparently, I was wrong. Big time. Every time I try to align these columns, the cursor jumps around like it’s got a mind of its most chaotic self. It’s maddening. It feels like I'm fighting the software rather than using it. It reminds me of that time I tried to reorganize my entire garage last summer. I had everything planned out, perfectly aligned, only to realize halfway through that I hadn't accounted for the clearance on the heavy shelving units. Total chaos. Same thing here. You think you have control over the layout, and then one little misplaced setting sends the whole document spiraling into an unreadable mess. Is anyone else dealing with this level of frustration, or am I just losing my grip? I feel like I'm pulling my hair out trying to get these indentations to behave. It shouldn't be this much work to make a page look professional. Just type the number you want—say, number 20—into the cell where you want the page count to show up. Then, move over to the input field... Alignment. It’s funny, isn't it? How one little word can cause such a massive headache when you're staring at a screen at two in the morning. I was sitting here, nursing a lukewarm cup of coffee—the kind that tastes more like burnt beans than actual breakfast—just trying to get my columns to behave. You know that feeling? That specific, rising heat in your chest when the software just refuses to cooperate with your vision? I spent nearly forty minutes wrestling with some formatting issues. Forty minutes! I could have driven halfway to Chicago in that time. Every time I thought I had the cells lined up perfectly, something would shift. A margin would jump, a border would vanish, and suddenly the whole layout looked like a disaster zone. It's maddening. Truly. It feels less like using a tool and more like an argument with a brick wall. Anyway, I suppose I'm rambling. I just needed to vent about the sheer frustration of it all. Has anyone else been stuck in this loop lately, or am I just losing my mind over a few misplaced pixels? Check the alignment before you hit Left, then make sure it's actually set within the field itself. Leader Take a look at what's sitting right there in front of the number. Just check it. 2.... Then you just go ahead and click on... I suppose I should start by saying that setting things up properly from the get-go is half the battle, though God knows most people just dive in headfirst without a single thought for the long-term consequences. It’s like when I was trying to reorganize my entire home office last summer—just a complete disaster zone because I didn't have a plan. I spent three days moving heavy oak desks around only to realize I hadn't even accounted for the power outlets. Absolute madness. Anyway, regarding the setup... you can't just wing it. If you aren't meticulous about how you structure your initial parameters, you're basically asking for a headache down the road. I've seen too many folks try to cut corners, thinking they're being efficient, when in reality, they're just building a house of cards. You need to be deliberate. Take your time. It might feel slow at first, but believe me, the frustration of having to redo everything twice is much, much worse than just doing it right the first time. It's common sense, really, though I know common sense isn't exactly a widespread commodity these days.Alright, fine. Let’s get down to business. Here is how you handle it: you type in your first heading, then hit that Tab key on your keyboard—you know, the one with those two arrows pointing in opposite directions? It’ll spit out those little dots for you. Once those dots show up, just punch in the page number and hit Enter. Then, you just move on to the next heading, hit Tab again, type the page number, and keep repeating that whole cycle until you've finished the entire document. Now, look, I’m basing this on the old version from back in the day, but honestly, most versions should work pretty much the same way. Best regards.
granitepilot342 said:I found that "Error Bars" option with the standard deviation setting, but when I actually apply it, the software just slaps the exact same value onto all three columns. That’s not what I need. I need them to be distinct—each column needs its own specific deviation—but for some reason, I can't seem to decouple them. It's incredibly frustrating.
Look, what I’m about to say here is pure speculation—I don't claim to have all the answers and I certainly don't want anyone taking this as gospel—but I'm putting it out there simply because I want to be helpful: So, I was looking back at that mess from earlier... specifically that second step within the Wizard in the field. It’s just one of those things that seems straightforward until you actually sit down to do it, right? You think you have a handle on the workflow, and then—bam—everything goes sideways because of some tiny setting or a menu that doesn't behave. Honestly, it's enough to make you want to throw the whole computer out the window. Anyway, I'm trying to wrap my head around the logic there. Series in Check before you proceed. Seriously. Just... take a second to look ahead first. ColumnsSo, here’s an idea—and I'm just thinking out loud here, mind you. If you manage to get those bars in different colors—you know, like three separate series—then you might actually be able to manipulate them individually. Once you've got that set up, just try running through the exact same steps you were taking before. It's a long shot, I know, but maybe... just maybe... it'll actually work?
George Fox23 said:thanks a lot now I just have to figure out what they actually did
Those of us who go out of our way to help others... we really appreciate it when the person asking the question actually lets us know if the answer worked. A good fix should be useful to everyone else reading the thread. But instead, people solve their issues and then just go silent leaving everyone else in the dark about how it was fixed. Honestly, at this rate, we might just have to start keeping a blacklist of people who never acknowledge a solution, and then we won't bother helping them next time.
George Fox23 said:I have to divide that number by 97.
That number 97 always makes me think of calculating a checksum for some kind of security code, so, well, if that's what you're dealing with, this might actually be useful for you: http://www.elitesecurity.org/t383093-0 just grab the file attached by @neptuncokg from November 30th, 2009.
Let me see if I can weigh in here and help out: In step 6, you actually need to click inside the specific area—like the Header, for instance—wherever you want that page number to show up. Once you're there, look for that "Link to Previos" icon and click it; you have to do this to get rid of that "Same as Previous" setting. After that, move straight to step 7. All you really have to do is hit the first icon in the floating menu labeled "Insert Page number," and boom, it should display page 5 right where you want it. From there, just hit Close. That’s it. You're done. Honestly, you don't even need to bother with steps 8 or 9.
Look, guys, there’s really no need for all this arguing. Someone asks a question, we provide our takes—even if we don't all agree on the specifics—and then we just let them decide which solution actually works for them. Let them figure it out.
Alright, here’s another one for you to chew on, take it or leave it: First off, go ahead and set up your content just like we discussed—or however you’ve already laid it out—using headers like A, B, C, and so on. Then, somewhere near the top of your document, create a little index table. Personally, I’m a big fan of tables (though they aren't strictly mandatory), and you'll use this to list out the alphabet. Now, follow these steps carefully: Let's say you want to link to the letter A. Go down to your index of names where all the last names starting with A are listed. Highlight that specific letter "A," head over to the Insert tab, click on >, and in the > field, just type "A" and hit Add. Once that's done, jump back up to that little index table you made at the start. Highlight the letter A there, go to Insert again, select >, choose "Place in this document" on the left side, and then pick that "A" you just created from the > list on the right. Hit OK. Just repeat that whole tedious process for every other letter in the alphabet. (By the way, once you're done, that "A" in your index table should show up underlined). If everything worked correctly, clicking that "A" in your index table and hitting Ctrl+Enter should zip you straight down to the actual section for A.
Look, you might be dealing with a document split into different sections—you’ll know this is happening if you open up the header and footer and start scrolling through the whole thing. It sounds like page 21 is actually tethered to the previous section, essentially acting like it belongs to those earlier pages. If that's the case, try going to page 21 and toggling off the "Link to Previous" setting. Alternatively, you could just grab pages 21 through 25 and force them into their own distinct section. I found this link, which might clear things up for you if you're stuck:
Jesse Sullivan2 said:Every time I type 4.94 into Microsoft Excel, it keeps switching it to 4,94.
I mean, why on earth are you typing 4.94 anyway? Just use a comma—4,94. And look, if you absolutely insist on using a period for some reason, then just format the cell properly like people have already told you to do.
Robert Hughes7 said:Good grief! Do you happen to know where that setting actually lives? I'm running the American version here, so everything looks a bit different. 🙄
frozenraven10 said:Thanks a ton! Now I'm hitting another wall here. I'm trying to get a function to count how many specific conditions have actually been met. I tried sketching out something like this:
=COUNT(IF(U22>W22;IF(W26>U26;IF(U30>W30😉))) but it's just not working...
Do you happen to know—or maybe someone else on here does—how I can pull this off?
Look, the IF function (the questioner) works like this: If a certain condition is met, do this; if it isn't, do something else (or ask again).
driftingpilot8 said:Thanks, but even the basic IF(A1=B1;1;2) logic seems broken right out of the gate.
Look, here is how you actually do it. Type "Mark" in cell A1 and "Mark" in B1—C1 should spit out a 1. Then, try typing "Mark" in A2 and "Ivan" in B2, and you'll see C2 gives you a 2. And please, for heaven's sake, don't forget to put the equals sign at the start of the formula, and make sure you're using semicolons to separate your arguments in the formula.
Go ahead and head over to the Design tab, then look for Bullets and Numbering, click on Bullets, and just pick the dash style there. Easy enough. That’s really all there is to it. (Mind you, I'm talking about the 2003 version here)
If you go ahead and type some names into columns A and B—doesn't matter if they match or if they're totally different—just pop this formula into C1: =IF(A1=B1;1;2). After that, click on C1, head over to Insert, then Conditional Formatting, and in the "Cells is" field, just type in =A1<>B1. Pick whatever color you want for the highlight, then hit OK. Once that's set, fill out columns A and B down to, say, row 15, and then just "drag" (copy) that C1 cell down to C15. What you'll end up with is a setup where column C shows a 1 whenever the names in A and B are identical, and a red 2 whenever they don't match.