4,418 reputation
164699
bio website security.stackexchange.com
location Florida
age 32
visits member for 4 years
seen 12 hours ago

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


May
16
comment How can I check a system's current NTP configuration?
The /query option is not available on XP.
May
16
comment How can I check a system's current NTP configuration?
No good on XP. "The command /query is unknown."
May
16
comment How can I check a system's current NTP configuration?
@Kyle I just figured out that net time /querysntp shows the server. Getting the rest of it might be tricky.
May
16
asked How can I check a system's current NTP configuration?
May
15
accepted How do I add an icon to my custom context menu entry in Windows XP?
May
10
comment Only show a formula result if it meets given criteria
Nice idea, but this only really adds to the confusion when I go to review the spreadsheet later on, since the primary function of the cell is no longer represented within itself.
May
9
comment Formula to return value from one column when condition is met for the first time in another
@barryhoudini Maybe suggest that as a separate answer, and give a bit more explanation? For example, I'm confused by your use of TRUE as an argument for MATCH. Also, cell references should still be entire columns, like in chris' example - the size of my data set will vary.
May
9
comment Ping a PC connected through crossover cable to one connected to router
Sounds like you're looking for Internet Connection Sharing, or something similar. Search Super User for that term, and see if that helps.
May
9
revised Only show a formula result if it meets given criteria
added 377 characters in body
May
9
asked Only show a formula result if it meets given criteria
May
9
accepted Formula to return value from one column when condition is met for the first time in another
May
9
revised Formula to return value from one column when condition is met for the first time in another
added 57 characters in body
May
9
comment Formula to return value from one column when condition is met for the first time in another
Also, in the real spreadsheet, the data I want returned is non-numerical. Thank you for drawing my attention to essential details I should keep in mind, when asking future questions.
May
9
comment Formula to return value from one column when condition is met for the first time in another
That's what I thought, but was wondering if there was some other reason. This seems the most versatile of the options given, and works for me. Thanks!
May
9
comment Formula to return value from one column when condition is met for the first time in another
Way to work around the given problem. I could use this for some applications, but part of the problem with this lies outside the given example - in the real spreadsheet, the decrement changes after a certain point. So, I really need to get the "find first negative" effect.
May
9
comment Formula to return value from one column when condition is met for the first time in another
I'm not sure why volatile vs. non-volatile is relevant here. Could you explain a bit more?
May
8
asked Formula to return value from one column when condition is met for the first time in another
Apr
25
awarded  Popular Question
Apr
24
revised Is there any way to elevate a command prompt in Windows 7?
added 239 characters in body
Apr
24
comment Is there any way to elevate a command prompt in Windows 7?
Looks like Oliver's link might be the killer for this question, but the link Horst gives has an answer (not the accepted one, but further down) that points to some "Power Toys" which may be of use. Unfortunately, the Power Toy seems to be more like sudo when I'm really looking for su.