1,476 reputation
729
bio website
location United States
age 19
visits member for 2 years, 6 months
seen 2 days ago

Nov
20
comment Excel- SUM formula not working on IF formula converted data
You should at least include the IF formula in your question.
Nov
14
comment Program to format external drive to FAT16 in Windows 8.1
Final FAT16 was the first to allow a disk size greater than 32MB. You can try choosing "FAT" in the Windows Format dialog and you'll see that you are able to create a volume greater than 32MB, therefore, it must be FAT16.
Nov
10
comment How to easily locate photo opened in Windows 8.1 Photo App
@LievenKeersmaekers I agree. Windows 8 full screen apps sacrifice functionality in favor of simplicity.
Oct
21
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
Thanks for your help, this actually did fix the mute button light. By the way, did you get the fingerprint reader to work in Windows 8? I'd like to use the fingerprint reader to log into Windows but nothing seems to happen when I install the driver.
Oct
21
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
Thanks, I'll try this later today. Did your wireless light work as soon as you installed Windows 8? Or was it later, after you installed some drivers?
Oct
20
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
So is there a place where I can download and install these "HP supported apps"?
Oct
20
comment How to enable mute button and wireless button LEDs on HP ZBook 15 laptop
That first link said that my laptop hasn't been tested with Windows 8. But it looks like they sell it with Windows 8 preinstalled sometimes... Look at the top of this page: h71016.www7.hp.com/…
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?
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
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
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
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
21
comment Comparing columns in two different excel sheets and if they match copying third column
Why use the EXACT function instead of, for example, =IF(AND('F1'!A1='F2'!A1,'F1'!B1='F2'!B1),'F2'!F1)? It's shorter and there is no need for a case sensitive match here.
Jul
21
comment vlookup in a cell that contains mid formula
It shouldn't make a difference whether the cell targeted by the VLOOKUP contains a formula or a fixed value. Can you describe what is in columns B and C on the LOCATION LOOKUP TABLE sheet and what is in cell F57?
May
26
comment How to dynamically populate a filter list with “first match” on a row, using excel 2007
What should it return when it finds a match?
May
12
comment Download pictures a second time
Exactly how are you trying to download the pictures? What software are you using?
May
8
comment Averageing numbers in a column while ignoring rows with headers
You might be right. We'll let Jack83 tell us which one he meant.