I have a spreadsheet where I have a column with different currency headers. I am only allowed to have one currency per record.
For example, I have the following 5 column headers starting in B1:
US, CA, UK(GBP), FR(EUR)
what I would like to do is create a formula that would determine which...