4,886 reputation
62663
bio website alaskadataconsultants.com
location Fairbanks, AK
age 48
visits member for 5 years, 1 month
seen yesterday

Control Systems Engineer.

Most people want to stick their head in the sand and ignore problems, in an effort to avoid conflict. I refuse to be that passive person. Problems are there to be fixed, which means that first they have to identified. Denial is not just a river in Egypt.


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.
May
31
comment Is there a way to save a tab-set in Firefox?
After 4.0 you have to right-click on a tab and choose Bookmark All Tabs.
Jan
23
comment How to fix the IE8 favorites menu (little box icon)?
@techie007, on Windows 7 I've seen it on clean install machines.
Jan
19
comment How to fix the IE8 favorites menu (little box icon)?
@Manwe, no, not really, and I've seen this on quite a few different computers.
Jan
19
comment How to fix the IE8 favorites menu (little box icon)?
@Manwe, Yes, on the AV, but no, they were different programs.
Jan
13
comment Use two columns in Microsoft Word separately
This does the columns right, just takes some fiddling if you want to do much formatting of the text. Next time I have to do this I'll be using this method, though I may do cut and past to not have to fiddle with the formatting. Thanks.
Jan
13
comment Use two columns in Microsoft Word separately
That works good for just one page, but if you continue the first column, it bumps the 2nd to the next page (i.e. where it would be the continuation of the first).