Reputation
5,572
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
25 62 119
Impact
~1.9m people reached

Nov
5
comment Outdated Trusted Root Certification Authority in Windows 7?
There is a big difference between the issue in the article and yours. The article targets small companies who are having problems because their websites are often not signed by one of the big universally-trusted Root CAs. The problem you are having is with accessing the website of one really big company who does have SSL certs signed by one of the regular Root CAs. There's no reason you should be using OpenSSL as described in that article to create certs for Google's websites. Make sure your system time is correct, and you've applied all OS & browser updates.
Nov
1
comment How do I calculate clock speed in multi-core processors?
Many of the answers here do a good job of explaining why e.g. a quad-core 2 GHz processor is not necessarily equal to a single-core 8 GHz processor. However, I'm having a difficult time divining how multi-core processor speeds should be regarded when deciding a system's suitability for an application that lists a specific speed and number of cores in its requirements? (e.g.: Borderlands 2 requires a 2.4 GHz dual-core processor. Should we expect a lower-speed quad-core, or higher-speed single-core to do just as well?) Is that (or could it be) answered here, or should it be a separate question?
Oct
31
comment Word 97 Printer Properties crashes
No, I'm talking about whatever is supposed to finish the sentence "We can also go to Printer and Faxes, select the printer, and..."
Oct
30
comment Word 97 Printer Properties crashes
It looks like your question is missing some details, just before the event log information. Could you fill in the missing bits?
Oct
24
comment Freeze top row and multiple columns in Excel
See this question for my real issue.
Oct
24
comment Freeze top row and multiple columns in Excel
Ok. I think I found the answer to the question I asked, but then realized the question I asked is the wrong question. Select I2, then use Freeze Panes. This will freeze what I've described, but not quite in the way I really want it.
Oct
24
comment Freeze top row and multiple columns in Excel
No tables, no filters. There's some named ranges, but none for which this makes sense.
Oct
24
comment Freeze top row and multiple columns in Excel
That froze A:I and rows 1:12.
Oct
22
comment Comparing two columns in Microsoft Excel
I've recently also discovered ISERROR, which can shorten this up a bit. Will edit later.
Oct
22
comment Comparing 2 columns in Excel
Combine IF, IFERROR, and VLOOKUP. That's all I'm going to say, as I'm sure someone is about to link a duplicate somewhere here.
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
Done. I'm glad to hear it's working for you. I'm in the same boat as you. I much prefer to hack things natively, but if the best option really is add-on software then so be it.
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
Thanks for the clarification. Is this something you must solve natively, or would you consider add-on software? I use DisplayFusion myself.
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
Wait, I'm confused. I was thinking it was tied to Monitor 1, not necessarily your primary display. Have you determined which it is?
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
It seems the orientation of your wallpaper is (strangely) fixated to the upper-left of Monitor 1, regardless of whether it's primary or secondary or where it is located in relation to the others. The re-arrangement I've proposed should resolve that.
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
I'm not proposing you swap the physical position of your primary monitor. I'm suggesting you swap the physical position of the two monitors, and re-assign them in Windows so that your primary monitor is still where it's supposed to be. i.e.: Physically move Monitor 1 so that it is where Monitor 2 is now, and vice-versa, then rearrange them in the Windows display configuration accordingly and set Monitor 2 as your primary.
Oct
22
comment How can I set a dual-display, single-background when my primary display is on the right?
This is a good question to leave open for people who are in a similar situation with different configurations. However, for your situation, it appears you have two identical monitors - at least in terms of screen resolution. Would it be too much trouble to just physically swap the relative locations of the monitors?
Oct
17
comment Can Excel use formula-input data for cell references?
Thanks, but I'm not sure why you're suggesting another cell. For the given scenario, the solution for A2 is =INDIRECT(CONCATENATE("'",A5,"'!A2"))-INDIRECT(CONCATENATE("'",A6,"'!A2")). You especially want to include those single quotes, because Excel will need them for sheet names containing certain characters (like a dash). Now that I think of it, I see why you suggested another cell - you weren't using CONCATENATE. CONCATENATE allows you to put together text strings within a formula that accepts text, like INDIRECT.
Oct
17
comment Can Excel use formula-input data for cell references?
Tested: CONCATENATE works inside of INDIRECT. Now to check if it can do calculations that way.
Oct
17
comment Can Excel use formula-input data for cell references?
Just typing "INDIRECT" into the formula field, for the help text, I see it looks for a formula as specified by a text string. I wonder if I could nest a CONCATENATE in there?
Oct
16
comment Set an Excel cell's color based on multiple other cells' colors
You don't want to make the rule dependent upon the other rules - that defeats the intent of having the rule work regardless of how the other columns got their color. You make the rule a combination of all the other rules. I'd need to see your existing rules to come up with a viable example, if it's possible for your case at all.