Posts by Jack Hayes

Here’s the formula for finding that lowest (final) price over in column G: =MIN(D2;F2)
Then, for the index in column H, use this: =IF(AND(D2=G2;F2=G2);G2/MIN(C2;E2);IF(D2=G2;D2/C2;F2/E2))
Just a quick breakdown of the logic:
- I set it up so the starting prices are in columns C and D, while the final ones sit in E and F.
- If both final prices end up being identical, the formula just grabs whichever starting price was lower.
- Also, if the initial price is lower than the final one, you'll see an index greater than 1.
Hopefully, one of these works for what you're trying to do! ☕

I used to rely on PDFCreator, but lately, I’ve been sticking with PDF24 Creator. If you’re just working in Microsoft Word or Google Docs, you probably don't even need extra software since those programs let you save directly as a PDF. But when you need to actually mess around with files—like adding pages, deleting stuff, or rearranging images—PDF24 Creator is honestly fantastic. It makes everything so much smoother. Definitely recommend giving it a shot! ☕

Patrick Hughes72 said:Hey there!

Where exactly can I find my IP address in Windows XP?
Thanks in advance for any help!

Hit Start then Run, type in ipconfig and just hit Enter

rustywalker1 said:Is there any way to tweak things so that when I set decimals, it doesn't show all those extra unnecessary digits?
For instance, if I set it to three decimal places but the number is just 7.3, I want it to stay as 7.3 instead of showing 7.300. Or, if the number is 7.000, I'd rather it just show 7.
...

Actually, in both Excel and LibreOffice Calc, that’s just how it works by default if you use Format Cells - Number - General. It won't show trailing zeros or extra decimals if they aren't needed. ☕

wiredwolf34 said:Look, I don't have any trouble making a single chart for every year—I can handle that easily. But the issue is that all the years need to be displayed using just one single chart, and that’s where things get tricky.

Really?! So what’s the alternative here—a monthly column sum or maybe a total for all years combined? Just set up a Total row in both Table A and Table B, then just plot that on the graph. 🤷

wiredwolf34 said:I have these two specific tables I need to show on a single chart so you can actually see how they compare against each other. If there isn't a way to do it that way, I guess I'll just end up typing everything out by hand like Walter Jackson48 suggested. Okay, looks good.

Wait, why wouldn't you be able to do that? You could technically pull a line chart for every single year, but honestly, that would look like a total mess. If you just pull one year's worth of data from Table A and Table B, you get two lines—exactly like the example my colleagues sent over. Can you manage that?
Just head over to Insert, pick a line chart, and then when you're selecting your data, here's the trick: hold down the Ctrl key while you highlight the data for that specific year in both Table A and Table B. Let go of Ctrl and you're all set. Then, for the Horizontal Axis Label, just click EDIT and pick the header from one of your tables.

mellowbear21 said:I put the document right here at this link:

http://www.sendspace.com/file/46w49z

You’ll need to copy those numbers in column B and then Paste them back into column B, but make sure you paste them as values, not as an RND formula. If you don't, we're all going to end up with different results.

Advanced filter doesn't seem to fit what you're trying to do? You can actually pull data using multiple AND and OR criteria with it. It might be worth spending a few minutes playing around with it to see how it works...

Also, besides the Advanced filter in LibreOffice Calc, there's also the Standard filter. It’s pretty straightforward—you just select the column with your data, pick something like smallest 28, and the program will spit out a table showing the 28 lowest values from column B.

mellowbear21 said:In column D, I'd love to see the actual COLOR names printed out based on how many times they show up in column C.

Wait, what’s the point of all this?! 🤷
Basically, what you’ve already got sitting in column C—and what you're trying to get in column D—is just columns A and B sorted by column B.

Scott Wood2 said:Hey there!
I could use a hand with Excel. I'm trying to figure out if it's possible to make Excel spit out random characters—for example, I want it to randomly pick either a "+" or just a " " (a space).
Thanks!

=IF(RANDBETWEEN(0,1)=1;"+"," ")

☕

restlessmoose23 said:I could really use some help here. I noticed how pricey a single package like this can be, and since I need enough for an entire office, I'm a bit lost. How does this actually work? Do I have to buy a separate license for every single computer, or is there some kind of bulk discount available if I order several at once?

Is there nothing free on the table? For instance, what about OpenOffice? 👍

Taylor Parker5 said:John C, I’m starting my Excel training next week. Honestly, I feel bad for you already because I don't have a clue what I'm doing.

First off, change your mindset—try being a bit more optimistic and start reading up on Excel today. Everything you pick up now will eventually come in handy. ☕

Brandon Chavez8 said:Could use a little hand here.
I’ve got an Excel file with over 100 sheets, and I want the very first sheet to show the sum of whatever value is sitting in cell B6 across all those other individual sheets.
Does anyone know the right formula for that?
Thanks in advance!

