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

Ad

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

Ad

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

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

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?

Open Questions:

See all Microsoft Excel for PC Questions

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

2936 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18415 Answers

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

Answer questions

Manuals & User Guides

Loading...