Posts by Kate Williams

Benjamin Wilson7 said:You aren't looking closely enough! What do you mean by highlighting? Of course they aren't deleting the rows; they are simply hiding them, leaving behind exactly the range you actually need.

Which specific filter were you referring to there? My mind was stuck on "conditional formatting."
I actually stumbled upon another method—I think it’s one where everything in the main table gets wiped out, leaving only the data you want to see. But when I say "wiped out from the main table," I mean it's actually altering my primary data set instead of just copying the results somewhere else... I'm honestly not quite sure how to describe it properly.

Benjamin Wilson7 said:Danny, you could actually handle that quite easily just by using filters! They offer so many great options—like finding exact matches, values greater than, or less than certain amounts—and then you can simply copy those results over to a new Sheet. Filters are wonderful because they isolate exactly what you need within a specific range, even when you're dealing with messy decimals.

Actually, I'm going to pass on the filter idea; from what I've observed, they mostly just highlight the relevant data rather than actually generating new outputs or cleaning up rows for you.
I think I'll just wait to hear back from John to see if we can make this work with those decimal values.

Benjamin Wilson7 said:Oh, my dear Gregory Rogers20, if memory serves me right, there was absolutely no mention of specific maximum or minimum values! I actually assumed there might be some jumps in the data, which is why I suggested that you would need to manually input those values into column D.
Nicholas King 👍.

How can you say that isn't the case? I mean, what else could FROM - TO mean? It’s essentially the exact same thing, haha!
I am so sorry, Benjamin Wilson7, it truly wasn't my intention to mislead you! 🤣

Kyle Johnson2 said:Here is how you can tackle this using a Makronaredba.
In this example, you have the choice to either click the COPY button or the FORM button.
If you opt for the Copy button, it automatically performs the duplication based on the criteria set within cells E1 and E2.

Alternatively, if you prefer using the form, clicking the Form button will trigger a dialog box where you can manually input your desired MIN and MAX values.
Everything gets copied directly underneath your specified range.
All you really need to do is tweak the code to fit your specific requirements—just modify those sections of the Makronaredba accordingly.

- Copying between MIN and MAX values

Bravo, John! This is truly an excellent way to handle the task; best of all, I don't even have to drag any formulas down manually! It just populates everything instantly. 🙂
Since I have at least a little bit of experience tinkering with Visual Basic, I shouldn't have much trouble adjusting the logic if my needs change later on. 🙂

Honestly, even without the form feature, this is great because that Copy button alone does the trick perfectly.
Now, moving forward, how exactly should we handle the decimal points in this setup?

Ethan Palmer69 said:That sounds wonderful! But how on earth do I go about deleting numbers 3 and 4 since they are showing up on my table of contents and a blank page?
(Or more generally speaking, how can I strip those numbers away without completely wrecking the rest of my formatting?)

For instance, what if I wanted my numbering to restart at 2 starting from page 6?

Well, in order to truly master this, you really ought to learn how to work with sections first, just as I mentioned previously.
However, I am more than happy to lend a helping hand!

First things first, please make sure to enable the "Show/Hide" feature in Microsoft Word—it looks like a little musical note icon and is black in color; otherwise, you won't be able to actually see where your page breaks or section breaks are located.
Now, wherever you want the numbering to reset (for example, on page 6 in your specific case), essentially where you want the count to start over, simply click at the very end of that page and press:
INSERT - break Continuous. By doing this, you have successfully created a new section, meaning you now have Section 1 and Section 2. Now, please enable:

View - Header and Footer, so that you can clearly visualize your sections.

- Navigate over to Section 2. Now, please pay close attention: everything you do from here on out should be done within Section 2!
- Turn off "Link to Previous"—you'll know it's off when the button is no longer highlighted.
- Click on the third icon from the left: Format Page Number.
- Set the option to "Start at: 0." This might occasionally jump you back to Section 1, but if that happens, just head right back to Section 2 and then:
- Click Insert Page Number, which is the icon all the way on the left (you can do this in either the header or the footer).
- The current page number will appear, and it should now correctly show as number 1!

Do keep in mind, if you don't adjust the "Format Page Number" setting, the software will simply display the actual page count; so, if you are currently on page 7, it will insist on saying "Page 7," which is precisely why that specific step is so vital.

Benjamin Wilson7 said:I’m rushing this out a little bit—my head is spinning today and I'm feeling quite under the weather—but please take a look and see if this approach works for you:
So, for instance, go ahead and enter the specific numbers you need in column D1 and then drag them down: let's say 23, 24, 25, 26, 27, 28 (based on that example you provided earlier).

