Posts by Nicholas King

Assumptions:

- Your data range covers A1 through B13;
- Cell D1 holds your lower limit;
- Cell E1 holds your upper limit;

- You want the results to start printing at A14

Cell A14: =VLOOKUP($D$1;$A$1:$B$13;2;FALSE)
Cell A15: =IF($D$1+ROW()-14>$E$1;"";VLOOKUP($D$1+ROW()-14;$A$1:$B$13;2;FALSE))

The parts highlighted in red are the ones you—well, you absolutely have to change depending on where your actual data is located in your spreadsheet.

Just grab cell A15 and drag it down as far as you need it to go, and that should be about it.

Benjamin Wilson7 said:Just to give you a quick rundown—this issue can be handled by either of these two formulas (though honestly, just the second one might suffice):

With this particular workaround, you’re essentially copying over the input data, except you aren't outputting anything where the criteria don't match. So, I guess you end up with a whole lot of empty rows.

BTW, the formula itself doesn't actually output "every number"—it really just pulls through A1 and B1, if anything at all.

Gregory Rogers20 said:Well, I guess I wasn't being clear enough.

You're still not being clear enough. 🙂

- Are we looking at actual data here, or is this just some random example you pulled out of thin air—if it's an example, maybe you could at least describe what the real data looks like?

- Are the values in column A unique?

- Are they immutable?

- Have they been sorted?

- As for the data in column B—is it sorted, fixed, or unique?

And so on. 😁

Jose Doyle5 said:Is there even a way to turn this annoying feature off—if it's even an option at all?

Actually, you need to enable the setting. 🙂

Go to Tools->Options->Edit and check the box for "Typing replaces selection".

cosmicbison19 said:Does anyone happen to know if there's a formula to sum up all the cells in a column that are colored—say, red—(I mean the cell fill color, not the font color)?

thanks

From what I gather—and I could be wrong here—you can't really pull that off without some actual programming.

Jacob Foster11 said:Basically, there isn't any sort of "systematic logging of forum transgressions" or any other such nonsense going on. 🙄

That all sounds fine and dandy, I suppose, but don't you think this is getting a little out of hand:



I mean, what's next???

😬

Lawrence Barnes64 said:and I was thinking $67 maybe even 300...

How much skill are we actually talking about here?

If you aren't capable of putting together a clean presentation—one that doesn't look like those tacky, over-designed corporate templates everyone hates—then honestly, it might be better not to bother making one at all for $133 (say, maybe thirty decent slides) rather than trying to churn out 150.

I mean, if this is your actual livelihood, then I suppose that changes the math entirely...

restlessheron19 said:I could really use some advice here...

One word: Access. Or, if you want to get fancy: linking Access to Excel.

What you’re describing—if I’m reading this correctly—is essentially just a small-scale database used for generating reports.

Sarah Brown86 said:How do I go about this:
Write a VBA program for Microsoft Word that prints a sequential number and your full name over 20 lines.

Do the exact same thing using VBA in Microsoft Excel, but set it up so column A holds the sequence number, column B holds your last name, and column C holds your first name.

Post your attempt at a solution—that way people can actually see what's going wrong.

silentlynx24 said:Is there any way I can install additional languages for the spelling and grammar options in Word 2003 after the fact? Right now, German and American aren't supported... can I just add them later, or am I stuck having to hunt down a better version of Word???

Look, you don't need to go out and grab a whole new version of Word just to get more language support.

BTW, did you even notice there's a specific thread at the top for Office questions? 😁

Rebecca Barrett98 said:So, let me get this straight—my comment can be unpopular with someone else (without even containing an ounce of offensive language) and that’s enough reason for them to report me for "disruptive posting"?

Well, "someone else" might also take issue with your haircut (depending on how much of a fashion snob they are 😁) and report you for being messy too—but the real point here is that filing a report doesn't mean you're automatically punished.

The moderators are the ones who decide whether to delete things, issue warnings, or hand out bans.

Susan Price30 said:Who exactly is saying that?

I am.

view

look, for me, ever since I signed up, that has never happened—it's never said Welcome, it just says Hey G...!😁

So, you basically don't believe a single thing unless it happens to you personally? 😕

WTF, am I lying? Am I just making stuff up here?

William Fisher26 said:Obviously, I know this isn't a democracy. However, I had no idea advocacy was banned—Tvuku could have just told me that directly instead of dragging out an argument and making me think it was allowed.
I haven't spent my life studying the PŽK rules until today—as strange as that may seem to you.

