Domenic Wrote:
Then it's likely that the numbers for the remainder of the column are
also being recognized as text. Try the following...

1) Select an empty cell

2) Edit Copy

3) Select Column A

4) Edit Paste Special Add Ok

Does this help?

In article ,
ajajmannen
wrote:

You were correct there It gave a false value but I changed that and
got
a TRUE value......but it is still giving the result 0.
Ok to give more information: The vaules in Column A is a 7 digit
number
like 1937451. The Value in the N Column can look like this: SE96745
or
like INC-095667.
The numbers in Column A can appear several times and i only want to
count how many unique hits i get.
The values in column N can also be NOXXXXX and DKXXXXX but I only
want
to count the unique numbers in Column A that meet the condition SE*
or
INC*.
I would like to get.

This formula is really getting on my nerv......And again I want to
thank you for helping out and I hope that we will find the answer:)

Tried that to...but it seem like the problem is elsewhere...
I will copy a sample of the to columns in here and maybe you can try
the formula in action.
My Version of excel i 2002 with sp3.
Column N
USER_ID
SE096932
SE096932
SE096932
SE096932
SE096932
INC-97173
INC-97173
SE096932
SE096932

Column A
PROBLEM_ID
1499986
1499986
1499986
1499986
1758434
1929352
1929352
1936837
1936837
If this formula would work then the result for the sample would be 4
Hopefully this will make it easier for you :)
And just for the record....I really appreciate the help.


--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile: http://www.excelforum.com/member.php...o&userid=34130
View this thread: http://www.excelforum.com/showthread...hreadid=538999