Reputation
5,203
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
21 57 113
Impact
~1.5m 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
18
asked Return data based on matching date range
May
13
awarded  Famous Question
May
4
comment Dynamic monthly excel calendar
Fair enough. But most of the same people think "Computer" == "Windows PC". ;-)
May
2
revised Dynamic monthly excel calendar
added 103 characters in body
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
revised Dynamic monthly excel calendar
added 100 characters in body
May
1
answered Dynamic monthly excel calendar
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.
Apr
21
awarded  Notable Question
Apr
9
awarded  Notable Question
Apr
2
awarded  Notable Question
Apr
1
awarded  Popular Question