Problem named ranges

[mandura]

Hi folks!

I have a problem with named ranges and i hope that someone can help me.

In sheet1 i have a few hundered numbers, and in sheet2 also.
In sheet2 i created a named range in A1 called „test“.
Now i want in sheet1 all values highlighted which are in the named range.
I am using this formula =COUNTIF(test;A1048576)>0
It works, but i noticed that some values from the named range are not higlighted (for example 226237, 18485000, 237756)
And 202609 fo example is not in the named range, but it is highlighted?

Can anybody please explain why my formula is going wrong?

I listend both sheet from A to Z, and formated the data as text, but its still not working propper.

Please see attached file (I HOPE I ACHIEVE IT).

Thx in advance!

mandura

[PFDave]

Think this should be

Please Login or Register  to view this content.

[mandura]

that is the formula i am using, and it works..........but there are a few mistakes which
i mentioned.

[PFDave]

that is the formula i am using, and it works..........but there are a few mistakes which
i mentioned.

So it doesn't work then.

201034 is in your list but not highlighted
201202 is highlighted but not in your list.

Change the formula to what I've mentioned and it highlights as it should.

[mandura]

you are right mate!

it works very well!

thank you very much!!!

mandura

[PFDave]

You're welcome Mandura, glad I could help you and thanks for marking the thread as solved and the rep

[JohnTopley]

Try

Select A1

Amend the rule,

=COUNTIF(test;$A1)>0