Hi,
I'm looking for something that can help me extract all the data for a certain value in a long list of data into a separate column.
For example, in a soccer season the data might look something like this (3 separate columns)
Arsenal | 2 | 1
Manchester United | 0 | 3
Liverpool | 0 | 2
Arsenal | 3 | 1
Everton | 1 | 2
I'm looking for the data to appear in a new columns only for the Arsenal value as:
Arsenal | 2 | 1
Arsenal | 3 | 1
I've managed to do this with formulas but it completely slows the whole spreadsheet down and makes it really difficult to work with.
Is there any VBA I can use to help me please? Unfortunately, I don't have much knowledge of VBA only formulas.
Thanks,
Baron
Bookmarks