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

3h
comment How do I display a message on login for Windows 8/8.1?
Note: Everywhere I've come across an online article on how to do this, they're just referencing the two "Interactive logon" settings I've already applied.
3h
comment How to add double quotes around data in tables using Calc
Calc should be using double-quotes when you save as CSV by default - if not, there should be an option to configure it. You can verify this by viewing the file in a text editor (e.g.: Notepad) instead of Calc.
4h
asked How do I display a message on login for Windows 8/8.1?
May
22
asked How do I manage trust exceptions in Firefox?
May
22
awarded  Nice Question
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?