| 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. |
| 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) | |||
Threaded Mode
