Posts by electricdriver93

Ashley Johnson46 said:absolute nonsense

electricdriver93😁. What a joke.

Nicole Jones13 said:Dammit, I was actually thinking of something more like this:

https://honka.com/us/en/our-houses/model-50-1a-hr/

https://www.marles.com/houses/en/house-models/atris-149

They’re quite charming, I suppose... though I notice they're singing praises about earthquake resistance everywhere you look.

Then again, they won't exactly last 500 years for my great-great-great-grandchildren to move into. 🤣

They are charming, certainly.
In an ideal world, I would, but first I’d need to acquire the land, then the house, and everything else that comes with it.
Perhaps someday, perhaps never—certainly not anytime soon.

Nicholas Watson said:you really need to watch this movie a few times for everything to click into place
I've seen people suggesting a rewatch to catch what was missed. I suppose I'll give it another shot tonight.

I don't follow—what do you mean, a rewatch?

Nicholas Watson said:So you're saying Tenet isn't actually a good movie?

I tend to trust my sources who have seen it, and they say it isn't.
Perhaps I'll give it a watch eventually; it's not as if I only stick to the masterpieces.

Peace of God, Christ is born, brothers and sisters!

I just finished sending my holiday greetings to my fellow believers in real life, so I figured it was only right to wish you all the very best as well.

Praise be to Jesus, brothers and sisters.
May this new season bring nothing but good fortune to you all.
We felt the tremors, but since the government wasn't in the middle of constructing a skyscraper at the time, everything is fine, thank God.

Benjamin Wilson7 said:Cveba and electricdriver93
When you respond to a post above, there's really no need to quote the whole thing again. Half a page just for three posts???
One guy has over 8,000 posts, while the other has fewer than ten. Cveba might still have a chance at learning, but electricdriver93 is a lost cause.
And all this on an "IT" forum—I shudder to think what the other sections are like.

No, you're right about that.
I'll leave it to the moderators to clean it up; I don't have editing privileges anymore.
There's no need to be quite so malicious.🙂

Jesse Ortiz6 said:Thanks, legend... you really saved my skin here...😁😁😁😁

Saved.😁
Don't mention it.

Replace that first condition with this:

If Cells(b, 1).Value Mod 2 = 0 And Cells(b, 1).Value <> 0 Then

I see. So you just swap out the cell reference arguments.
Like this:

Sub Macro1()

Dim a, b, c
a = Worksheets(1).Rows(1).Cells.SpecialCells(xlCellTypeConstants).Count
c = 1
For b = 1 To a
If Cells(1, b).Value Mod 2 = 0 And Cells(1, b).Value <> 0 Then
Cells(2, c).Value = Cells(1, b).Value
c = c + 1
End If
Next b

End Sub

Jesse Ortiz6 said:Regards,

I am looking for some assistance here if anyone is available... I suspect this needs to be handled via Visual Basic, though I can't say for certain.

"Write a program that identifies all even numbers in the first column of a spreadsheet. The program should list the found numbers sequentially in the second column."

Thanks in advance.

This gets the job done:

Sub Macro1()

Dim a, b, c
a = Worksheets(1).Columns(1).Cells.SpecialCells(xlCellTypeConstants).Count
c = 1
For b = 1 To a
If Value mod 2 = 0 Then Cells(b, 1).Value = Cells(b, 1).Value
Cells(c, 2).Value = Cells(b, 1).Value
c = c + 1
End if Next b end Sub
Next b

End Sub

Paul Gomez90 said:I've run into an issue. I'm working in Excel 2010. I want to consolidate multiple sheets into a single Pivot Table. In the American version, you just hit ALT+D+P and the PIVOT WIZARD window pops up. However, I'm using the American version and that shortcut isn't working... it keeps triggering a print command instead.

Does anyone know the specific command for this version, or perhaps an alternative way to get it done? If it's possible in the American version, there has to be a way to do it here too.

Thanks in advance.

Just add a button for the Pivot Wizard.

Go to the main menu, then Excel options, and select Customization.
Then, under the "Choose commands from" dropdown, select Commands Not in the Ribbon. In the list below, find the one with the rather ridiculous name "PivotTable and PivotChart Wizard," click add, hit OK, and you'll have your wizard button right there on the ribbon.

electricmarlin18 said:So, here is the situation: I have an Excel spreadsheet where I need to calculate the average duration in years, months, and days. To be more specific, one column contains a start date and the second column contains an end date, and my goal is to determine exactly how much time has elapsed between them. I attempted to use the DATEDIF function, but it isn't cooperating. When I try entering something like =DATEDIF(A2,B2,"Y"), the formula fails to recognize cell B2 entirely.

I find myself wondering if there is any other viable workaround here. I recall reading somewhere that Microsoft actually abandoned support for the DATEDIF function starting with Excel 2000, and I am curious to know how much truth there is to that claim. Is there an alternative solution available, or perhaps some kind of add-on installation to bring the DATEDIF function back? Personally, I am still running Excel 2013.

How much does accuracy actually matter to you?
If you want the calculation to be absolutely, 100% precise?
If you prefer a more rudimentary approach, you could certainly handle it that way. You can calculate the exact number of days between two dates through simple subtraction, then derive the years and months by using division combined with the ROUND function.
Strictly from a mathematical standpoint, if you are looking to calculate averages from data like this, my advice would be to keep everything in raw days. By subtracting the dates directly, you ensure you get an absolutely precise number of days. Only once you have reached your final figure—the average—should you bother converting that value into a Years, Months, Days format.

