Thanks for taking the time to read my message.
I am currently working on a spreadsheet which should filter several information.
I have three columns: one is showing a ticker (identifier of the parent company), one is showing an ISIN (Bond) and the last one is showing the currency. I would like to get the output that if one ticker has Bonds in multiple currencies all of these Bonds (ISINs) should be copied in a different sheet. This list contains about 2500 Bonds, 300 Tickers and 4 different currencies. Not every Ticker has bonds in different currencies - in fact only 50 Tickets have bonds in multiple currencies outstanding. I attached a small part of this list. The input data and range varies - that's why I need a macro.
Do you have an idea of how to solve this problem. I would appreciate every help. I am not proud of this but I worked on this for 2 days and didn't get the result I was looking for - therefore 500 pts