Over 100 sheets? Is that actually useful for anything? Just wondering. 🤷
What is this... some kind of massive government database or something? 😂

Brenda Jackson said:How can I change text inside a PDF (it was originally a table made in Microsoft Word)? Every time I try to convert the PDF back into Word to fix things, the whole layout falls apart—the fonts get messed up, the design shifts, and everything just looks messy.
I downloaded Adobe Acrobat 8 Pro, but I honestly can't find where the option is to edit the existing text!
Can someone please help me out?

Just make the changes in Microsoft Word and then save it as a new PDF. Wait, you don't have the original Word doc? Big mistake! You should always hang onto the original file.
Try copying the content or opening it in Microsoft Word, fixing the layout there, and saving it as a Word doc—especially if you think you'll need to tweak it again later.
Technically, you can delete or add text directly in a PDF, but it's such a headache trying to match the exact font and quality so it doesn't look obvious.

electricmarlin18 said:Can someone please help me out? This is kind of urgent. When I type in =DATEDIF(H14,I14,"y"), Excel won't let me select cell I14 and just keeps popping up an error saying there's a problem with my formula. I'm honestly going crazy here and really need some help—feel free to shoot me a DM. Thanks!

Try using a semicolon instead of a comma!

Daniel Thompson9 said:So, you've already got an Author table set up with First Name and Last Name columns and all the data filled in.

For example:
First Name Last Name
Pero Perić
Đuro Đurić

What I actually need is this:

CREATE TABLE Author(
FirstName TEXT,
LastName text
)

INSERT INTO Author (FirstName, LastName) VALUES ('Pero', 'Perić')
INSERT INTO Author (FirstName, LastName) VALUES ('Đuro','Đurić')

In Microsoft Access, you can check the table name, column names, data types, keys... and use that info to build your CREATE TABLE code.
As for the INSERT part, just grab a CSV file with delimited data, like this:
FIRSTNAME;LASTNAME
Pero;Perić
Đuro;Đurić
...
Then, you just run a loop to read the file line by line and perform the inserts. Personally, I usually use that first row as my column headers, just like in my example above.

Amy Kern said:Hey everyone, I could really use some advice regarding Word 2007.

It’s about footnotes.
Everything is working perfectly except for one single footnote. On this specific page, there's a song title, and then the lyrics take up the entire page across two lines...

Are you trying to say the poem is set in two columns? If so, try reverting the main text back to a single column first. Then, leave one or two empty lines at the bottom, highlight just the lyric text, and apply the two-column layout to that section specifically. Those extra lines at the end should stay in a single column, which would likely help the footnote "settle" into the right spot. I haven't actually tested this myself, so I can't promise it'll work, but it's what I'd try if I were in your shoes.

First, grab the data from your first file and drop it into the first Excel sheet, then do the same for the second file into the second sheet. Once that's set, you'll want to use a VLOOKUP function in column C of that first sheet.
It would look something like this... =VLOOKUP(A2;$Sheet2.$A$2:$B$xx;2;FALSE()) where xx represents your total number of rows. I usually just do a quick Google search to double-check how the syntax works before I finalize everything, so definitely check online to make sure you've got it dialed in perfectly.

Rebecca Miller4 said:Is there really nobody who knows how?

Give me an example. Just whip up a quick presentation with a few slides of random filler, toss some music in there, and hit send... Who knows, maybe it'll actually work and you won't even need help after all. ☕

David White8 said:I've run into a bit of a headache while setting my margins. I have to set the right margin to 8 mm just to get this frame edge to show up correctly on the right side. But the second I hit a page break, everything shifts. The left side should be 20mm (just like the first page), but instead, the right side jumps to 20mm on the next page. It’s like a seesaw—whenever I try to fix the page setup for the second page, the first page breaks again.

IMAGE

Take a look at the Pages section within the Page Setup menu. There are four different options in that dropdown, and based on your screenshot, it looks like Mirror margins is currently selected. Try switching it over to Normal instead.

David White8 said:I'm trying to create a border in Word but I just can't get it right. I need it to be 5 mm from all sides, but on the left, I need it to be 20 mm... any tips on how to pull this off?

In Word 2003, you basically have two things to tweak:
1. Set your document margins about 1 cm wider than where you actually want the border to sit. Why 1 cm? Honestly, it just makes life easier, though you could go smaller if you want the text closer to the border. You just have to get the logic down. For what you're doing, try setting the margins to 1.5 cm, with the left margin at 3 cm.
2. On your screen, go to Page Setup, select Layout, then Borders. Pick your Border style, click on Options, set all the margins to 28 pt (which is roughly 1 cm), and make sure to select Measure from: Text.
Hope that helps you get it sorted! 🙂