It isn't particularly shocking to me that you haven't studied them until now (to be fair, I wasn't exactly an expert either 😁) — what strikes me as odd, though, is that after getting hit by a ban, your first instinct is to ask "where is this written?" instead of checking the most obvious, logical place where those rules would actually be posted.

William Fisher26 said:It’s great how you managed to pull that out after we spent the entire day debating—only for those fanatics to Ban me and strip 500 points because of it.

It is curious that there aren't any rules governing admin oversight—or any semblance of accountability for them, for that matter.
They aren't sitting in Congress—they don't have immunity. I don't get it.

I didn't exactly "pull anything" out of thin air—I was simply answering the question, "Where does it say that playing lawyer is prohibited?" Since this was being asked by someone with a pretty decent post count, I figured I’d actually go and check to see if it was possible that—get this—it wasn't explicitly stated in the Reddit Code of Conduct.

It’s actually pretty fascinating—if you think about it—that there aren't any actual rules in place to oversee how the administration operates, or even some semblance of accountability for what they do. I mean, it's almost strange, isn't it? There seems to be absolutely nothing governing their actions or holding them responsible for their decisions. I guess it just goes to show how much unchecked power is sitting right there.
They aren't even sitting in Congress to have legislative immunity. I just don't get it—it makes absolutely no sense.

Of course there’s surveillance—and of course there’s accountability. It really isn't that complicated. They are responsible for every single cent of taxpayer money you’ve funneled into their operations. Simple as that.

I’m not trying to get dragged into this specific feud—honestly, I really am not—but I find it incredibly bizarre that someone who wasn't even around on the Reddit yesterday is suddenly preaching about parliamentary democracy and acting shocked that it doesn't exist here. It’s just... odd, I guess.

William Fisher26 said:I don't follow—what exactly did the mod send you? A request for me to ban you, or to lift my own?
Why was I even banned in the first place?
Where in the rules does it state that "advocating" is prohibited or grounds for a ban? And why wasn't everyone else who commented on the ZMM's ban penalized?
Why aren't the game rules clearly written so we actually know how to behave?
Why aren't you being held accountable?
Who is monitoring you?

Where is Tvuku? Why the silence?
There should be consequences for this mess regarding my ban. He essentially tricked me into starting a thread about a forbidden topic. Why wasn't I given a warning?

Actually, you do have the rules of the game.

cosmicskipper39 said:Look, I get it. Mods aren't obligated to sit there and explain every single ban or why someone's post got nuked. They don't owe us an itemized receipt for every decision. But honestly? This constant, excessive power tripping over some guy asking a clumsy question? It’s useless. It doesn't lead anywhere. It just makes everything tense for no reason.

I’ve started threads like that on Reddit before too. Don't you remember? 🙂

Look, the only silver lining here is that you actually managed to learn something from all this chaos. Now, maybe you can take that knowledge and share it with the ladies over on the Recreation subreddit—you know, that peaceful little corner of the internet where people actually try to be nice. 👍

If I ever decide to sit down and write my memoirs, consider yourself hired as a consultant—honestly, your memory is far sharper than mine. 🙂

Regarding those topics you might be referencing, I think I once asked about what happened to the Slavo family and Lein's situation. I got shut down immediately with a "mind your own business" response, and that was pretty much the end of it. 🙂

As for anything else beyond that, I can't recall.

The whole thing really just boils down to the fact that the rules ought to be applied equally to everyone—which, in my estimation, almost certainly works against those of us who actually have more than two and a half serious posts under our belts. I don't see any other way to look at it.

coppernomad44 said:And why wouldn't I? I mean, where else would we go... 😕

At first glance, banning "advocacy" can be easily attacked as "stifling free speech," "trampling on democracy," or those whole "death to fascism, freedom to the people" type of slogans. There are several beloved names that are gone now—and personally, I think it’s a real shame they aren't around anymore—but, I'm honestly not sure if debating that point would serve any actual purpose or provide any real benefit.

I mean, if you really stop to think about it, just imagine the absolute chaos that would ensue if everyone started shouting, "Why did you Ban this person?" or "Why did you Ban that one? They were actually great!" and so on. It would be a total mess.

The only thing more nonsensical than an absolute monarchy when it comes to managing online spaces is pretending to run a parliamentary democracy—because, frankly, that almost inevitably devolves into nothing more than populist anarchy. 🙂

hollowtrucker77 said:I don't have a clue what this guy is talking about.

Every once in a while—without any actual trigger, mind you—everything just randomly switches over to English, and then, after a certain amount of time passes, it just reverts back to American all on its own.

Kate Stewart49 said:Thanks. By the way, I'm back here again after a pretty long break.

Let me guess: was your old handle "supermom"? 🤣

Kyle Johnson2 said:Nicholas King provided the Macro code using lowercase, so I "purposely" used uppercase instead. I mean, we really ought to be using our brains a little bit here rather than just operating like mindless robots ;-)

If my memory serves me right—and I could be wrong—if you type a lowercase letter in the "replace with" field and ensure "Match Case" is unchecked, then that replacement covers both cases. Essentially, you wouldn't need separate replacement steps for a lowercase or uppercase "C" (even if you specifically search for an uppercase "C" in the "Find" box).