Return value from column
 

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.

Return value from column
 

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.

Return value from column
 

Thanks. This worked fine.
It still does not answer my first question - How do i get a summary of
currencies. i.e. say if "USD all the same" is true then in cell D1=USD and
cell E1 should give me 10. If "USD Different" then cell E1 will be error.

Would greatly appreciate if you could fix this one too

DT

"Gary''s Student" wrote:

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.