Benjamin Long7 said:Hi, I was hoping someone could help me write an Excel Macro.

I need to take the content from a specific cell and plug it directly into the "Find What" field.

The issue I'm running into is that whenever I run my current macro, it just uses the exact value that was sitting in the cell at the moment I recorded the macro.

What I actually need is the ability to change the value in that cell manually, and then have the macro search for whatever new content I've entered.

I hope that makes sense. 🙂

Thanks in advance. 🙂

Hmm, you aren't being entirely clear.
In any case, let's assume you want the term you're searching for to be pulled from cell A1, and the term you're replacing it with to come from cell A2.
You simply open the editor, define your variables, set the replacement range, and you're done.

For example:

Sub Macro1()

Dim trazi, zamjeni As Variant
trazi= ActiveSheet.Range("a1").Value
zamijeni = ActiveSheet.Range("a2").Value
'let's say you are replacing values on a different sheet
Sheets(2).Cells.Replace What:=trazi, Replacement:=zamjeni
'if you are replacing within a specific range on the active sheet (e.g., b1:b10), then:
ActiveSheet.Range("b1:b10").Replace What:=trazi, Replacement:=zamijeni

'
end Sub Hopa

Hope it helps.

restlessheron19 said:Is this actually possible?
Taking the text from cell A1...and pulling it into a comment...in cell B1?....
So, the comment would live in cell B1..

You can simply paste this code into the VB editor and run the macro.

Sub Macro1()

Dim a As Variant
a = Range("A1").Value
Range("B1").AddComment range
Range("B1").Comment.Visible = False '(or True, depending on whether you want the comment visible or not)
Range("B1").Comment.text text text :=a

end Sub

Steven Wright18 said:So the question is:

How can I keep, say, row 1 visible on my screen at all times, regardless of how far I scroll down?

Basically, that row contains my column headers where I enter data, and once I scroll down a few pages, I lose track of which column is which...

Thanks

Select the row directly below the one you want to stay visible; then head over to the Window menu and select Freeze Panes—that’s how it works in the 2003 version. It should be something similar in the newer versions as well.

William Gonzalez44 said:I didn't. Try adjusting the margins so there is actually some breathing room between the edge of the table and the page border.
I have no idea. I even tried resetting everything to default settings, but nothing helps.

I am still stuck using ancient versions of Windows, Excel, and Word 2003, so I can't say for certain how things behave on the newer software.

But consider this: did you change your pasting method? Perhaps you used to paste it as an image, but now you are inserting it as an object or something similar?

@William Gonzalez44/">@@William Gonzalez44
Did you perhaps increase the left and right margins in Word?

Rebecca Phillips57 said:To be honest, I find it baffling that there isn't a standard option—sort by evaluated value. 🤔

I don't have the energy to dig through this right now, but regardless of what she was thinking, I can't recall if I sorted by columns containing calculated results or just raw data... and whether I was using Excel, Open / LibreOffice, or Gnumeric 🤷
Again, my request is perfectly logical, so I'm left wondering if there is some setting within Excel itself that handles sorting this way. 🤔

Perhaps someone who has spent more time digging into this will chime in; it seems highly unlikely that there isn't a sensible way to do it.

In the old version of Word 2003, this works perfectly fine.
Why doesn't it work in the newer versions? 🙄

Or have I misunderstood the situation entirely?

EDIT: Isn't what Kyle Johnson2 wrote actually a way to sort it? Specifically, by a column that sorts based on the value, whether it's a formula result or not?

Bradley Gonzalez4 said:Now, just picture a kid who is constantly looking for the easiest path through life.
Imagine they’re eyeing a grueling major—something like pre-med at Johns Hopkins—but you spend their entire childhood telling them it’s just not their calling. 😁
You essentially drill it into them every single day that nothing is quite right for them. 😁
You end up motivating them with this toxic "if you can't do it, don't bother" attitude—basically implying everyone else is naturally superior to them. 😁

🙏

It is truly pathetic. 😢

My parents always told me that if I actually put in the effort, there wasn't anything I couldn't achieve.
God, as I get older, I find myself realizing just how much more I appreciate my parents.
It isn't that they have changed; it is simply that I have.

Edward Murphy4 said:This reminds me of an old friend of mine.🙄 Her parents basically worshipped the ground she walked on, and she turned into a total narcissist (with zero substance to back it up). She had such issues with everyone and everything around her that I was the only one who could stand her. Until one day, I couldn't.☕
And now she's miserable, mostly because nobody gets it. Nobody sees how "brilliant" and "stunning" she is.🙄
So yeah... don't go overboard with the (unearned) praise.

Children require both praise and criticism. In truth, they need dialogue. They are intelligent creatures, those little humans.

Your friend is simply one of many who believe the world owes them everything merely by virtue of their existence. That is almost certainly the result of faulty parenting. It isn't really about the praise itself; it’s about teaching children that rights come with responsibilities, and that things are achieved through effort and hard work rather than just being born special. This "I will give you everything while you owe nothing" style of upbringing is a perfect recipe for creating unhappy people—people who are miserable without any particularly valid reason to be. It's quite sad.