1,356 reputation
726
bio website
location United States
age 18
visits member for 2 years, 1 month
seen 7 hours ago

9h
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
revised Formula that references two cells
table formatting
Jul
23
suggested suggested edit on Formula that references two cells
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
Jul
21
answered Copy from sheet2 to sheet1 based on if values match
Jul
21
suggested suggested edit on Copy from sheet2 to sheet1 based on if values match
Jul
21
answered Excel filter duplicate values in column A and filter out rows which have column C blank
Jul
21
answered Why do video streaming services buffer when I plug in my headphones?