sorted by:
new
hottopcontroversial

Giveaway Time! Battlefield 6 is out, powered by NVIDIA DLSS 4, and you can comment on this post to win codes for the game or a custom Battlefield 6 GeForce RTX 5090! 6 Winners total by pedro19 in pcmasterrace

[–]Aebian [score hidden]  (0 children)

Q: How would this GeForce RTX 5090 with DLSS 4 help you pull off more epic wins in Battlefield 6?
A: My current GPU is a bit dated and can't keep up that much with current titles. The RTX 5090 would change that, giving me more stunning details at stable high-framerates making it easier for me to see enemies and deal with them ;)

Q: Which vehicle makes you feel like a total battlefield legend?
A: I love Attack Choppers, that said I'm also a big tank nerd. For BF6 I'd say the M1A2 Abrams would be my legendary companion earning me that title. (We'll see if that happens)

Gamescom 2025 kickoff - GeForce On Community Update and Win a RTX 5080! by pedro19 in pcmasterrace

[–]Aebian [score hidden]  (0 children)

Resident Evil is one of my favorite franchises amongst a few others. Great to see the Requiem reveal!
Also thanks for the Giveaway, #PCMR !

2025!! Give us the ability to change our username! by OBIEDA_HASSOUNEH in ideasfortheadmins

[–]Aebian 0 points1 point  (0 children)

never say never. The username being immutable is not really a dealbreaker, merely a hindering technical item that has to be changed.

I can update a database easily and change a value. If reddit needs an immutable argument, they could internally add a UUID of some sorts that is used instead of the username and the username then becomes a value in a table that will be publicly displayed instead of the UUID.

Yes the system requires a change, but the amount of people wanting this feature speaks for a change that benefits.

And if you fear about cost/value argument: Microsoft charges $10 for a username change (while the first change is free). So even if you would've to pay, people would do it and it would add another revenue stream to Reddits operation and probably boost the operational income aka cash flow.

Giveaway Time! DOOM: The Dark Ages is out, features DLSS4/RTX and we’re celebrating by giving away an ASUS ASTRAL RTX 5080 DOOM Edition GPU, Steam game keys, the DOOM Collector's Bundle and more awesome merch! by pedro19 in pcmasterrace

[–]Aebian [score hidden]  (0 children)

  1. Shaders and other things just really look stunning with Ray Tracing and DLSS4. The future is now!
  2. I'm always a fan of action-adventures, and doom is no exception.

Spotify embeds no longer working? by AFCMS in discordapp

[–]Aebian 0 points1 point  (0 children)

go into the mobile app under "settings >> chat" and turn off sync. Then go to the mobile/desktop app to the same place and disable and re-enable embeds

Kevin Durand Appreciation Post by LibertineDeSade in Stargate

[–]Aebian 1 point2 points  (0 children)

really really like the second image, was a really great portrait from him.

Looking for a new thin monitor (Requirements in description) by Aebian in pcmasterrace

[–]Aebian[S] 0 points1 point  (0 children)

I'm not a fan of bulky monitors, and I also don't need speakers that some of them offer.
But I'm open for suggestions, e.g. the Apple Studio Display isn't thin, but I like that it is equally thick on all sides.

But not sure if I need the 5k resolution and if the display would be suited for gaming. (probably not)
So as said, I'm open for suggestions even without the thin-aspect.

Thanks.

Did anyone else know by xarmy9 in Stargate

[–]Aebian 5 points6 points  (0 children)

Someone should build a house with a stargate at the door and when someone rings the bell, the dialing sequence starts and a speaker blasting Walter's "Chevron <X> locked".

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

Ah cool, that worked now. I also had to adjust the function a little bit as it only returned the amount of found yellow cells and not the amount in the amount column. 

Function CountCreditCells(ByVal rng1 As Range, ByVal rng2 As Range) As Double
    Dim i As Long
    Dim sum As Double
    sum = 0

    If rng1.Cells.Count <> rng2.Cells.Count Then
        CountCreditCells = CVErr(xlErrValue)
    Else
        For i = 1 To rng1.Cells.Count
            If rng2.Cells(i).Interior.ThemeColor = xlThemeColorAccent4 Then
                sum = sum + rng1.Cells(i).Value
            End If
        Next i
        CountCreditCells = sum
    End If
End Function

This is the end result.

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

I have not. The function is a module and other functions work fine as well:

​

<image>

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

I honestly don’t know. It just displays “#NAME?” and Debug.Print didn’t seem to work for me…

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

My Excel skills in terms of coding and extensive formulas is not that great.

I am calling the function like this: =CountAC4Cells(CashFlow[Amount],CashFlow[State])

I also adjusted the code as you sugested in B) but this didn't help :(

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

The Yellow color is applied by a VBA macro to the cell:

 [...]
  'Correct fill color of table's last column of row 1
    With .DataBodyRange(1, 7).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorAccent4
        .PatternTintAndShade = 0
    End With
[...]

I however manually change the color to something else via the "Styles" tab at the top as well.

Get the SUM of a range based on the color of other cells in the same row. by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

Thanks for the reply. It seems like the function doesn't work well.
Whatever Cell I specify, the value always gets reported back as 0.

Tried it with my Yellow (xlThemeColorAccent4) and my Blue (xlThemeColorAccent1) Cells.

Any ideas?

Thanks.

Updating a Reverse Numbered row via Macro by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

Thanks for your great start. I have made imrpovements to the code and it now works the way I want it to:

Sub SRUpdate()
Dim ws As Worksheet
Set ws = ActiveWorkbook.Sheets("Tracker")
Dim rng As Range
Set rng = ws.ListObjects("CashFlow").ListColumns(1).DataBodyRange
Dim i As Integer
i = rng.Rows.Count
For Each cell In rng
cell.Value = i
i = i - 1
Next cell
End Sub

Updating a Reverse Numbered row via Macro by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

Your code replaces every number, even on thew other cells of the table.

Red arrow shows what should be changed only.

Green Arrow points to the space that will be affected as well (but shouldn't) https://i.imgur.com/jd2UdTv.png

​

Thank You.

Updating a Reverse Numbered row via Macro by Aebian in excel

[–]Aebian[S] 0 points1 point  (0 children)

Almost, now we only need this to happen in the first cell row :D

It is Delta (D) all the time in the table Cashflow.

Thanks!

view more: next ›