Input this formula into cell B14 and drag it down the column:
=VLOOKUP(D1;$A$1:$B$13;2)

And just to be absolutely certain, pull that formula down further; once you start seeing that #N/A error, you’ll know you’ve reached the end of the list.
It is incredibly vital that the table you are searching through is sorted in ascending order, because otherwise, the VLOOKUP function will provide completely incorrect results!

You won't have any empty rows left over, though you will need to input which numbers you are looking for in cells D1 through D6; you can always hide those columns afterward if you want a cleaner look.

If you actually want to display the numbers themselves, put =VLOOKUP(D1;$A$1:$B$13;1) into cell A14 (again, just drag it down until you hit that #N/A error).

Alright, now let me get back to my main point; is it possible to define my numbers using a range, such as "from X to Y"? You see, what I am really trying to manage is a table containing player handicaps—essentially, every player has their own handicap value—and the tricky part is that these values are decimals (like 20.5).
The goal is to categorize everyone into Groups A, B, C, and D. Players within a certain handicap range fall into Group A, while players with higher handicaps move into Group B, and so on...
Essentially, whenever a player's handicap changes, the table should update automatically, and if they drop below a certain threshold, they should automatically shift into a different group.🙂

Now, I realize that might be a bit much detail, but...
Is it possible to set up that "from-to" range logic? 🙂

Well, if you ask me, I would definitely prefer to have a bit more data to work with—say, at least 100 rows! Otherwise, those pesky "empty rows" just end up cluttering everything up, making the whole sheet look messy and disorganized instead of being neatly arranged and professional...

And what do you think about an alternative approach, perhaps where all that information is displayed within a single cell, with each entry stacked vertically one beneath the other?

It’s working perfectly now that I’ve pulled it through! You really should have given me a heads-up earlier 😁 though,
is there any way to make it print everything from the very beginning without skipping rows? (I'm talking about those empty little boxes), so that they all look neatly filled in—do you think that's possible?

Hold on just a second, I suspect you might be working with a completely different version of Excel where semicolons are the standard delimiter! For my part, the system simply refuses to accept them; it will only process the data correctly if I use a comma instead!

To clarify once more, here is precisely what I am trying to achieve:

Unfortunately, it just isn't working quite right; I keep getting an empty cell,
and even when I attempt to structure it this way: =IF(AND(A1>=23,A1 "false" instead of the result I'm looking for...
I will go ahead and post an example of exactly what I am trying to achieve right now.

One step at a time! I have a wonderful feeling about this, truly. I am going to dive in and give it a proper go, and once I see how it performs, I will be sure to circle back and update everyone on my findings.

Oh, I clearly wasn't being quite articulate enough in my previous message!
Look, let's just set aside that VLOOKUP discussion for a moment; I'm honestly not entirely certain if that's actually the right tool for this specific job.
What I am truly looking to achieve is this:
- scan through the range A1:A13 and identify every number that falls within the span of 23 to 28
- once you've located a matching row, grab the corresponding letter from column B in that same row
- then, neatly list all those letters in a new series of rows starting from row 14 down through row 26, one after another,

(To illustrate based on the task above, the formula should automatically detect the numbers 23, 24, 25, 26, 27, and 28, and subsequently populate the lower rows with the letters: f, g, h, i, j, and k.) Essentially, I want the system to find those values autonomously rather than me feeding it each exact number; I simply want to define the range of 23 to 28.

Does that make much more sense now?

Hello everyone! I am reaching out today because I could really use a little bit of guidance regarding some Excel work I am currently tackling.
I have set up a small dataset with columns A and B, spanning about 13 rows.

Right now, I am utilizing this specific formula:

=VLOOKUP(23,A1:B13,2)

Essentially, the formula scans column A for the number "23," and once it hits that match, it pulls the corresponding value from column B—which, in my current setup, displays the letter "f" down in row 14.

However, I’ve realized that relying on a single, hard-coded number isn't quite efficient enough for what I need to achieve! What I am actually dreaming of is a way to make this dynamic. Instead of just hunting for "23," I want the formula to sweep through column A and identify a whole range of numbers—say, everything from 22 to 25—and then list all the associated values from column B for every single one of those matches. It would be wonderful if it could display the entire sequence of results from that range at once. Does anyone know how I might go about adding that kind of logic to my sheet?

What on earth is going on with Zab? Does anyone know why their login page isn't working at all right now? 😕

I personally find myself working quite frequently with Adobe Audition and Audacity, though I must say that Ableton Live and even FL Studio are also rather excellent tools when you need to handle those final touches or simply want to import and export your tracks!