Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
21 57 113
Impact
~1.5m people reached

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.
Oct
16
comment Set an Excel cell's color based on multiple other cells' colors
@LordTorgamus Ah, missed that. Well then, the solution should be relatively simple: Use a Conditional Formatting rule that combines all the elements of your other Conditional Formatting rules.
Oct
16
comment Set an Excel cell's color based on multiple other cells' colors
Are you using Conditional Formatting on the other colored cells, or are they colored manually?
Oct
16
comment Adobe flash player installed but not showing in IE
Are you sure you installed the version for IE, and not the one for Firefox or other browsers?
Oct
16
comment Prevent users from changing their passwords
If the users are in the Administrators group, as it seems they are, there's really little to nothing that you can do to effectively restrict their rights on the computer.
Oct
16
comment Prevent users from changing their passwords
@Star If they're in the Administrators group, they have free reign to do as they please on the system. You should really consider whether they really need elevated privileges to do their work on the system.
Oct
16
comment How do I make a Data Validation drop-down exclude blanks?
Okay, I found a solution but really only have about half a clue how it works. Could someone take a look at this and post an answer that explains it all? youtube.com/watch?v=6PcF04bTSOM
Oct
16
comment How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?
@GoldBishop Looking forward to it. Meanwhile, I've worked around the problem for this particular case. Still need some help over here though.
Oct
15
comment Excel IF Condition
Alternately, set both rules in Conditional Formatting. For a rule to apply if empty, use something like =A1="". Another nice thing about Conditional Formatting, is that it can be set for one rule to apply to multiple (and non-adjacent) cells.
Oct
15
comment How to kill volume when headphones pulled out
Easy fix: Buy an extension cable for the headphones. Works on my machine!
Oct
8
comment Connecting Windows XP Home computer to a Windows 7 computer through a VPN
Is the Windows 7 computer configured to require Network-Level Authentication? Have you applied the necessary updates to your client system?
Oct
2
comment Is there any way to use the Room Finder without any Room Lists?
Could somebody explain how this is off-topic? Certainly, it's a desktop user question but it is about a software function that's fairly enterprise-specific. That's why I figured it would be better served here, rather than Super User.
Sep
24
comment Windows Security popup window pops up each time any connection is made
Additionally, while this may be a useful troubleshooting option, you should be sure to revert the UAC changes when you're done.
Sep
24
comment Windows Security popup window pops up each time any connection is made
Seems to me more of a Super User problem than Information Security. I'm recommending migration - please don't cross-post.
Sep
24
comment Windows Security popup window pops up each time any connection is made
The UAC prompt is a bit different, and generally much more specific, than the dialog displayed here. Additionally, it should not be engaged simply by attempting access to the Internet.
Sep
20
comment PowerShell loads much slower than CMD; Can the PS startup be optimized?
@Synetech You might want to just get used to it. In newer versions of Windows, CMD won't be an option.
Sep
19
comment Command to see what version of HDMI
@EBGreen I ran the command you suggested, and that does not appear to have the information Moab is looking for. It's simply a list of supported screen resolutions, color depths, and refresh rates. Moab is looking for the supported HDMI Versions.