tl;dr How can we force Excel to lock-in a filter for a Column which only has 1 unique value within it? I am having a very hard time coming up with a nice "label" for this problem, so I believe it is best if I do it with an example. In these examples, I am using an excel sheet where Column 1 represen...

With my picture I'm trying to figure out what formula to use when adding the number of points that a different from one another (8) and (28) to add up to (36 total points). Yet have a different formula when entering the score.

Quite often I will have to click on a link a second time after the page loads with the same thing to go to the second link. As in, I'll be on let's say stackexchange and I'll click on a link to go to another board or ask a question. The page will reload with the same content and I'll click on the li...

Here is the scenario. I tu on the laptop, it loads, the login screen comes up. I enter the correct credentials and it says "Welcome" and the cursor tu s into the loading symbol. However, shortly after, the symbol freezes, and I can't do anything but move the useless cursor around. If I wait around l...

I have a oying issue I get this visual problems I don't know with what http://imgur.com/Pdq05mL browser Opera I have tried changing refresh rate from 60 to 75 Hz but sometimes it doesn't improve

I have an ASUS G750JX laptop ru ing Windows 8.1 that's recently been experiencing difficulty booting. The hard disk light flickers off after a few seconds and the computer just sits on a black screen until it's tu ed off. Previously, holding the F2 button would cause the hard disk light to flicker w...

We have a OSX.10 MacPro that runs AFP (apple file protocol) file sharing services (client version, NOT server) on a gigabit network with approximately 20 machines. A regular need is 1 or several networked clients streaming (playing via application) from the MacPro via a file sharing volume. From the...

Some programs seem to prefer to use an SSH key agent, rather than specifying the key file in some configuration file somewhere. Examples: What is the reasoning for using a key agent, rather than pointing each application at a file containing your key? Is there a security difference, or is it just fo...

I've installed CSF firewall on my linux, and I have set in my csf.conf: # Allow incoming TCP ports TCP_IN = "22,25,53,80,110,143,443,465,587,993,995" # Allow outgoing TCP ports TCP_OUT = "20,21,22,25,53,80,110,113,443,587,993,995" # Allow incoming UDP ports UDP_IN = "20,21,53" # Allow outgoing UDP p...

I have Debian 2.6.32-5-686-bigmem installed with virtualmin and need to upgrade to Debian 7 wheezy. Found a guide: https://www.virtualmin.com/documentation/system/os/debian-squeeze-to-wheezy-distupgrade Am I safe to follow that guide? Thanks,

i would like to know if it is possible to RUN mac OS X (preferably el capitan) ON a usb drive. i am not talking about installation usb drive to install mac OS X on my computer, i am talking about installing mac OS X ON a usb drive and run mac OS X FROM THAT usb drive, with the usb drive acting like ...

I configured my Raspberry Pi as a softether VPN server (according https://jlnostr.de/blog/raspberry-pi-sstp-vpn-server-installieren/). I can now create a VPN co ection from my Windows machine to the Raspberry. The Windows machine gets the VPN-IP 192.168.30.10 and the Raspberry has the VPN-IP 192.168...

I'm trying to a get a Java Program ru ing on Windows to perform a (java) Thread Dump; on Linux I would use: kill -3 <pid> Is there a Powershell equivalent of this ? I tried: debug-process -Id <pid> This just brought up a Visual Studio Debugger (fair enough I guess) - but I couldn't see how to get a ...

I've setup a simple rule on one of our mailboxes which replies to every email it receives using the "have server reply using x" rule. This is just to send a confirmation of receipt email to anyone who sends something in. The rule also ignores our inte al domains (using "except with x in the senders ...

We have a laboratory instrument ru ing Windows Embedded Standard (not sure if it should have been tagged windows-embedded-7 or windows-embedded-2009 since the Windows edition is described only as Windows Embedded Standard, Copyright 2010, SP 1). At some point we had it mounting a share on our networ...

how to ssh login using putty ,then ru ing the pbrun with its login details, and to run a few commands using a batch file. Currently i tried doing C:pathtoputty.exe -load "[Sessio ame]" -l [user] -pw [password] -m C:pathtocommands.txt command.txt include pbrun use ame pwd reason remove folder command...

I joined in a workgroup and now I don't know how to remove the PC from the workgroup. In addition, I keep getting a message that I need to re-image my computer. And the OS loader isn't found, the generic something or another failed. Hoe can I resolve this? Let's block ads! (Why?)

I have a dual-boot setup on my Asus Laptop. I have an SSD which holds my Windows 10 and an HDD which holds my Linux Ubuntu and a partition for data for windows. My laptop also uses UEFI. When i boot into Linux and restart my computer after, everything goes fine. But when i boot into windows and rest...

I am trying to make a summary of some cleaning results in Excel with the aid of a Pivot Table, but I am experiencing some troubles wrapping it all up. I have the following data: Cleaning 1 Location 1 Result 1 Cleaning 1 Location 2 Result 2 Cleaning 1 Location 3 Result 3 Cleaning 2 Location 1 Result ...

I want to set my Windows 7 the minimum basic state. I want to keep only the services and configuration that allow direct-show apps(media), CD bu ing, and printing to function. So appreciate any info, and advises.