thanks for the effort

1- not all the member of the EU use the euro (UK is a clear example)
2- let's make it general: i have a list1 (shorter) and a list2
(longer): which is the formula i can use tho determine how many
element of list2 are also in list1?

this is somehow a followup of my question of last night, if i dont
fail you also replied

thanks!



On Aug 14, 11:53 am, "Bob Phillips" wrote:
=COUNTA(range1)

If it has the Euro as its currency, it is de facto a member of the union is
it not?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"lorenzo" wrote in message

...

hi

if I have to named ranges of cell
range 1 has for example the list of countries that adopted the euro as
currency
in the range 2 i have the list of countries that are member of the
European Union.

Is there a formula like
count those countries in the range2 that belong also to range 1
?
thanks