1,408 reputation
726
bio website
location United States
age 18
visits member for 2 years, 2 months
seen 1 hour ago

Aug
22
revised Is this a legitimate registry key? (windows 7)
formatted output
Aug
22
suggested suggested edit on Is this a legitimate registry key? (windows 7)
Aug
5
asked What is the origin of the word 'cookie'?
Aug
4
answered Obtain Windows 8.1 Update 1 installation media - I have Windows 8 Keys
Aug
3
comment Strange Visual Artifacts, Windows 7
Why did you downgrade the drivers? Driver updates often contain fixes for issues like this. Have you tried installing the latest driver update?
Aug
2
asked Opening local batch file from Chrome bookmark
Jul
28
comment Using two Private Sub Worksheet_Change(ByVal Target As Range)
What is your question?
Jul
25
comment Changing what browser Excel hyperlinks open in
Here's a screenshot of the Chrome settings on my PC. The "Default browser" setting is highlighted at the bottom: i.imgur.com/2UZtJgm.png
Jul
25
comment Changing what browser Excel hyperlinks open in
They will open in your computer's default browser. In chrome settings there is an option to make chrome the default browser.
Jul
25
asked How to access router web interface behind VPN with same IP as local router
Jul
24
comment Rounding Percentages
If you are trying to figure out which ones contribute the most to the rounding error, why not just subtract the rounded values from the original ones in a new column and look for the largest values in this column?
Jul
24
comment Prevent Blur in Gameplay .mov
Does it appear in the final exported video file, the file you uploaded to YouTube? Try increasing the bitrate of the encode.
Jul
23
awarded  Revival
Jul
23
comment add same value to range of cells in microsoft excel
Have you tried copying the contents of cell B1, selecting cells B2 to B40000, and then choosing paste?
Jul
22
comment Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)
You can create a formula on the first sheet that links to a cell on the second sheet. It would look like this: =Sheet2!A1, where Sheet2 is the name of the second sheet and A1 is the cell on the second sheet that contains the data you would like to link.
Jul
22
revised Count Unique Cells Matching Results in Set
added note about case insensitive match
Jul
22
comment Count Unique Cells Matching Results in Set
@mrwweb Good point. I updated my answer, let me know what you think of this solution.
Jul
22
revised Count Unique Cells Matching Results in Set
made more scalable
Jul
21
answered Count Unique Cells Matching Results in Set
Jul
21
revised Copy from sheet2 to sheet1 based on if values match
formatting