If the currency types are in column B and rate rates are in column C, then:

=IF(MIN(IF(B2:B100="USD",C2:C100))=MAX(IF(B2:B100= "USD",C2:C100)),"USD ALL
THE SAME","USD DIFERENT")

Will tell you if all the USD's are the same or any are different.

This is an array formula theat must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.

Just repeat this formula for the different currency types.
--
Gary''s Student - gsnu200856


"DT" wrote:

I have the following columns
Item Currency Exchange_rate
A USD 10
B USD 10
C Euro 5
D Pound 9
Like this i could have 100's of items in a sheet. I want a Macro / functon
to look at all the items and give summary of currencies and against it the
exchange rate. In case for the same currency the exchange rates are different
for item to item the macro should give a message.