Solved: Count IF Knucklebreaker

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Serch

Thread Starter
Joined
Oct 8, 2008
Messages
3
Good day all, first timer here.
I've read several threads on how to use the Countif Function I currently applied it to a worksheet of mine and thought I succeeded until I double checked. I'm trying to compare two columns of data, need to know if the numbers from the second column are found in the first column.I tried to attach my xls example but its way to large. Basically and as exmaple the data in row C1574 is in fact included in row A8459 but the formula still shows "NOT FOUND".
All I can send is a printscreens so you guys can look at my formula.

Need Help !!
 

Attachments

Joined
Jun 30, 2008
Messages
248
Welcome You'll find some great folks and help here
While waiting for the "big boys" to post please consider the following

Some thoughts for you to test

You can remove >0 from formula the count if function is all you need If(countif(range,criteria),"Found","Not Found")
Compare column D and column F formulas on attached file

check your row number, rows are from 1 to 65536 or so

A8459 is not a valid row number I think your comparing cells C1574 and A8459

compare with attached test file and tell me what I am not understanding
C1574 is a string (ie.non-numeric), In any blank cell type C1574=A8459. True says they match False says they differ A leading or trailing blank will cause them to differ even though appearing the same
 

Attachments

Joined
Jul 25, 2004
Messages
5,458
Formulas look good. Check for leading/trailing spaces. For example, a trailing space will show two values as not equal. So "S8110-004" is NOT equal to "S8110-004 ". See the space? They're a killer.
 

Serch

Thread Starter
Joined
Oct 8, 2008
Messages
3
Thank You both for your quick replys !!!!....I looked closely and yes, the problem is the spaces between characters in certain cells, so this brings up another question......is there anyway I can format the cells as to not have spaces in between characters or at the end for that matter?.
Thanks again your advise solved part of my troubles.
 

cwwozniak

Chuck
Trusted Advisor
Spam Fighter
Joined
Nov 28, 2005
Messages
66,812
Excel has a TRIM function for removing leading and trailing spaces from a text string. I do not know of any function for removing spaces between characters. Now that I have said that I am sure someone will prove I am wrong.

If your column A entries are not constantly changing it might be simpler to use "Replace" in Excel's Edit menu. Just select the entire column and replace all instances of a space with nothing.

EDIT: If the one time use of Edit->Replace is not practical, the SUBSTITUTE function may work for you as described on this page from the MS site:

Remove spaces and nonprinting characters from text
http://office.microsoft.com/en-us/excel/HP030561311033.aspx
 

cwwozniak

Chuck
Trusted Advisor
Spam Fighter
Joined
Nov 28, 2005
Messages
66,812
Glad to hear that we were able to help you out.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top