Cannot get COUNTIF to work! Here is my situation: I want to prevent duplicate entries of a loan number by the user. c has my loan numbers, and I want to prevent users from entering a loan number that has already been entered. Here is the formula I am using under Data/Validation/Custom: COUNTIF($C$2$C$999,C2)=1 My header is located in C1, data begins in C2. Using this, it will not allow me to enter ANY data whatsoever without popping up the stop box. How do I fix????

Are you trying to find how many don't have a letter? If so you might try "COUNTA" instead of "COUNTIF". You could also try looking at the format of the cell your formula is in and change it to general or number.

Sometimes, caller ID (the name of the caller) does not appear on a call and is replaced with the phone number.

The main reasons for caller ID not working are:

1. Duplicate entries in contacts - by FAR the most common cause and unfortunately, the most awkward one to fix.

If the phone finds the same number against more than one name, it doesn't know which to use so, perfectly sensibly, it defaults to showing the number.

The only way to fix this is to remove duplicates from your contacts. Best way to do this would probably be in Outlook on the PC, but assuming you can't do that, then you have to find the numbers that aren't working a use the LATEST version of the Nokia Search Tool (http://europe.nokia.com/ovi-services-and-apps/search-o1) to find the duplicate entries:

NOTE: when you search, use PART of the number to avoid problems with formatting: searching for +441234567890 will NOT find +44 123 456 7890 whereas searching for 789 would.

2. Using your international dial code instead of '+'

Not sure if this applies to all phones, but if you store your number using your county's international dial code (eg: 004412345678990 - WRONG) instead of the '+' sign (+4412345678990 - RIGHT), it can cause problems.

3. "(0)" area code prefixes

Only a problem if you synch with MS Outlook. When you specify a country in MS Outlook, it will insert "(0)" into your phone number after the country code - while somewhere in Redmond, Bill Gates cackles - so +4412345678990 becomes +44 (0) 12345678990.

You need to remove the (0).

4. 9 and 10 digit numbers

There has been one report of problems with 9 and 10 digit numbers where one size doesn't work with SMS and the other with calls. Not sure that anyone else has ever come across this.

I can help you with the phone numbers on your Garmin Nuvi 265WT.

The phone numbers transferred to your Nuvi are only supposed to be available when your phone is paired to your cell phone. Changing the entry on your phone should allow that entry to show up changed the next time it is paired with the Nuvi. Sometimes, a bluetooth mix up causes entries to be duplicated or entries' phone numbers to get repeated.

To correct this, I recommend backing up your favorites, clearing all user data (this hard reset will remove the phonebook info from your nuvi), and then updating your Nuvi' firmware to make sure the nuvi and cell phone bluetooth process runs as smoothly as possible in the future.

Follow these three steps to take to get your Nuvi 265WT running like new:

1. Back up your Favorites.
2. Perform a Hard Reset.
3. Download and then run Garmin 265WT WebUpdater to replace its firmware / system software.

I hope that helps.
_______________________________________
Erase Nuvi 265WT Phone Numbers here.
Nuvi 265WT Manuals here.

This usually happens when you have duplicate entries in your phonebook.

Depending on the model of you phone, You can have only the phonebook or sim enabled but not both to avoid duplicate entries. Or it might be that there is really 2 or more Names for the certain number. Just review your phonebook and remove the duplicates. That should solve your problem.

Hope that helps.

Apply the following:
COUNT(A3:A74)/COUNTIF(A3:A74,"1")*100 in order to obtain the percentage.

you can use countif (phonelist range, phone number)

any result > 1 has a duplicate. :)

Lets say your data (cars) is in range "D1:D21".

You need to know how many are Dodge and Ford in cell E1.

=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)

Hope this helps.

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Have you tried countif?

= countif(c:c, "Yes")

The "Yes" is CASE SENSITIVE!

You may also have to do a combo:

= count(b:b) - countif(c:c "<>'Yes'")

Wher the 'Yes' is in single quotes and the entire condition is in double quotes.

See if this is possible using the COUNTIF formula in Excel. Example: My range is A1:A20. Lowest number being 1 and highest number being 20. To see how many are less than 10 I'd use: =COUNTIF(A1:A20,"<=10") To see how many are less than 20 but greater than 10 is a little different. (And this might be the crazy way). I do this: =SUM(COUNTIF(A1:A300,"<=20") - COUNTIF(A1:A300,"<=10")) Try this and see if it works for you. It seemed to work fine for me.