Reputation
5,293
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
21 58 113
Impact
~1.5m people reached

Feb
12
comment Tracking & Synchronization of Multiple Sheets with a Master Sheet
@NWest Named tables probably is one option to make things easier. The problem with using things like VLOOKUP or INDEX/MATCH though is they're pull-only operations. I need to be able to push and export as well. I'm not expecting to be able to do both at once, but I do need to be able to do each as needed without overhauling the sheets every time or leaving a lot of "guts" (e.g.: otherwise-temporary helper columns) exposed all the time.
Feb
12
revised Tracking & Synchronization of Multiple Sheets with a Master Sheet
added 952 characters in body
Feb
12
revised Tracking & Synchronization of Multiple Sheets with a Master Sheet
edited body
Feb
12
asked Tracking & Synchronization of Multiple Sheets with a Master Sheet
Feb
10
comment Windows 7 - how to use LAN as main connection & Wifi as secondary connection
Not quite the fix I was suggesting, but that'll work too.
Feb
10
comment ping results are opened in new window when using powershell 4.0
Better test - this will check all profiles which may apply and dump their path and contents if the profile exists: $profile|gm -M NoteProperty|%{$x=$profile.($_.Name);if(Test-Path $x){$x;gc $x}}. If you get no output, no profiles exist. If all you see are filenames ending in profile.ps1, then you've got some blank profiles - effectively the same as if they didn't exist. If you see filenames and some script content, then you've got stuff in those profiles.
Feb
10
comment ping results are opened in new window when using powershell 4.0
@VikashKumar "Not that I can recall" is not generally a useful or authoritative troubleshooting response. Please try Get-Content $profile from the PowerShell console. If there's no output, you don't have anything configured in your profile.
Feb
10
comment PowerShell issues with spaces in directory names
You may need single-quotes instead of double-quotes. Try this: 'D:\Joshua\!Coding\Git stuff\centaur-XML-Tool\gource\executables\run-gource-for-windows.ps1' or this Set-Location 'D:\Joshua\!Coding\Git stuff\centaur-XML-Tool\gource\executables\';.\run-gource-for-windows.ps1
Feb
10
comment Extract site names from properties application pool
I'm familiar with PowerShell, but not so much IIS, so I'm not posting this as an answer unless validated: Try (Get-Item IIS:\AppPools\tech-2).Applications
Feb
10
revised 15 digit number with a letter on the end
deleted 146 characters in body
Feb
10
answered 15 digit number with a letter on the end
Feb
10
comment Windows 7 - how to use LAN as main connection & Wifi as secondary connection
Depending on your device, the option to set the auto-switch may be in your BIOS/UEFI and/or in the "Advanced" tab on the Properties dialog for it in Device Manager.
Feb
10
comment Windows 7 - how to use LAN as main connection & Wifi as secondary connection
This is somewhat dependent upon your device manufacturer and drivers. There may be an option to automatically disable WiFi completely upon connection to a wired network, and re-enable it upon disconnection from the wire. Alternatively, there's probably a hot key combination (Fn key plus one of the F keys) that will easily toggle the WiFi or "Airplane Mode" on-demand. Note that setting of auto-switch may override your hot key's capability.
Feb
3
awarded  Popular Question
Jan
19
awarded  Notable Question
Jan
15
awarded  Famous Question
Dec
27
awarded  Notable Question
Nov
14
awarded  Famous Question
Nov
6
awarded  Notable Question
Nov
4
comment Sleep mode vs. hibernation power usage and safety
Hibernation just writes the RAM to disk, then uses a special boot process to restore the working state to RAM from the HDD.