I am trying to make a cell display a value dependent upon the value of another cell. e.g. If cell A1 contains "1st" i want cell b2 to calculate that as the number 25. Easy enough, but the trick is i want to also have Cell b2 calculate as 17 if i input the value 2nd into cell A1 and so forth. So far ...

After selecting some files/folders in Explorer, I can right-click them and choose Create shortcut, is there a keyboard shortcut to do so?

ctrl + f gets you to find words, and a simple enter brings you to the next word. What hotkey takes you to the previous word?

I am able to open CRX files by changing the file extension to .zip, but when I am trying to get files that make up a theme, I can't find any. I'm assuming their in a file with the name "Cached Theme.pak", since that's the only file I haven't checked. The problem is that I can't open this file, I hav...

I used diskcryptor to encryption my C: drive, the process is done by using default encryption setting. However my Acer aspire v nitro laptop won't boot and stuck at the attempting repair screen. I tried to run the command chkdsk in cmd but it shows that my C: is not accessible (which is normal due t...

Just fresh installed Windows 10 a few days ago and everything works fine, except for two things: The inability to set default apps, and the inability to remove the "- Shortcut" text from shortcuts. I have installed every single update there is but those two things consistently fail. Every time I cho...

More than likely, your new laptop is using a SATA controller that is newer than what was shipped when Windows 7 was released. If Windows doesnt have the driver for the SATA controller, it ca ot see any disks that are co ected to it. You should be able to go to your laptop manufacturer's website and ...

I have an Excel workbook (just a spreadsheet, really) that I live and die by every day. It is stored on Dropbox, and I will open and edit it as needed several times each day from my iPhone and/or my Mac. The problem is that when going to it, as saved by the phone, when I'm using the Mac, the file op...

I am going to store a lot of files in archives without compression and i'd like to pick the container format that gives the best search and random access speeds. So far I've found that: (I am not sure about rar files.) My guess is that having the table of contents at the begi ing should be better, b...

This issue has been bothering me ever since my mom tu ed off my computer a few days ago and I tu ed it back on the next day to do some work. Right-clicking on any file or folder in Windows Explorer causes an hourglass icon to appear; the Explorer window inevitably goes Not Responding and when I clic...

Can/should you use a: 28 inch 4K monitor (3840 pixels × 2160) with a Dell XPS 13 (13 inch, 1920*1080, i5 5200 @2.20 gHz, 8 gig ram) laptop with a Intel HD Graphics 5500 (shared inte al graphics) and mini display port. Not for gaming. The main thing I want is a large monitor that I can use to have 4 ...

I've found the easiest way to resolve ssh co ection issues is to use the debug mode of both the client and server applications. On one machine, we'll call it pcA, open a terminal and run the following command: /usr/sbin/sshd -d -p 2222 On the other linux machine, pcB, enter this command and watch th...

Since I started using Display Port, Windows is intolerant of me tu ing off the displays. It thinks it's been taken away never to retu or something, and scrambles all my window locations to sbrink them and arrange on the main screen. This was seen on Win7 and now on Win10. For some reason it won't sh...

I want to make sure that I understand docker correctly here. My principal goal is to distribute little pieces of software (usually with full source-code) I write in Python/Haskell or C++ to my friends and colleagues. I myself work on an Ubuntu 14.04 machine. But often the people whom I distribute it...

Aim The aim is to install apache on CentOS7 and Ubuntu-16.04 using Vagrant. Vagrantfile config.vm.define "vm_one" do |vm_one| vm_one.vm.box = "centos-7.0" vm_one.vm.provision "shell", path: "scripts/centos.sh" end config.vm.define "vm_one_ubuntu" do |vm_one_ubuntu| vm_one_ubuntu.vm.box = "ubuntu-16....

TAB key by default just puts a tab, and only indents depending on several contexts, which I don’t understand quite well. { "keys": ["tab"], "command": "reindent", "context": [ { "key": "setting.auto_indent", "operator": "equal", "operand": true }, { "key": "selection_empty", "operator": "equal", "op...

I am facing a problem with my LG phone, suddenly while I am using Facebook messenger it close and never open again, it just show black screen with LG logo and stuck on this screen I have tried to hard reset it using (Power + Volume Up), (Power + Volume down), (Power + Volume Up + Home), (Power + Vol...

I'm trying to understand how the whole thing works and I don't understand why I can't search for a string in wireshark when I visit a non-encrypted website while capturing packets for that website IP. Can't find a single word that appear on the browser. Any idea how this works ? This entry passed th...

I have 16G ram and 2T hard drive, then added 120G Samsung SSD as new boot C: (had shop do it) and 2 things happened. The performance was much better for Win boot, but sometimes on opening a drive or a directory that green bar that paints on top of the box would take a minute maybe even 4 mins to slo...

im trying to setup some dns/ptr records for my home network lab, right now i have entry's of "computer1.lab.local" or computer2.lab.local, and im trying to configure my dns to put entry like computer1.lab.local > dhcp-192-168-1-12.lab.local computer2.lab.local > dhcp-192-168-1-13.lab.local i've seen...