Hi All,
So i have an excel sheet that has lots of different Columns and Rows (lol) with Mixed Data or Letter and Letter and Numbers, Now i know how to split a cells data containing multiple words in split via a , or space for example - Not a problem but as some fields have more data in them thatn other the results of the split are different for each line, What my ask is and i think its a long show, is there a way i can have a list of Names in 1 Column, then in the other columns search the data in the table and reporting back the information
In the Example show,
Under Pld count how many times PlayerA, PlayerN etc.. show in the Played Column
Under Gla count how many times PlayerA, PlayerN etc.. show in the Goals Column - And if Possible count and Additional Numbers after the name
Under *** count how many times PlayerA, PlayerN etc.. show in the Assist Column - And if Possible count and Additional Numbers after the name
Under Pld count how many times PlayerA, PlayerN etc.. show in the Played Column - And if Possible count and Additional Numbers after the name
So it sort of looks like this
Hope this makes sence
So i have an excel sheet that has lots of different Columns and Rows (lol) with Mixed Data or Letter and Letter and Numbers, Now i know how to split a cells data containing multiple words in split via a , or space for example - Not a problem but as some fields have more data in them thatn other the results of the split are different for each line, What my ask is and i think its a long show, is there a way i can have a list of Names in 1 Column, then in the other columns search the data in the table and reporting back the information
In the Example show,
Under Pld count how many times PlayerA, PlayerN etc.. show in the Played Column
Under Gla count how many times PlayerA, PlayerN etc.. show in the Goals Column - And if Possible count and Additional Numbers after the name
Under *** count how many times PlayerA, PlayerN etc.. show in the Assist Column - And if Possible count and Additional Numbers after the name
Under Pld count how many times PlayerA, PlayerN etc.. show in the Played Column - And if Possible count and Additional Numbers after the name
So it sort of looks like this
Hope this makes sence