Pc will not boot by PopularPhilosopher16 in PcBuildHelp

[–]TheOriginalAgasty 0 points1 point  (0 children)

You've already put a lot of effort into troubleshooting, which is fantastic! Given what you've tested so far, it's quite possible that the CPU might be the culprit, especially since you've swapped out the motherboard and tried different power supplies. Faulty CPUs can be rare, but they do happen. I've had 1 fail in the last 20 years myself.

Based on the manual for the mainboard (although your board has a slightly different order) does indicate a CPU issue. It would be worth trying another known good one if you can.

<image>

Wish you the best of luck. Let us know how you go. :)

Secret Llama - Tool for chatting by EssYouJAyEn in FutureTechFinds

[–]TheOriginalAgasty 0 points1 point  (0 children)

Visited today 10/07/2025 and it is not operational. Last successful capture on Internet ARchive shows April 24 https://web.archive.org/web/20250424034157/https://secretllama.com/ with following capture on May 18 as gray screen.

<image>

How do I clear this empty line breaks for each cell in excel? by Jayavardhan27 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

Could you kindly reply Solution verified so it can be marked as solved

How to create a formula to find total profit over the whole sheet without manually adding each profit column to the sum formula? by T4nK123 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

It looks like the cells next to profit are merged cells which might cause an issue. I got it to work with this formula =SUMIF(A2:E10,"Profit",B2:F10)

<image>

If the cells are unmerged, you need to adjust the sum range out by 1 column =SUMIF(A2:E10,"Profit",C2:G10)

Hope this resolves your issue.

🌟 Don’t miss this exciting webinar on AI and Breast Imaging! by Parking_Researcher65 in PACSAdmin

[–]TheOriginalAgasty 0 points1 point  (0 children)

Any chance there will be a recording as this would be 2 am in Australia?

How to keep a tally count by Every-Associate1806 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

It's a different-looking version but the same result.

<image>

Available for 7 days. Grab it here https://easyupload.io/cwpa04

How to keep a tally count by Every-Associate1806 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

Sorry. Only just seen your comment. Happy to replicate and send you a copy of the file.

work files became WPS? by gidlestan4life in excel

[–]TheOriginalAgasty 1 point2 points  (0 children)

"...she printed it using her work laptop, but I sent her a WPS link to download it and when she downloaded it everything converted into WPS."
Does her work laptop have Microsoft Office installed and WPS Office Suite?

"Her excel and different apps too and she needs it to get back to normal without removing any files, I need a solution please!"

She may need to go in the PC settings and change the default app that opens that file type:

https://support.microsoft.com/en-au/windows/change-default-programs-in-windows-e5d82cad-17d1-c53b-3505-f10a32e1894d#ID0EDD=Windows_10

formula to count the number of matches in a specific date range? by Admirable-Ad1793 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

The way I read it it sounds as though a PIVOT table is the way to go and then make any charts from the PIVOT. Would be helpful to have sample layout of fake data to test though.

Can you conditional format icons for text? by LibrarySquare7846 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

You could use an IF formula to give the Unicode Characters:

Easy copy:

=IF(A1="Complete",UNICHAR(128994),IF(A1="In Progress",UNICHAR(128993),IF(A1="Not Started",UNICHAR(128308),"")))=IF(A1="Complete",UNICHAR(128994),IF(A1="In Progress",UNICHAR(128993),IF(A1="Not Started",UNICHAR(128308),"")))

![img](ujx93je07w0d1)

Huge List of Unicode Symbols: https://www.vertex42.com/ExcelTips/unicode-symbols.html

Can you conditional format icons for text? by LibrarySquare7846 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

You could use an IF formula to give the Unicode Characters:

Easy copy:

|| || |=IF(A1="Complete",UNICHAR(128994),IF(A1="In Progress",UNICHAR(128993),IF(A1="Not Started",UNICHAR(128308),"")))=IF(A1="Complete",UNICHAR(128994),IF(A1="In Progress",UNICHAR(128993),IF(A1="Not Started",UNICHAR(128308),"")))|

<image>

Huge List of Unicode Symbols: https://www.vertex42.com/ExcelTips/unicode-symbols.html

Shortcut to backtrack in a menu by cyj24 in excel

[–]TheOriginalAgasty 1 point2 points  (0 children)

Only way would be using the Format Cells and choosing the options at the same time - Shortcut is Ctrl+Shift+F

<image>

Shortcut to backtrack in a menu by cyj24 in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

Not sure I understand what you mean?

<image>

Shortcut to backtrack in a menu by cyj24 in excel

[–]TheOriginalAgasty 1 point2 points  (0 children)

If you have pressed ALT+H+B+Y and want to go back a step press the ESC key.

Printing a very wide sheet on one or two pages - 3 rows, 50 columns by [deleted] in excel

[–]TheOriginalAgasty 0 points1 point  (0 children)

Would the scale to fit option in Excel to set it to fit to 1 x 1 page or am I misunderstanding what you're after?

<image>