1,556 reputation
59
bio website dailydoseofexcel.com
location Omaha, NE
age 45
visits member for 5 years, 1 month
seen Nov 15 at 14:41

Oct
30
awarded  Popular Question
Oct
16
awarded  Yearling
Sep
22
answered Excel forumla to recognize new tabs
May
13
revised Duplicate SQL Server Database with Access Front End on Remote Machine
typo
May
13
asked Duplicate SQL Server Database with Access Front End on Remote Machine
Apr
28
awarded  Caucus
Oct
16
awarded  Yearling
Mar
10
comment How to copy a forumla in excel using only the keyboard?
Forget Ctrl-C and Ctrl-V. Do everything else and finish with Ctrl-D for Fill Down.
Oct
16
awarded  Yearling
Apr
17
comment Computer Power Cycles Unexpectedly
I went to Intel's site to check on the warranty and they had a troubleshooting guide. One of the steps was to remove the everything from the case to check for grounding problems. I moved the whole unit to the kitchen table (different outlet) and did not remove the case, just wanted to see it error again. It ran for 30 hours without error. I moved half my stuff to a different outlet and it's been flawless since. Did I ask for cheap and easy? I can't imagine an answer that was cheaper and easier.
Apr
17
accepted Computer Power Cycles Unexpectedly
Mar
20
comment Computer Power Cycles Unexpectedly
Thanks. Capacitors all look good. This turned out to be a power issue, but I'm curious about the airflow. I never put the side panel on this chassis. Are you saying that could make it worse?
Mar
20
comment Computer Power Cycles Unexpectedly
@DanH can you make that an answer so I can accept it? An outlet on a different circuit solved it.
Mar
18
asked Computer Power Cycles Unexpectedly
Oct
16
awarded  Yearling
Sep
8
answered Is there a way by which I can select particular columns from an excel sheet?
Sep
7
answered Sumproduct with multiplication by first * last instead of first * first
Apr
18
answered VBA xlColumnDataType in Excel 2003
Apr
13
answered Select the value of a cell above an empty cell
Mar
9
answered replace multiple characters at different places in a string Excel 2007