Posts by Nicholas King

Olivia Gonzalez48 said:So, how do I get rid of these zeros when there isn't actually any data to calculate?

There are several different ways to approach this—it really depends on what you're looking for. One method (for instance, if you're calculating A1*B1 in cell C1) would be something like this:

=IF(COUNT(A1: B1)
Basically, if there isn't a number entered in at least one of those cells—A1 or B1, in this case—you'll just end up with a blank cell instead; otherwise, the formula will go ahead and give you the product.

crimsonraven6 said:so I just hit ctrl+a and then copy and paste it into Photoshop, but I’m still stuck with that annoying white background...

Don't use ctrl+a.

Just select the actual image—click on it once—and then try your copy/paste from there.

Kimberly Smith69 said:Every time I try to save something as a PDF file, I get these weird question marks appearing... and this has been happening since the very first day I installed everything. Can anyone help me figure out what the hell is going wrong?

From what I can gather here, it looks like you're trying to open a PDF file directly in Word—which, frankly, just confuses Word because it doesn't really know what to make of that specific file type.

rustydriver23 said:And now, regarding those two different sizes—what I actually need is a single curve that depends on both of them.

Just highlight the cells containing those numbers (in your specific case, all six cells), fire up the Chart Wizard, and you're good to go. 🙂

What actually happens when you go into Word and select Paste Special -> Windows Metafile? If everything were working correctly—and I really mean *correctly*—the background should definitely be transparent (you can test this yourself by placing an image behind the text and seeing if it shows through).

I'm also wondering how Photoshop handles it when you import (directly from the disk) a WMF-file? Does the background end up being transparent in that scenario?

crimsonraven6 said:unfortunately doesn't exist
but whatever, I guess I'll just find some way to make it work 😉
thanks for the effort

last attempt: Are you absolutely certain that you have set no fill as the background in Excel, rather than not using a white background? If you've applied a white background, then—well, obviously—you'll need to switch that over.

crimsonraven6 said:I tried doing exactly that—literally following those steps to the letter—and it just spits out a white background again :SSS

I might as well just rub salt in the wound and say that everything works perfectly fine in PhotoPaint—every single one of those methods works without a hitch.

Does Photoshop actually have any specific settings tucked away inside Paste Special?

crimsonraven6 said:I don't quite follow... I just type whatever I want into a cell... then I select that cell and paste it into Photoshop, and it gives me both the text and the background box...

Maybe try using a Windows Metafile as an intermediate step:

- select and copy your cells in Excel;
- run Word and perform a Paste Special -> Windows Metafile there;
- then you can just copy-paste that image straight into Photoshop.

crimsonraven6 said:—but if the background image they’re using is dark, requiring white text, then you’d actually have to create a darker shade behind those white letters within Excel itself...

That isn't necessary. Just leave the text white and perform the copy/paste. I suppose if you can't see anything once it's in Excel, that shouldn't really be your concern. 🙂

BTW, I didn't quite grasp what was meant by that "darken" function—if there aren't any cell borders defined in Excel, you should probably just move the text over.

Jack Alvarez said:Just take a screenshot of whatever map you want to include, drop it into Word as an image, and you're done!

The actual issue here—and I think this is important—is that translating "copyright" as "you have the right to copy" is just... well, it's fundamentally incorrect. 😁

cosmicrider5 said:But honestly, it’s a total nightmare when companies start migrating over to OpenOffice.

Or maybe management just collectively lost their minds and decided—for reasons known only to them—that they don't actually need Microsoft Office for, you know, basically everything.

Kyle Johnson2 said:So, here’s a quick little walkthrough for anyone who might run into this exact same issue—at least based on this specific example.

Summing up every nth row in a column

The formula provided in the tutorial (=SUMPRODUCT((MOD(ROW($A$2:$A$24),7)=0)*($A$2:$A$24))) just isn't quite right. It ends up summing data from the 7th, 14th, and so on, rows of the spreadsheet, rather than the actual data range itself—since the first row is being used for headers in this case, that means the 7th piece of data actually sits in the 8th row.

Justin Torres77 said:I tried running this, but I'm getting an incorrect sum somewhere🤷

I’d really prefer to see your raw input data—specifically the cell range you're working with and the actual incorrect total you're seeing.

Benjamin Wilson7 said:- because if he wants every 7th row, then there actually needs to be some specific criterion tied to that individual row

Honestly, the fact that it's every seventh row is the criteria—that should be enough for him to grab it. He doesn't need anything else, really. 🙂

Benjamin Wilson7 said:=SUMIF($A$2:$A$133,"product code",$J$2:$J133)

I finally realized—and this was a bit of an epiphany, I guess—that every single column is just representing one specific product, which means manually adding up every seventh data point is enough to drive anyone absolutely insane.

Justin Torres77 said:I need to sum up every 7th row within a specific column at the bottom of my sheet.

If you're looking at data in, say, the range A2 : A100, you can use this formula:

=SUMPRODUCT((A2:A100)*(0+MOD(ROW(A2:A100)-1;7)=0))

That bolded part is actually quite critical—you'll have to adjust it depending on which row your data set actually starts on. Basically, you take the starting row number and subtract one (so, if your data begins on row ten, you would change that value to -9).

amberangler99 said:you aren't going to start a conversation with someone you don't even know—let alone actually chat with them—using that kind of tone. I mean, I doubt you've ever walked up to a complete stranger and told them they don't mean a damn thing to you; that’s something you say to people you already know, people you're messing around with, not some random person off the street.🤷

I find it a bit peculiar that someone with barely a year of seniority on this forum—and a mountain of posts to show for it—feels the need to categorize us users into those they know and those they don't, or those they chat with versus those they don't... not to mention labeling others as "strangers."

amberangler99 said:but if typing in all caps is considered harassment and isn't allowed, yet this is how Nex reacted—then apparently it is fine. does that count as "normal" communication?

Once again, Nex is just messing around. The guy doesn't even swear—at least, I can't recall him ever doing so.

Otherwise: yes, that counts as "normal" (meaning common, "average") communication. I don't know what kind of bubble you live in or what sort of people you surround yourself with—but in informal settings, people swear. It’s not my personal idea of a good time—I much prefer people who can express themselves without relying on profanity—but I find it a bit presumptuous to demand that the entire world bend to my specific preferences.

so you mean if you talk total nonsense to me, and I respond with "what the hell are you talking about?" that would be perfectly okay, and I wouldn't get flagged for it, right?

Under the forum rules, even if you wrote "what on earth?" or even something like "esteemed moderator, I must respectfully maintain that you are mistaken in this matter," you would still get flagged because you are commenting on moderation within the thread itself. 🙂

Chloe Green61 said:if they can't find a subforum that suits them—they should just leave
if they found one, but hate the moderation—then they should leave
if they hate absolutely everything about this place—well, they should just leave

If they supposedly hate everything, sure—but, I mean, if you actually look at the posts, they're always talking about "certain individuals" or "some people."

Chloe Green61 said:just get off the forum🤷

That's a bit easier said than done. 🙂

It's really just the final step—though, if you ask me, it's entirely unnecessary. I honestly find it hard to believe that someone can't simply locate a few PDFs where they can write extensively without having to feel uncomfortable because of some random person's presence.

If you start feeling out of place somewhere, you just walk away. It’s really that simple.