List of currency codes - are they are all the same?

[Guest]

Hi,

I am working on aggregating revenue based on currency. Typically I
convert everything to USD for my aggregates, but I now have a request
from my users to aggregate on local currency whenever possible. I have
worked out how to do this in my tool, but am looking for a way to
determine if all entities are in the same currency.

So simply put, I have a list of currencies and I am looking for a
simple function that would give me a boolean response if they are all
the same. I use the standard 3 letter currency code, so the list might
look like:

GBP
GBP
GBP
GBP
EUR

In this case their is one euro code so the statement would be false, if
they were all the same (regardless of currency type) I would get a
true.

Thanks in advance for the help.

Greg

 

[Jim Cone]

If your currency codes were in B5:B255 then...
=IF(COUNTIF(B5:B255,B5)<>COUNTA(B5:B255),FALSE,TRUE)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<[email protected]>
wrote in message
Hi,
I am working on aggregating revenue based on currency. Typically I
convert everything to USD for my aggregates, but I now have a request
from my users to aggregate on local currency whenever possible. I have
worked out how to do this in my tool, but am looking for a way to
determine if all entities are in the same currency.
So simply put, I have a list of currencies and I am looking for a
simple function that would give me a boolean response if they are all
the same. I use the standard 3 letter currency code, so the list might
look like:

GBP
GBP
GBP
GBP
EUR

In this case their is one euro code so the statement would be false, if
they were all the same (regardless of currency type) I would get a
true.
Thanks in advance for the help.
Greg

 

[Guest]

Thanks Jim - works like a charm!!