Good day Mr Excel team,
I am currently forced to get my tax documents ready for state office. All the data is matched up in a 5000+ cell long excel. That you have build a community to help can be a big value!
My questions:
How can I summarize all the prices which are mixed in EUR, USD , GBP into one final Price?
How can I cut all the price which are mixed in EUR, USD, GBP into sum up for EUR, USD, GBP?
Example:
Thank you very much in advance!
I am currently forced to get my tax documents ready for state office. All the data is matched up in a 5000+ cell long excel. That you have build a community to help can be a big value!
My questions:
How can I summarize all the prices which are mixed in EUR, USD , GBP into one final Price?
How can I cut all the price which are mixed in EUR, USD, GBP into sum up for EUR, USD, GBP?
Example:
6,99 EUR |
3,59 USD |
4,04 GBP |
4,49 GBP |
6,29 EUR |
3,59 EUR |
3,99 EUR |
6,29 EUR |
3,99 USD |
6,29 EUR |
6,99 EUR |
7,99 USD |
3,59 USD |
3,99 USD |
3,99 EUR |
3,99 USD |
7,99 USD |
3,99 USD |
3,99 USD |
3,99 USD |
4,49 GBP |
3,99 USD |
Thank you very much in advance!