Reputation
5,095
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
20 56 109
Impact
~1.3m people reached

May
21
comment How do I list the SSL/TLS cipher suites a particular website offers?
And while it's great for public-facing sites, you can't use it for sites on networks that are isolated from the Internet.
May
19
comment What is the difference between SETX and SET in environment variables in windows
Also, see SS64 references for SET and SETX. SS64 is a great command reference for several languages and command environments - I find it particularly handy for CMD & PowerShell.
May
19
comment What is the difference between SETX and SET in environment variables in windows
Try SET /? and SETX /? - that should give you some ideas.
May
18
comment Return data based on matching date range
@MátéJuhász True. I'm not sure "Previous" and "Next" can really be figured properly without sorting, unless we have non-variable durations for the windows (we do) and define those in the formula. With sorting though, this will work in the "Helper Column" for all three: =IF(NOW()>=A2,IF(NOW()<=B2,"Current",IF(NOW()<=B3,"Previous","")),IF(AND(NOW()>‌​=A1,NOW()<=B1),"Next",""))
May
18
comment Return data based on matching date range
Bah. Looks like my idea might have caused a circular reference glitch.
May
18
comment Return data based on matching date range
I'm not much familiar with INDEX & MATCH, except that they're supposed to be superior in certain ways to VLOOKUP. That said, I think this is how I'd implement your suggestion with VLOOKUP, that also allows for easy coverage of Previous & Next: 1. C2=IF(C1="Current","Next",IF(C3="Current","Previous",IF(AND(NOW()>A2,NOW()<B2),‌​"Current",""))). 2. Copy C2 down to the end. 3. For "Current" we'd do =VLOOKUP(C:D,"Current",2,FALSE). 4. Write similar formulas as in 3, for "Previous" & "Next".
May
4
comment Dynamic monthly excel calendar
Fair enough. But most of the same people think "Computer" == "Windows PC". ;-)
May
2
comment Dynamic monthly excel calendar
Nice, but the question was quite particularly about Excel. That means two things: 1. Chances are, the asker has some particular requirement to work in Excel, or is most comfortable using that tool. 2. The asker is probably on a Windows system - maybe Mac. Definitely not Linux.
May
1
comment Dynamic monthly excel calendar
Ok, that's cheating. :-P
May
1
comment Dynamic monthly excel calendar
A copy or screenshot of your template would be useful. Also describe any existing formulas, and anything you've tried already. Seems like this should be doable, but would be very tricky. Is there any particular reason this needs to be in Excel, and not another application that's more particularly designed to handle calendars?
Apr
23
comment Why can't the VMs in my pen-testing lab ping each other?
I was going to say the problem is using "Host-Only", but the VirtualBox User Guide seems to indicate VMs should be able to talk to each other and the host in this mode. They will not be able to get out to the Internet though. In any case, I usually prefer NAT or Bridged for Internet-enabled VMs and Internal for isolated VMs. I haven't really played with Host-only much.
Mar
11
comment Tracking & Synchronization of Multiple Sheets with a Master Sheet
@agtoever That question appears to only address part of mine, if at all. It only describes how to gather data from multiple sources. This completely misses Step 1. Also, the suggested duplicate only covers "pulling" data from the multiple sheets - there's nothing indicating that the recommended tool can "push" updates from the master.
Mar
10
comment How to turn a “many” row-based relation into a “one” column based layout
@jolesexcel Good point. Sorry I missed that. Glad it worked.
Mar
10
comment Restore desktop keyboard to windows 8.1
Though functionality in the pre-boot environment would seem to render this moot, I still wonder what would happen if you plugged the keyboard into a different system?
Mar
10
comment Windows firewall rule order?
I'm not sure you really need a product recommendation question. You've already mentioned two pretty functional firewalls - Windows & Comodo. You just need to learn how to use one of them properly, and work with that.
Mar
9
comment Windows firewall rule order?
Withdrew my earlier comment after reading again how Windows handles its rules. I guess that makes sense to someone, but I'd rather it just do things in the order I tell it to. That said, a remaining problem appears to be that you're trying to use two firewall products on the same system. Pick one, move all your rules over to that, and kill the other.
Mar
6
comment Use WebGoat on Windows 8
@user2505650 Please don't cross-post. This question can be migrated. Also, you'll need to provide more detail. Like what you've done already, what errors have been encountered, etc.
Mar
5
comment why remote powershell session dose not need password
How is the VPN configured? Do you authenticate with Active Directory, or a separate account? What accounts are authorized on the server - domain only, or do you also have local accounts? Really though, you're this worried about security and yet you "allow unencrypted traffic"?
Mar
4
comment High-pitched noise from Logitech Performance MX
@AthomSfere According to Wikipedia, it supports 100-1500 DPI and uses a "Darkfield Laser". Logitech's product page further specifies that the sensitivity can be adjusted in increments of 100 DPI.
Mar
3
comment Win7 - Opening “Programs and Features” as Admin from command line (logged in as regular user)
@philx_x That may be possible via WMI, PowerShell, or Registry queries. I'd suggest asking a separate question.