4,543 reputation
144597
bio website security.stackexchange.com
location Florida
age 32
visits member for 3 years, 11 months
seen 1 hour ago

I'm not the droid you're looking for.


Jul
31
comment Install Windows 8 to last partition on drive
Windows wants desperately to be the only OS on the system. The easiest way to do a dual-boot install is always to install Windows first.
Jul
31
comment Two users on Windows 7 connected to different networks?
What you're looking for is called "split tunneling" and is commonly disabled in the VPN policy for security reasons. Contact your organization's IT Security department for more information. Without violating security policy, you won't be able to get the same system talking to both the VPN and your local network at the same time. A common workaround, as you've apparently discovered, is to run the VPN on a VM and use the host computer for access to the local network. Or, just use two wholly separate computers.
Jul
31
comment Create New Spreadsheet of data from many Excel workbooks
Are you looking for a one-time consolidation, or do you want to continue updating the individual sheets and have those updates pushed to (or pulled by) the master?
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
I've flagged the question for migration. This will require either moderator action, or concurrence by four other users with close-vote permissions. Please be patient.
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
There are ways to migrate local profiles to domain profiles. Have you considered that? This sounds more like a problem for Server Fault - please don't cross-post, we'll see if it needs to get migrated.
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
This depends on which SQL database application you're using, and how it's configured. At the very least, you will need to configure a user account in the database for the user.
Jul
31
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
@114 Your current question is also unclear on this point. You say "I realized, however, that the true problem is not to have the most recent date returned if the condition is met, but to have the date returned if it is greater than and within 2 days ..." the phrasing implies the most recent date from LargerSheet is still fine, but needs to be disqualified if it is in excess of two days after the reference date on Sheet1. If your matching criteria really needs to be "any date on LargerSheet that is within two days after the reference date on Sheet1", the formula needs more significant work.
Jul
31
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
In short, this all could have been answered with one Q&A instead of two or three if the question itself was properly formulated and detailed and the had properly followed instructions. Plus, it helps when they are able to do at least minor pieces of the work themselves.
Jul
31
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
@Hannu Oh, it's easy to provide useful advice for stuff like this. However, a few things need to happen which didn't quite go right here: 1.) The Asker needs to provide clear and specific details about how their sheet is laid out, and everything they're hoping to achieve with the component in question. 2.) The Asker needs to properly follow instructions and examples provided by Answerers. OR 1.) The Asker should be knowledgeable and capable enough to recognize, and make changes, when formulas provided by Answerers need to be adjusted to match their actual spreadsheet layout or intent.
Jul
31
comment Run a block conditionally on grep output
Got it. And right now all you want to do at this point is output a list of the systems which have non-commented CardSwipe lines, right?
Jul
31
comment Run a block conditionally on grep output
Ok. I think I've got a PowerShell fix for you.
Jul
31
comment Run a block conditionally on grep output
And I should be learning RegEx. Could you parse that grep for me? Particularly, what sorts of strings are you trying to match?
Jul
30
comment Run a block conditionally on grep output
Which version of Windows? If Vista or later, PowerShell is probably better suited.
Jul
30
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
You've got duplicate entries in LargerSheet - is that expected?
Jul
30
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
It really looks to me, unless there's another part you're leaving out, that this question is pretty close to what you actually want. So creating another separate question might not be a good idea - just edit any new details needed into this one.
Jul
30
comment Indexing a Date Range if Date is Greater Than and Within n Days of Another Date
@114 If the question needs to be substantially re-written in order to accurately reflect your needs, it might be worthwhile posting as a separate question. Otherwise, you should edit this one to be more clear. Note that if the new question isn't actually that different in purpose, a separate thread may end up closed as duplicate. Also, could you throw in two more columns to your sample data - one for the expected output for each row and another giving the reason why that output is correct? That will help clarify things a bit more.
Jul
30
comment How do i connect to a built-in webcam on my windows 8 laptop?
It may be under "Other Devices" - what you're looking for is anything indicating some sort of trouble, usually having a yellow "Warning" icon on it.
Jul
30
comment BitLocker (Lost bitlocker password and recovery key)
@DewnSara_Hyo Unfortunately, this is the answer. Whether you like it or not is not going to change the fact that your data is irrecoverable until such time as you either remember the password or find the recovery key. Of course, someone could always find some flaw in the encryption algorithms or their implementation in BitLocker. However, that's been tried and tested - and some parts even thoroughly reviewed by the community - for years (BitLocker itself is over 7 years old), so don't hold out hope for it any time soon.
Jul
30
comment View the current day in the taskbar
This can also affect the way some software (e.g.: Office) handles date formats. My personal preference is dddd yyyy-mm-dd which shows the day of week, followed by the ISO-formatted date. I also suggest stretching your taskbar to two rows high so the clock and notification area doesn't take up so much screen width.
Jul
30
comment What is the best way to open a file for editing from a web page
Sounds like what you really need is SharePoint, or a comparable solution.