Nathan DeWitt
  • Member for 12 years, 6 months
  • Last seen more than 2 years ago
  • Hampton, VA
How do I get the distinct/unique values in a column in Excel?
139 votes

Excel 2007 and 2010: Use the Remove Duplicates menu option under the Data header. Excel 2003: Easy way: Make sure your data has a header Data --> Filter --> Advanced Filter Check Unique Records ...

View answer
Fastest way to type in math formulas out of the box?
20 votes

I love using the built-in Equation Editor in Word 2007. Alt + = brings up the editor, then you type this: (a+b)^n=\sum_(k=0)^n (n\atop k)a^k b^(n-k) This will produce the following: It doesn't ...

View answer
Best freeware to remove redeye in images?
Accepted answer
16 votes

Picasa will do this. Check out this tutorial.

View answer
Will Windows 7 Home Premium access company domain?
Accepted answer
10 votes

Check out this feature comparison chart. You can see if you scroll to the bottom that joining a domain requires Pro, Enterprise or Ultimate. All versions can use Remote Desktop to connect to another ...

View answer
How do I uninstall Windows 8 Consumer Preview?
8 votes

If you install to a VHD, then getting rid of it is a simple matter of booting into Windows 7, deleting the VHD file, and deleting the Windows 8 entry using msconfig.exe. I'm not trying to be snarky,...

View answer
2 different laptops, 1 home office setup
8 votes

You can get an HDMI KVM. This will let you plug one monitor/mouse/keyboard into two computers.

View answer
Is there any 64-bit software for Windows that is much preferable to its 32-bit counterpart in a 64-bit OS?
8 votes

Photoshop performs better in a 64-bit system. You can see some numbers if you scroll to the bottom here. Word on the street is that the 64-bit edition of Photoshop is 8-12% faster.

View answer
How does a hard drive compare to Flash memory working as a hard drive in terms of speed?
Accepted answer
7 votes

One big difference is that the flash drive is using the USB bus, while the drive is using the SATA bus. So even if your flash memory was the same speed in both cases, the drive would have a higher ...

View answer
It is possible to reproduce the Windows 8 Fast Hybrid Boot into Windows 7?
Accepted answer
7 votes

From the Windows 8 Build Blog: The new Windows 8 Hybrid Boot is fast because of the new feature called Hybrid boot. Generally in hibernation mode, all files are saved in the same state, but in ...

View answer
How can I make Vista look like XP?
Accepted answer
6 votes

Create a virtual machine and install Windows XP. Then they will look exactly the same.

View answer
How to add a checkbox for a row in Excel?
Accepted answer
6 votes

Yes, you can do this. I will demonstrate using Excel 2007. Using fonts: I went to Wingdings and added a Checkmark in A1 (character code is 0252). In regular text, this is ü. Then in cell B1 I put ...

View answer
Word does not maximize to full screen
Accepted answer
6 votes

I've seen this before. I had a system where I was messing around with the resolution and Word "remembered" the current resolution incorrectly. I don't remember exactly what I did to fix it, but I ...

View answer
Is Windows Server 2003 on 96 MB possible?
Accepted answer
6 votes

Yeah, it's possible. In a cluster computing class a few years ago, we set up 8 computers running Windows XP and one computer running Server 2003, all of them well below their stated minimum RAM ...

View answer
Windows 7 default programs won't let me choose Firefox as my default browser
Accepted answer
6 votes

Do you have Firefox installed? Ok, now that that's out of the way... Try this after exiting Firefox completely: firefox.exe -silent -setDefaultBrowser That will set firefox as the default browser ...

View answer
How do I exit a Modern UI app?
5 votes

I just found a more elegant solution than three-fingered salute... Win+R, then click on the Start icon (Windows icon, bottom left). But I'm ready to use the actual method.

View answer
How to run a command line script every Friday at 3:00 AM automatically?
Accepted answer
5 votes

Use Task Scheduler on a Windows system. Create Basic Task Wizard: Trigger: Weekly Recur every: 1 weeks on: X Friday Start a program Put your two lines into a bat file, then put that file into ...

View answer
In Excel, can I provide a "default value" in case my formula returns #NA?
5 votes

It may make more sense to you if you checked the first lookup value for NA, and then checked the second, and if they're both valid then multiply them. =IF(OR(ISNA(VLOOKUP(A3,somesheet!G:J,3,FALSE)),...

View answer
Installing SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation)
Accepted answer
4 votes

According to Install SharePoint 2010 on Windows Server 8 Beta (en-US) on TechNet, you can just click on Run the program without getting help and you should be fine.

View answer
Word 2010, Multiple Columns, Vertical center one column only
4 votes

When you set the layout to be centered vertically on the page, it affects the entire page. I cannot find a way to do what you want - having two columns with different vertical heights. Insert a line ...

View answer
Increase volume level of WMA audio files
Accepted answer
4 votes

Try Audacity. It's free and you can edit waveforms.

View answer
Will a standard wireless router support 12 wireless users?
Accepted answer
4 votes

It should be fine - I think they support like 250 users or so. 12 users is no problem.

View answer
Building a home cluster - hardware and cost analysis
3 votes

Check out the books Beowulf Cluster Computing by Thomas Sterling (one for Linux & one for Windows). They tell you all you need to know about using MPI to get your nodes to talk to one another. A ...

View answer
Can there be a script imitating Windows 8 fast boot-up(shut down)?
3 votes

The windows 8 fast boot includes starting up device drivers in parallel. They're also hibernating the kernal itself aside from application data. That's what makes it so fast. I don't think you can ...

View answer
Which virtual machine software is preferable for running Windows 8 Developer Preview?
3 votes

I installed it with no problems using Hyper-V on Windows Server 2008 R2. I wasn't able to use RemoteFX 3D Video Adapter, however. I gave it 8 GB of RAM and 120 GB hard drive space. The RAM was ...

View answer
What WYSIWYG HTML editor should I give a novice
3 votes

You want Cushy CMS. It's a simple online editor for web pages. You create a shell, add a class name to a div or other tag and voila! it's editable on the Cushy page. It's very easy - I use it with ...

View answer
Navigating Back with the keyboard in a Windows 8 Modern UI app
3 votes

Use Backspace and it should function as the back key like in Windows Phone 7.

View answer
Where does Windows 8 put the exe of the default browser for Modern UI?
2 votes

Creating a new default browser doesn't create a new executable. As you can read on this Building Windows 8 blog entry, there is just one browser engine (the EXE) and two skins. One suitable for ...

View answer
GarageBand Alternative for Windows?
2 votes

Cakewalk Music Creator 5 is $35 or so. I haven't used it, but I've heard good things about Cakewalk software.

View answer
Moving the Windows 7 hard disk from one machine to another
Accepted answer
2 votes

the drivers in use are completely different between your old computer and the new one. You can plug it in and turn it on, but be prepared to spend a lot of time updating drivers, if it works at all. ...

View answer
Windows 7: Base System Device drivers missing
2 votes

Change the view to View by Connection, and then see what it's connected to. That should help determine which devices these are. I would guess they're SD media controller or something like that. ...

View answer