Hey guys.
I am working on a spreadsheet (see attached example), where I would like the VBA output in row 5 to be without empty cells. The idea is whenever the word Equity comes up it chooses the ISIN above the word Equity and then lists it below but without spaces. So that the 4 ISIN's above Equity are listed side by side in row 5.
Have tried many combinations but have been unable to get it right.
MB
Bookmarks