meta user
network profile
| bio | website | alaskadataconsultants.com |
|---|---|---|
| location | Fairbanks, AK | |
| age | 47 | |
| visits | member for | 3 years, 11 months |
| seen | Jun 12 at 20:51 | |
| stats | profile views | 660 |
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.
|
Jun 12 |
reviewed | Close How to make hidden files not show up on Windows 7? |
|
Jun 12 |
reviewed | Close Computer is so slow after taking out the graphics card |
|
Jun 12 |
reviewed | Reviewed Can't change default .jar opener from Command Prompt to Java SE Binary |
|
Jun 12 |
revised |
Can't change default .jar opener from Command Prompt to Java SE Binary deleted 28 characters in body |
|
Jun 12 |
reviewed | No Action Needed DocProperty “Pages” changed by printing |
|
Jun 12 |
reviewed | Reject suggested edit on How to exit VIM and get back to 'normal' terminal? |
|
Jun 12 |
reviewed | Approve suggested edit on How do I change the name of a computer |
|
Jun 7 |
awarded | Good Answer |
|
Jun 5 |
awarded | Nice Answer |
|
Apr 25 |
comment |
Excel: 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 |
Excel: 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. |
|
Apr 15 |
awarded | Popular Question |
|
Mar 27 |
reviewed | Close How can I make Mac Finder show the actual size of files not 'size on disk' multiples of 4KB |
|
Mar 27 |
reviewed | Close CSS compressor for Windows |
|
Mar 27 |
reviewed | Leave Open New OS SSD - unable to boot with it |
|
Mar 27 |
reviewed | Close Connecting to an ISP via a wireless router |
|
Mar 27 |
awarded | Famous Question |
|
Mar 18 |
reviewed | Approve suggested edit on Prevent windows applications from accessing data in my profile. |
|
Mar 18 |
reviewed | Edit suggested edit on Prevent i7 from overclocking while on battery |
|
Mar 18 |
revised |
Prevent i7 from overclocking while on battery Added system specs from OP's comment to question. |
