Question about Microsoft Excel for PC

1 Answer

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????

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 145 Answers

The only thing I see wrong in your formula is a missing colon.

COUNTIF($C$2:$C$999,C2)=1

Posted on Mar 15, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Countif formulas


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.

Jul 13, 2014 | Computers & Internet

2 Answers

Duplicate contacts on LG KP500 I have double checked my contacts but it doesn't seem to show any duplicate contacts, yet when this one number txts/rings me only the number shows up not their name..yet with...


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.

Feb 17, 2010 | Cell Phones

1 Answer

Garmin 265wt. How do you delete duplicate # fm phonebook?


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.

Feb 10, 2009 | Garmin nuvi 265 Car GPS Receiver

1 Answer

WHEN NAME AND NUMBER ARE STORED ON THE PHONE, WHEN YOU CALL SOME ONE YOU SEE THE NAME SHOWING, BUT WHEN THEY CALL, YOU ONLY SEE THE NUMBER OF THE PERSON AND NOT THE NAME LISTED IN THE PHONE. IF YOU SET THE...


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.

Jan 07, 2009 | Motorola Mobility RAZR V3

2 Answers

FORMULA TO COMPLETE A COUNT TO A PERCENTAGE


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

Nov 26, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

To cancel duplicatetel nos in next list any formula?


you can use countif (phonelist range, phone number)

any result > 1 has a duplicate. :)

Oct 12, 2008 | Microsoft Computers & Internet

3 Answers

Excel Formula


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.

Apr 22, 2008 | Microsoft Excel for PC

2 Answers

Duplicacy in excel sheet


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

Dec 19, 2007 | Computers & Internet

1 Answer

Excel problem


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.

Dec 05, 2007 | Computers & Internet

1 Answer

Excel


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.

Sep 23, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

122 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...