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.