Reputation
5,427
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
6 28 65
Newest
 Yearling
Impact
~1.3m people reached

Jun
19
comment Adding a date to a formula in excel
@fixer1234, nevermind, it actually can get complicated since there is no ISDATE function in Excel, but we just don't have enough specs here to be sure what the OP is asking.
Jun
19
comment Adding a date to a formula in excel
@fixer1234, I see what you're saying, I'll put up a third case.
Jun
12
comment Display Formatted Mounted Partitions
You need to show what you've tried.
Jun
12
comment How do you save an Excel document as a Word document?
@Wishwas, thanks for bringing that to my attention, edited.
Oct
27
comment Excel formula counting specific cells
Problem caused by simple syntax error.
Oct
24
comment Dual Monitors on Optiplex 9020 DT
This is not an exact duplicate of that, as he isn't talking about DisplayPort technology, even though some of the content might be relevant.
Jul
25
comment Autofill in Excel skipping rows
According to the first table you only ever have one C and P3, so it's quite unclear what you're trying to accomplish.
May
26
comment What do cell phones/cell network devices potentially interfere with on airplanes?
Yep, but obviously the FAA cares (illogically).
Dec
27
comment Chrome cannot find Chromecast with Toshiba Bluetooth stack
More details would probably help troubleshooters.
Oct
7
comment How do I draw free-hand lines in OmniGraffle?
@slhck, edited.
Sep
22
comment Summing a column in the same column without a circular reference
@törzsmókus, thanks, edited in note. I don't know the new number off the top of my head, so feel free to add it to the note if you do.
Jul
8
comment How to count number of distinct values in a range?
@cfi, thanks, five-fingered that, fixed now.
Jul
5
comment How to count number of distinct values in a range?
@cfi, thanks, edited in.
Apr
25
comment How to count number of distinct values in a range?
Yes, you got it, it iterates an array for what would normally be a single value, multiplying all of its parameters (which in this case is just 1), then adding the iterations. SUMPRODUCTs can get very complex, but they are one of the most useful functions in Excel, it can do literal miracles.
Apr
25
comment How to count number of distinct values in a range?
@RBarryYoung, SUMPRODUCT works like an Array function without being one. While it can do much more than what it's being used for here, here it is just checking every instance of a column, and coming up with a scaled value for each distinct value based on how many iterations there are in the column. So if there were two instances of 'a', it would add 1/2 and 1/2 to get 1. So for every distinct value, you'll add one to the sum.
Mar
7
comment 2 Dimensional vlookup + match, pulling from two different data sets?
OK, it's easy if your sheet two has all the same product numbers, and if they weren't produced has a zero (or is blank) for a quantity. Is that the case?
Jan
8
comment Firefox not refreshing all tabs when it opens
@avirk, that worked great, make an answer and I'll accept it.
Nov
5
comment What search utilities can search by file name in Windows 7?
@barlop, you have to load the alpha version to get the unary operators to work, but they don't appear to have a full install package, just an executable, so no way to test the right-click context menu stuff.
Oct
31
comment What search utilities can search by file name in Windows 7?
@barlop, thanks, it's time to give it another try, I still haven't been happy with anything yet.
Oct
3
comment Convert Excel 4.0 macro to VBA
The key is 'Excel 4.0', a much older version and mechanism.