Excel : How to Count Number of Distinct Values in a Range ?

=SUM(IF(FREQUENCY(IF(LEN(C3:C25)>0,MATCH(C3:C25,C3:C25,0),""), IF(LEN(C3:C25)>0,MATCH(C3:C25,C3:C25,0),""))>0,1))

and this for numeric values:

=SUM(IF(FREQUENCY(C3:C25, C3:C25)>0,1))

This article shows similar formulas, but also shows a method using filters.

Count the number of unique values by using a filter
You can use the Advanced Filter to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.

1. Ensure that the first row in the column has a column header.
2. On the Data menu, point to Filter, and then click Advanced Filter.
3. In the Advanced Filter dialog box, click Copy to another location.
4. If the range that you are counting is not already selected, delete any information in the List range box and then click the column (or select the range) that contains your data.
5. In the Copy to box, delete any information in the box or click in the box, and then click a blank column where you want to copy the unique values.
6. Select the Unique records only check box, and click OK.
   The unique values from the selected range are copied to the new column.
7. In the blank cell below the last cell in the range, enter the ROWS function. Use the range of unique values that you just copied as the argument. For example, if the range of unique values is B1:B45, then enter:
   =ROWS(B1:B45)

Strategy Guide for IOS5 Jailbreaking

Well, it's just been taken up a notch again. Jailbreak developer and member of the Chronic Dev-Team, pod2g, has confirmed that one of the primary exploits they are working with to develop an untethered IOS5 jailbreak for all devices will be patched by Apple when they release 5.0.1 shortly (5.0.1 is already in beta testing with developers).

This means that if you want the best chance of an untethered jailbreak on IOS5 for an iPad1 or iPad2, then you must install 5.0 before Apple stops signing it and you must NOT upgrade to 5.0.1.

Remember, Apple have changed the way the SHSH Blobs work in IOS5, so they provide you absolutely no protection on 5.x. It is not sufficient to save 5.0gm blobs and use those at a later date to install 5.0. That will not work.

iPad2 WiFi Owners JB on 4.3.3
You guys have a harder decision. First you need to find out if you have your SHSH Blobs for 4.3.3 saved using our tutorial here - HOW TO - Save your SHSH Blobs with TinyUmbrella
If you do, then you will always be able to restore to 4.3.3 and get your jailbreak back. Your next decision is can you live without a jailbreak for a while in the anticipation that one is coming down the line? If so, then you should install 5.0 before the signing window closes (follow Step 3 above), but before you make the decision, read on into the next section so you understand my thoughts on the timescale you may be facing.
If it turns out you don't have blobs saved then iFaith is of no use to you since it does not support the iPad2 so you are in the same pickle as iPad2 3G owners, so read on into the next section for your strategy...

iPad2 3G Owners JB on 4.3.3
You guys (and this includes me too!) have the most difficult decision to make. Once we upgrade we can never go back under any circumstances, but you could be stuck on 5.0 for a long time without a jailbreak. Remember there is no ETA for anyone to release a new iPad2 jailbreak and whilst I don't want to be too negative at this stage, Chronic did not deliver last time despite months of apparent effort into the 4.x jailbreak. Giving them the benefit of the doubt and recognising the jailbreak development is a gargantuan task, well beyond anything I could achieve, we could still be looking at weeks or months before a release. Just because they have exploits does not make it a sure thing that the jailbreak will arrive any time soon! Remember, the exploits have been known for many months already.

So, you need to make a decision before the signing window for 5.0 is closed, are you willing to live without a jailbreak for an unknown period of time so that you have the best chance of a 5.x jailbreak when it comes out?
I can't answer this for you and I haven't' made up my mind myself yet

Again, remember, if you make the move to 5.0 (without a jailbreak) and anything goes wrong which requires you to restore, then you will be forced onto 5.0.1 (or above) and will potentially lose out. This of course is all predicated on the assumption that the exploit which is used to jailbreak will be the one which Apple patches in 5.0.1. It's a risk based call, and not an easy one...

All other iPad2 3G Owners (without a jailbreak).
For you guys it's pretty much a no-brainer. Ensure you are on 5.0 before the singing window closes and take care of your device so you are not forced to restore it for any reason.

Beta Testers using 5.0.1b2
If you are a developer and are testing out 5.0.1 in beta, then you can downgrade provided you initiate it before the signing window is closed for 5.0. But if you are a developer you already know this

How To Fix Error 800B0100 on Windows Update

Windows Update Error 800B0100

