Kyle Johnson2 said:It’s straightforward. If a value falls under the "first - second" category, you just treat it as such. I already laid out a potential fix in my last post using a VLOOKUP function.
...which, frankly, I couldn't care less about.
Home ›
David Wilson11 › Posts
Posts by David Wilson11
6 posts shown.
...which, frankly, I couldn't care less about.
Nicholas King Asks:
Look, if you’ve actually dumped all that data into one single cell exactly like you showed in your example—meaning the cell literally just says "18-25 (First)"—then I'm completely lost. I mean, really. How on earth am I supposed to build anything useful with that? You're handing me two and a half functions and expecting a miracle, but there's just no way to make it work when everything is mashed together like that. It's impossible.
And honestly, I just don't see how you're even going to manage that... I'm just saying... it's exactly the same. Everything about it. No matter how you slice it, we're looking at the exact same thing. Honestly, it’s infuriating how people try to argue otherwise when the reality is staring them right in the face! It's identical. Period. So, you're looking to just type something directly into a cell—say, "first second." Simple enough, right? Just type it in and move on.
The only way I can see this working—and honestly, it's a headache—is to set up a system where you put your lower limits in Column A, your upper limits in Column B, and then give those ranges names in Column C. From there, you're stuck writing these absolutely massive, bloated IF statements in two separate cells. One cell handles whether it fits into the first range, and the other one tackles whether it lands in some other range. It’s messy, it's tedious, but it seems to be the only way out of this mess.
Finally, someone actually gets it! You're the first one to pinpoint the real nightmare here—the sheer, absolute chaos of stuffing massive, bloated functions into every single cell. It’s a disaster waiting to happen. Honestly, I really thought I'd find some kind of brilliant, intelligent solution to this mess, but clearly, I was dreaming. Dammit. 🤷
Kyle Johnson2 said:Look, maybe things wouldn't be such a mess if you just uploaded a file ready for download with the elements already filled in, or at least kept the text and explanations to a minimum.
Just give us the raw data and tell us what the end goal is. Period.
See if this solution works for you:
That’s a real pretty way you've imagined it working, and I'm sure it makes sense in your head. But now? Now I'd ask you to actually go back and read my very first post. Just read it. Maybe then you'll grasp where the actual problem lies and realize whether a post like yours was even necessary in the first place.
Walter Jackson48 said:Here’s the formula, hopefully this clears things up for you:
(paste this formula into B1)
=IF(AND(A1>=18,A125,A1
This formula works if you want to dump everything into one single cell (in my case, cell A1). Then, cell B1 will spit out the labels—like "first," "first and second," "second," etc. If you actually wanted to split those ranges into separate individual cells, you’d only need a specific chunk of this logic.
Let me break down what this thing is actually doing: if A1 is 18 or higher AND less than 25, it writes "First." If not, we check if A1 equals 25, and if it does, it writes "First and Second," and so on. Honestly, though, having two overlapping intervals like 18-25 and 25-31 seems a bit weird to me—statistically speaking, wouldn't it make more sense for the second range to start at 26? But hey, you know why you need it your way.
That formula didn't work for me. I can't even copy the error message because the software isn't giving me much to go on.
Maybe I phrased my question poorly, so let me try this again:
Okay, look. I have a column of five cells, A1 through A5. Each cell defines a specific numerical range used for looking up values. This time, I'll use decimals to make it clearer.
Cell A1 holds the range from 1.60 to 1.94; A2 is 1.94 to 2.01; A3 is 2.01 to 2.05; A4 goes from 2.05 to 21.0; and finally, A5 covers 21.1 to infinity.
Column B1 through B5 will contain the actual numbers I'm inputting, which should fall within the ranges defined in Column A.
Column D1 through D5 contains the names assigned to these ranges in Column A. For example, the range in A1 is called "First," the range in A2 is "Second," and so on.
What I'm trying to do is: when I type numbers into Column B, I want Column C to automatically display the name of the range they belong to based on the rules in Column A. The headache comes from the numbers that sit right on the boundary of two adjacent ranges—I need Column C to show *both* names in those cases.
Anyway, I hope I haven't made this even more confusing. Hopefully, this explanation makes more sense this time. 🙂
Look, I know this might be the wrong sub for this, but I’m asking the moderator to please, please read this carefully because it’s deeply tied to how Microsoft Excel functions.
Since I’m away from my desk most of the time, I end up relying on my phone for basically everything—office tasks, checking PDFs, messing around in Microsoft Word, you name it. But there’s a catch: I can only run programs built on Java code. And that brings me to my headache.
I downloaded Google Sheets to mimic some features of Microsoft Excel, but man, it is incredibly limited. All I have to work with are these specific functions: SUM, IF statements, AND, OR, NOT, ABS, SIN, COS, TAN, ASIN, ACOS, ATAN, POWER, LOG, LN, EXP, SQRT, INT, RAND, NOW, TODAY, DATE, TIME, DATEVALUE, TIMEVALUE, YEAR, MONTH, DAY, HOUR, MINUTE, PI, and E.
Using these tools, I'm trying to set up something in my Sheet. Here's the deal: I have five cells containing numbers within different ranges—let's say 18-25 (first), 25-31 (second), 32-36 (third), 36-40 (fourth), and finally 41-infinity (fifth). Note that some of these ranges overlap at the edges. I need to assign a label to each range. My goal is to create a rule where, if I manually enter a number anywhere from 18 to infinity in a cell, the adjacent cell automatically pulls the correct label based on those ranges.
For example: if I type in 23, the cell next to it should automatically display "first." Now, here is the tricky part—for numbers that fall into overlapping ranges, I need it to show both names. So, if I enter 36, the cell to the right should display both "third" and "fourth."
If you guys need more details, just ask. I really hope I haven't posted this in the wrong spot, but it's such a weirdly specific problem.🙂
Since I’m away from my desk most of the time, I end up relying on my phone for basically everything—office tasks, checking PDFs, messing around in Microsoft Word, you name it. But there’s a catch: I can only run programs built on Java code. And that brings me to my headache.
I downloaded Google Sheets to mimic some features of Microsoft Excel, but man, it is incredibly limited. All I have to work with are these specific functions: SUM, IF statements, AND, OR, NOT, ABS, SIN, COS, TAN, ASIN, ACOS, ATAN, POWER, LOG, LN, EXP, SQRT, INT, RAND, NOW, TODAY, DATE, TIME, DATEVALUE, TIMEVALUE, YEAR, MONTH, DAY, HOUR, MINUTE, PI, and E.
Using these tools, I'm trying to set up something in my Sheet. Here's the deal: I have five cells containing numbers within different ranges—let's say 18-25 (first), 25-31 (second), 32-36 (third), 36-40 (fourth), and finally 41-infinity (fifth). Note that some of these ranges overlap at the edges. I need to assign a label to each range. My goal is to create a rule where, if I manually enter a number anywhere from 18 to infinity in a cell, the adjacent cell automatically pulls the correct label based on those ranges.
For example: if I type in 23, the cell next to it should automatically display "first." Now, here is the tricky part—for numbers that fall into overlapping ranges, I need it to show both names. So, if I enter 36, the cell to the right should display both "third" and "fourth."
If you guys need more details, just ask. I really hope I haven't posted this in the wrong spot, but it's such a weirdly specific problem.🙂
Where is this world heading? - thoughts on tech, morality, and the modern Western man
in Psychology ·
If I were to start from scratch, I wouldn't even know where to begin... but let's just say right off the bat, I am so utterly disgusted by the people around me lately that I have to wonder if I’m living in some weird, tiny minority. I find myself clinging to basic human values that I just don't see—or hear—anywhere anymore. Sometimes I feel like an extinct dinosaur :-P
Morals, honesty, empathy—three things that are basically going extinct, or maybe it's just me? That's the problem eating at me: how on earth are you supposed to raise kids these days? How do you guide them toward these actual human qualities when it feels like the world is practically begging them to be the exact opposite just to survive this cold, heartless reality?
The circles I move in are pretty diverse—friends, hobbies, sports—but I honestly don't see anyone actually striving to embody those three traits. In fact, it's worse than that; I've heard people brag about having "recovered" from being such decent human beings..
Technology has really accelerated this downward spiral, pushing everyone faster toward that emptiness. Though, I guess it does give those who actually *want* to understand things a way to learn without having to ask someone else what kind of mess the world has become.
If some kind of time machine showed up right now, I’d hand over everything I own just to go back to the Stone Age. I'd run through the woods chasing bison with the primitives, even if it killed me in the process :-)
Morals, honesty, empathy—three things that are basically going extinct, or maybe it's just me? That's the problem eating at me: how on earth are you supposed to raise kids these days? How do you guide them toward these actual human qualities when it feels like the world is practically begging them to be the exact opposite just to survive this cold, heartless reality?
The circles I move in are pretty diverse—friends, hobbies, sports—but I honestly don't see anyone actually striving to embody those three traits. In fact, it's worse than that; I've heard people brag about having "recovered" from being such decent human beings..
Technology has really accelerated this downward spiral, pushing everyone faster toward that emptiness. Though, I guess it does give those who actually *want* to understand things a way to learn without having to ask someone else what kind of mess the world has become.
If some kind of time machine showed up right now, I’d hand over everything I own just to go back to the Stone Age. I'd run through the woods chasing bison with the primitives, even if it killed me in the process :-)