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

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
19
asked Is there a useful difference between ISBLANK and =“”?
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
17
revised Can Excel use formula-input data for cell references?
added 1 characters in body
Oct
17
asked Can Excel use formula-input data for cell references?
Oct
17
asked Natively Find & Replace with wildcards in Excel
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
16
asked How do I make a Data Validation drop-down exclude blanks?
Oct
16
revised How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?
deleted 7 characters in body
Oct
16
revised How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?
added 1068 characters in body
Oct
16
asked How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?