If you receive the Windows Update error 800b0100, it means that a file needed by Windows Update is not registered with Windows correctly. The System Update Readiness Tool can correct some conditions that cause this error. To use the tool, follow these steps:

1. Go to the System Update Readiness Tool webpage. In the Information for advanced users section, find the version of Windows and system type of your computer, and then click the link to download the System Update Readiness Tool. If you don't know which version of Windows you have, see View your computer information.
2. Run Windows Update again.
   

   Note

   Typically, the scan takes 15 minutes or less, but it can take longer on some computers. The Windows Update progress bar is not updated during the scan, and progress seems to stop at 60% complete for some time. This behavior is expected. The scan is still running and you should not cancel the update.

If the problem persists after you take these steps, go to the Microsoft Update Solution Center website to find more information about the error code or to request support by e‑mail.

Error codes this applies to:

• WindowsUpdate_800B0100
• 0x800B0100

Was this helpful?

How to Fix : Can Not Watch, Record, Download From Youtube

You can't watch a youtube video - the screen says "You either have javascript turned off or your Adobe Flash is too old" or such like. First, go to Tools at top of page, then scroll down to Internet Options, click Security heading and go to Custom Level. In there, scroll down til you come to the section for Active Script. Make sure your setting for running script is Enabled. If this is the problem, you enable it, restart your computer and away you go!
BUT!
This info is all over the net when you type in this question. What if your script is already set at Enable and it still won't work? You need to go to Adobe on your computer - remember I'm writing this as a geek for other geeks to understand - click start, your menu appears, go to Programmes contained on your pc, look for all the programmes you have on your computer. There will be a long list of programmes like Internet Explorer, Games, Java, Media Player all in alphabetical order. Go to Java and make sure it is Enabled. If not, then enable it and you are sorted!
BUT!
You do this and still can't watch youtube ? So What you need is youtube plugin......You can download it for free....Download Here :

 

• Support popular video sites
• Support download pasue and resume
• Built in converter to all format
• (Mp4, Iphone, IPod, cell phone, avi, wmv, mp3 and more)
• Auto rename video with advanced perfix
• Proxy support
• Multithread downloader and convertor
• 100% clean. No spyware or malware
• Free full functional for ever

Make Screenshoot for Payment Proof

A "screenshot" is a snapshot of what's on your computer's screen.
To create a screenshot follow these steps:

1. The first step is to create the windows that you want to capture and leave them up on the screen.
2. Just to the right of your keyboard, you should see three groups of keys.  The lower set of keys usually is a group of arrow keys.  Above that is usually a set of some six keys that are labeled "Insert," "Home," "Page Up," etc.  Above that should be three keys that have rather odd labels - like Pause/Break and ScrLk.  One of those keys should be labeled PrtScrn/SysRq. Pressing Alt-PrintScreen (Alt-PrtScrn) places an image of the frontmost window on the clipboard. Pressing PrintScreen by itself places an image of the entire desktop on the clipboard.
3. If you press PrtScrn/SysRq, nothing will appear to have happened.  However, your computer just took a snapshot of its screen and stored that picture on its clipboard, much as it stores information that you cut and paste.
4. Open MS-Paint. (From Start/Run, issue the command "mspaint".) Create a new empty image, and use Edit/Paste to bring in the screenshot you just took. (If the screenshot is smaller than the default Paint canvas, you will end up with white areas. Start over: create a new empty image, change its dimensions to 1x1, and Paste again. The canvas will grow for the Paste, but it doesn't shrink.)
5. Use MS-Paint to Save As, using PNG as the file format (it is superior to all the rest).

Using Safe Mode to Diagnose Word Startup Problems

If you’re experiencing problems when you start Word, safe mode will help you narrow down the source of the problem. Because Word loads the registry data key, the Normal.dot template, and any other add-ins or templates located in the Office startup folder, the source of your problem will not be immediately apparent. To find out if the problem likes with any of the aforementioned components of Word, follow these steps to start Word in safe mode:

1. Select Run from the Windows Start menu

2. Type winword.exe /a (you must insert the space before the /a; also, you may need to type the entire file path or use the Browse button to locate the file)

3. Click OK

If Word starts okay, then the problem lies in either the registry data key or something located in the Office startup folder. Your first step should be to delete the Normal.dot template, as this is the cause of most startup problems in Word. For help fixing registry data key problems, consult the Microsoft Office Update Support page.

If Word does not start correctly in safe mode, or if you don’t want to get into editing your registry, it may be time to reinstall Word. Remember to back up your settings first!