I have a system dual booting Linux and Windows 10. After about 10-15 minutes of using Windows 10 the system hangs (no BSOD, just a completely unresponsive desktop.) After a soft reboot, the main SSD (/dev/sda) is missing from BIOS, and the system can’t be booted. After a hard reboot […]
Daily Archives: October 30, 2019
Could you help me creating a formula that makes it unnecessary to create the column D and gets the result using only one cell. I guess you would have to use an array formula but I can’t figure it out. I’ve used that formula in cell F2, but I would […]
I use 3d graphics software that has you press middle mouse button to pan around. Pressing and holding the middle mouse button for longer periods of time unfortunately puts a lot a strain on my wrist. I heard something about some feature where you can press a button and keep […]
So I was having a bit of trouble with Minecraft demanding I install 64 bit Java (I already had 64 bit) and so I decided to reinstall Java. I uninstalled my old Java, downloaded the off-line installer and I get an error along the lines of “Could not creat the […]
I did conditional formatting in cells that contain numbers. Those numbers are the ones that have different colors. I need to count the number of cells that have red numbers, green numbers and blue numbers. Which VBA code should I use? I have never worked with VBA before. Thank you.