Posts by Walter Jackson48

Maybe try swapping out the keyboard. Borrow a working one from someone—just to rule out the hardware—or grab a different cable while you're at it.

Bradley Murphy56 said:=IF(D39:D40=7;ROUNDUP(AS40/12;0);ROUNDDOWN(AS40/12;0))
HELP ME HERE

Try rewriting the first part of your formula—you know, that bit where you have =IF(D39:D40=7...—maybe try using =IF(SUM(D39:D40)=7... or even just a simple =IF(D39+D40=7...
and
for heaven's sake, when you're posting formulas in the future, please turn off those emojis. It makes things unreadable.

Try this: save the document directly onto the USB drive, but don't you dare pull the stick out before you attempt to open that file right then and there. Does the same glitch happen under those conditions? And I'm also wondering—does this exact same nonsense occur if you save a document onto that same thumb drive using a completely different computer?

Angela Ramirez4 said:Hey there,

I'm trying to figure out how to write a function for this specific issue...

"if E20 is between 2008 and 2013, and if E21 is between 1401 and 2000, then set E24 = H7"
Thanks.

So, if we plug this formula right into cell E24:

=IF(AND(E20>=2008,E20=1401,E21
Is that actually what you're looking for?

Look, there’s actually an easier way to handle this if you just take a second to breathe:
First, go into your Excel Options and set your separators exactly how you want them. Once that's sorted, when you have your spreadsheet open, look up in the toolbar—you'll see that little icon for Comma style. Just click into whatever cell you're working on, hit that button, and boom, the cell is formatted. You type your number in, and it'll snap right into the format you picked. And hey, if you want to be efficient, just hold down the Ctrl key to grab a few different cells at once and apply it all in one go.
Actually, if you really want to save time—and I know I hate wasting clicks—just hit Ctrl+A to select every single number on the entire sheet, click that Comma style icon, and the whole thing updates instantly. Easy as that.

Until someone comes up with a more elegant way to handle this mess, maybe this little workaround will stop the headache:
open up an Excel sheet and just click that little arrow button sitting right to the left of column A—you know, the one above row 1—to select the entire Sheet. Once everything is highlighted, pick whatever number format you actually want. That way, every single number you type in follows that rule automatically. Now, I suppose the real nuisance starts if you suddenly decide you need some cells to show whole numbers instead...

Go to the Control Panel, then head over to Regional and Language Options, and finally hit Customize...

Just take that chart you generated and stretch it out—I mean, really pull it wide so you can actually see what’s happening. You'll notice all twelve Roman numerals cluttering up the X-axis. It’s exactly what Kyle Johnson2 was getting at earlier: you've essentially fed the system twelve values multiple times over. If you toggle the data labels on the chart, the mess becomes even more obvious. Look, my previous suggestion about typing in those Roman numerals manually? That was just one way to input them, but let's be honest, it isn't going to give you an accurate result.

Honestly, I’d almost say you’re trying to solve an impossible puzzle if you keep going this way. It doesn't make sense. You should be comparing yearly performance within a single twelve-month window, not stretching it across twenty-four months by smashing two separate years into one giant table. Here is how I tackled it:

http://www.datafilehost.com/d/30c44580

Now, try comparing the curve behavior for, say, 2001. against the year 2001a and so on. If you want to get fancy, you can always insert a helper column right before your year column to add extra identifiers or labels.

Best regards,

Look, until someone comes along with a more elegant way to handle this, if you're in a massive rush, you can just manually force those Roman numerals under the X-axis by doing this: (first, go ahead and right-click those three Roman numerals you currently have and just delete them)
Click once on the chart itself, then head up to the menu bar and grab the Layout tab. From there, look for Axis Titles, click the little dropdown arrow next to Primary Horizontal Axis Title, and choose Title Below Axis. You'll see a placeholder appearing down below the X-axis that looks like Axis Title. Just right-click that bit, select EDIT text, and type in your Roman numerals manually. I’d suggest leaving about six spaces between each number just to keep things readable.

You still haven't actually answered my question about whether the chart is supposed to look exactly like the one I attached. If that's the case, then just scrap your version entirely and start over from scratch following my specific instructions. Honestly, I was just as much of a novice when I first tackled this as you are right now.

If this is actually what you were looking for...
http://www.datafilehost.com/d/ad9de56b, then here is how it turns out:

First, highlight all the numbers in Table "A"—just make sure you skip the years and those Roman numerals—and turn them into a line chart (I assume you already know how to do that part);
Then, right-click anywhere on the chart area and open up . This is where you’ll input the data for both Tables A and B. Just hit the "Add" button, type "=A" in the first field, and then manually select the rows from that first table one by one (again, leave out the years and the Roman numerals). You’ll need to repeat this exact process for the second table too (though I gather you're already familiar with that step).
Once you've finished entering everything, you'll see a bunch of numbers like 1, 2, ... appearing along the
. Now, go ahead and right-click the chart again and head back into . Pay close attention here:
Look over to the right side where those numbers 1, 2, ... are listed vertically and click . When you hit , an window will pop up. In that box, just select the Roman numerals from your first table—for instance, selecting the range C2:N2 in your specific sheet. There. That should do the trick.
p.s. If you want to clean things up, you can use the "Remove" button in the menu to get rid of , , etc., so that only Series A and B are left standing.

Can anyone make sense of this link?

Is this more or less what you're looking for?
http://www.datafilehost.com/d/454d572b

If this hits the mark, just set up your table exactly like the one I've attached. Once you've generated the chart, go ahead and type Year into cell A1.

Sam Peterson6 said:I need to draw two circles in Word 2003 at very specific positions on an A4 sheet, and I have no clue how to pull this off. Any help would be appreciated.

First things first, let's set the margins. Set Top=2 and Botton=2. Once that's done, you need to enable the Drawing tool—go to View, then Tools, and check the box next to Drawing; that should pop it up in your toolbar down below. Now, grab the ellipse shape tool and just click-and-drag along the top margin line using your left mouse button. Right-click that ellipse, and a context menu will pop up; select Format AutoShape. On that tab, go to Size and type "12 cm" into both the height and width fields. (There, you've got yourself a circle with a 12 cm diameter). Then, staying on that same card, head over to Layout, check the box for Center, and that’ll snap your circle right into the middle of the page. Easy enough, right?
Now, you repeat the whole process for the inner circle, but with a slight tweak: open Format AutoShape again and set the dimensions to 4 cm (just like before), but this time, under Layout, go to Advanced. There, you can set the Horizontal absolute position to 6 cm in Column (right), and the Vertical absolute position to 3 in Line (right). Just make sure you check the box for Other or Center, alright?
And there you have it—two concentric circles with exact dimensions. If you want to move them, just hold down the CTRL key to select both, hit Copy and Paste, and then just drag them down toward the bottom of the page.
But wait, how do you actually know if your circle is sitting exactly on the top or bottom margin?
Go back to Tools, then View, and check the box for Text boundaries. That'll draw a little frame showing you exactly where your workspace ends and your margins begin. Align your circles against those boundaries, and once you're satisfied, just uncheck Text boundaries to hide the frame again.
As for reading the margin values on the ruler? Hold down the Alt key and hover your cursor over the ruler right where the blue and gray colors meet (that's your margin boundary). When the cursor turns into a double arrow, click your left mouse button while still holding Alt, and it'll show you the margin value. You can even drag it around with the mouse to adjust it on the fly.
It's a bit of a long-winded explanation, I know, but I'm pretty sure it'll get the job done.

Benjamin Wilson7 said:Clicking around is just exhausting, honestly. Using ALT + TAB isn't. It makes switching between open windows feel effortless.

Let @casualbear17/">@@casualbear17 pick whatever she prefers.

So, let's say you’ve got two documents open—maybe even more, if you're the type who likes to clutter things up like I do—and you go ahead and minimize them down to the taskbar. You hit that Minimize button, and they're just sitting there. Now, here's where you have to be careful. You right-click on an empty spot on the taskbar, then navigate to the specific card for the window you're looking at, and click on... Arrange the windows vertically, one on top of the other..

@Walter Jackson48/">@@Walter Jackson48 said, "...2x Text Box...", so you might as well listen to him.
What I mean is, just go ahead and drop another Text Box right inside the first one, and make sure it’s exactly 30 mm wide.

So, let's say you plug some numbers—say, anything from 1 to 10—into cells A1 through J1. Then, over in B2
, you drop in this formula: =SUM(A1:J1)/10 (or whatever specific math you need to find an average or an optimum based on that first row of data). After that, you put this in B2: =A2. Once that's set, just grab B2 and drag it across all the way to J2.
Next, you head over to the chart types and pick something like a Line with Marks. What happens? You get this line tracing the values from 1 to 10, and then this perfectly flat line sitting right at 5.5.
The cool part—or the part that actually works—is that when you start messing with those initial values in the top row, the second row updates automatically, and the chart follows suit. Everything shifts in real-time.
That’s basically what I’ve come up with so far. I’m sure there are much more sophisticated ways to handle this, but this gets the job done for now.

Jacob Bennett6 said:I'm having some trouble with Excel, could someone please help me out?

Give this a shot, maybe it'll solve your headache:

1. Select E1, go to Format, then Conditional Formatting, pick Formula Is, and type this into the box:
=ISTEXT(A1), Format (pick whatever color you want), OK, OK
2. In E2, type in this formula: =AND(ISTEXT(A2);ISTEXT(B2)), then hit Format (set your color), OK, OK.
3. Repeat that exact process for A3, B3, and C3, as well as for
4. A4, B4, C4, and D4.

Basically, if you type some text (let's say "X") into A1, E1 will change to the color you picked in step one. If you put that "X" in both A2 and B2, then E2 triggers the color from step two, and so on. It's just logic, really.

Or maybe just use Adobe Reader