Posts by George Fox23

Walter Jackson48 said:Seeing the number 97 makes me think of calculating a checksum for some kind of code, so
if that's what you're after, maybe this will help you out:
http://www.elitesecurity.org/t383093-0
and just grab that file attached by @neptuncokg from Nov 30, 2009

thanks so much!
now I just gotta wrap my head around what they actually did

yeah, we're talking about a checksum here ;-)

Dana Diaz8 said:It’s because Excel caps out at 15 digits. You can only type up to 15 significant figures in a single cell, but since you're trying to use 17, 🙂

Thanks!

George Fox23 said:Hey everyone, what's up?
I'm really struggling here and I can't figure this out, and I need it ASAP for some calculations I'm running.
Why is it that when I type 24840083200735935 into a cell formatted as a number, it just changes it to 24840083200735900?
No matter what I try, it keeps rounding it like that.
What gives? What am I doing wrong?

Just wanted to ask quick...
I have to divide that specific number by 97, and I need the resulting remainder to show up in another cell.
Like, if I do 21 divided by 4, it's 5 with a remainder of 1—I just need that 1.
I honestly can't remember how to isolate the number after the decimal point!

Thanks a ton!

Hey everyone!
I am seriously struggling here and I can't for the life of me figure this out, and I need it fixed ASAP for some calculations I'm running.
Why is it that when I type 24840083200735935 into a cell—which is already formatted as a number—it just forces it to be 24840083200735900?
No matter what I try, it keeps entering it that way.
What on earth is the problem here?

Hey there!

I’m looking for some guidance on how to set up a formula so that at the end of an existing row, it automatically calculates the total hours and minutes worked for that month.
Since this is an established document, I'm a bit hesitant to mess with the structure too much—it's one of those spreadsheets where if you try to change anything, everything just falls apart.
I've attached a screenshot here: http://imageshack.us/photo/my-images/710/dolasci.jpg/

Honestly, I could just crunch all these numbers by hand, but it would take forever. Is there a way to speed things up using formulas? The biggest headache is those merged cells with descriptive text—I really need a way to make sure the formula ignores them entirely.

Thanks!

Kyle Johnson2 said:Since you're asking for help anyway, could you at least post the table for... DOWNLOAD It’s not like someone’s actually working for you, you know? And then they have the nerve to try and explain things to you on top of that!

So, if you look over at Sheet2, specifically cells A1, B1, and C1, you’ve got these names sitting there—POD1, POD2, and POD3. I'm still trying to wrap my head around this... how do I even start? Is there a specific way you want me to handle this? What's the plan here? That cell range called "election_list"?
So, you've got maybe ten rows of data sitting right under those names, right? That’s exactly what you want to pull over to Sheet1 once you make your pick from the drop-down menu.

So, on Sheet1, you’ll want to set up an A1 Validation list. Just go with "List" and then use the "=selection" part—and honestly, don't even worry about those quotation marks. You're going to be using a nested setup for this one! Ever played around with the IF function? It’s kind of a game-changer once you get the hang of it!

Just pop this formula right into cell A2.
Code:

Ever feel like you're wrestling with a formula that just won't behave? Check this out: if cell A1 says "POD1," grab the value from A2 on Sheet2. If it says "POD2," pull from B2 instead. Otherwise, just default to C2. Simple enough, right? Still trying to get those nested IF statements to play nice?

Just copy it down to as many rows as you actually have data for on Sheet2. Simple enough, right?



Once you make a selection in the A1 Validation, all the info from Sheet2 that sits right under the heading will pop up automatically!
I really hope you caught my drift there—if you didn't, well, I guess we're back to square one! Go ahead and download this file! So, based on the example we just walked through...

There are probably other ways to go about this, but honestly? I just don't feel like overthinking it right now. 😉

Thanks so much, and sorry about that—I totally forgot to attach the file!
I honestly didn't think it was necessary, especially since we're working with such a tiny amount of data!
Anyway, I'll be around!

Thanks again!

Hey everyone!

I'm trying to pull off something specific in Excel and was wondering if anyone could point me in the right direction? Is this even possible?

So, let's say Sheet2 has three columns, and each one has its own header.
Like, just some data sitting under those headers.

DATA1 DATA2 DATA3
10 5 1
20 15 2
30 25 3

Here's the deal: I want to go over to Sheet1 and set up a dropdown list containing those three column headers. Then, once I pick a column—say, DATA2—I want all the cells underneath that dropdown to automatically fill up with the corresponding data from that column. Basically, as I toggle through the different options in the dropdown, I want the numbers below to swap out instantly.
I managed to get the dropdown list working, but I'm totally stuck on what comes next. Any ideas?

Thanks!