Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
Return column number from column header text | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) |