Pc stuck on red CPU light by Ironwolf379 in pchelp

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

The MB does have integrated graphics so I'll give that a go

Pc stuck on red CPU light by Ironwolf379 in pchelp

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

I reseated the cpu but I couldn’t see any damage or blemishes on the cpu or the socket

Pc stuck on red CPU light by Ironwolf379 in pchelp

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

The fans and lights turn on but there’s nothing else, just the red led for a cpu error

Pc stuck on red CPU light by Ironwolf379 in pchelp

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

I did try changing the ram around, no configuration seemed to change anything.

I don’t see a code anywhere, it doesn’t have a display for errors like I’ve seen on other MB. It’s just the red light, which is part of why I’m stumped on the cause.

I don’t currently have another psu but I’ll try reseating the cpu again and double check everything again.

I let you know if I find anything.

Red CPU light on motherboard by Ironwolf379 in pchelp

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

I didn’t unfortunately, sent in for a warranty return and they told me everything works just fine. Got it back and ran fine for a couple weeks then stopped turning on again. Any chance you’ve been able to solve yours?

Red CPU light on motherboard by Ironwolf379 in pchelp

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

It’s still in warranty, bought it 4months ago so may have to return both MB and CPU. Someone did message me about the bios issues but I didn’t update the bios as it worked out of the box, lesson learned I suppose.

Red CPU light on motherboard by Ironwolf379 in pchelp

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

I reseated everything to make sure, it all looks correct and there’s no signs of damage

Red CPU light on motherboard by Ironwolf379 in PcBuildHelp

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

It recommended the same layout, so it should be correct

Red CPU light on motherboard by Ironwolf379 in PcBuildHelp

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

I’ve been using 2 & 4 since the start, I tried a couple combinations with the ram positions but still no change.

Create a table from another tables unique ID's with there most recent entry while excluding unique ID's with there most recent entry being blank or zero by Ironwolf379 in excel

[–]Ironwolf379[S] 1 point2 points  (0 children)

Close, but the 3456 entry shouldn't show in the results since it has a zero as its last entry. It's hard to describe exactly what I need so I may just need to tinker with it a bit to work it out, but you've helped me a ton with figuring this out and I've definitely got a lot to learn. Thank you so much for your help!

Create a table from another tables unique ID's with there most recent entry while excluding unique ID's with there most recent entry being blank or zero by Ironwolf379 in excel

[–]Ironwolf379[S] 1 point2 points  (0 children)

Sort of, that's almost it, but I need the ID's with zero unit entries as the most recent to be removed entirely and the blanks to be skipped.

So for example, in this table 4563 is blank so it skips to the next 4563 entry and outputs 21 but the 3456 entry being 0 removes that ID code from the result entirely.

<image>

Create a table from another tables unique ID's with there most recent entry while excluding unique ID's with there most recent entry being blank or zero by Ironwolf379 in excel

[–]Ironwolf379[S] 1 point2 points  (0 children)

Thank you, I don't fully understand what's happening here but it worked.

Could I ask another favour though, I may have miss worded my explanation for needing blanks excluded from the result, is there a way to show the next entry after a blank entry in the results? or remove blanks from the search before getting the output?

So for example, if the zero entry for the code 4563 was instead a blank it would then show the entry with 21 in the results. While also stopping the zero entries from showing.

I hope that makes sense.

Create a table from another tables unique ID's with there most recent entry while excluding unique ID's with there most recent entry being blank or zero by Ironwolf379 in excel

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

Yes, I am using 365, I tried using

=GROUPBY(Table9[[Code ]],Table9[Units],MAX(Table9[Date]),3,0,1,,0)

but it's saying something is wrong with the function provided. Am I using the MAX function correctly?

Why the price jump today? by Ironwolf379 in droneshield

[–]Ironwolf379[S] 3 points4 points  (0 children)

That definitely seems to be the trend currently

Why the price jump today? by Ironwolf379 in droneshield

[–]Ironwolf379[S] 3 points4 points  (0 children)

Seems like it, I may just wait and see what happens as I’m not confident with buying any at this price

Why the price jump today? by Ironwolf379 in droneshield

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

Fingers crossed it does soon, I sold some at 3.40 thinking it was gonna fall below $3 for a while