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

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.
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!