Reputation
5,852
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
7 32 69
Impact
~1.7m people reached

Mar
25
comment Shortest Method To Reference A Single Row/Column of a Named Range in Excel?
@whytheq, My guess would be that for large columns Max("A:A") would be the most efficient. You could time and test, see here: stackoverflow.com/questions/198409/….
Jan
8
comment Restoring sheet size closes workbook
@Raystafarian, I finally found a good link that talks about the problem and I can now at least make the sheet reappear, though I have to do it every time. I'll post an answer when I get a chance to completely go through it. smurfonspreadsheets.wordpress.com/2009/03/17/…
Jan
8
comment Restoring sheet size closes workbook
@Raystafarian, didn't do it. It gets more interesting though. I've found that the workbook is still open, and I have a formula selected in the formula bar, but there is nothing to see. I went to the immediate window and it said that the Workbook was Visible. editing question.
Jan
7
comment Restoring sheet size closes workbook
Yes, plenty of code behind. I've tried everything I could find, too much to list (or remember). Checked all the settings and played with sizing.
Jan
7
comment Restoring sheet size closes workbook
Yes, the restore button in regards to sizing. Yes, I'm referring to the Excel workbook, not Excel. The only ActiveWindow commands are .SelectedSheets.Printout, .ScrollColumn and .ScrollRow.
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.