Beentrill
10-04-2014, 12:12 PM
Hi Guys,
Kind of new to vba in excel. Im working with Excel 2010.
In the attached workbook, you will see Sheet2 that stores some user names. In Column D, each user will have a box score rating which is set up as a string. There are altogether 7 possible box score ratings that a user can have.
I need to create a macro that can put all of the unique box score ratings into an array (7 columns) into another worksheet, then sum up how many users there are with each box score.
Can anyone online right now help me?
Kind of new to vba in excel. Im working with Excel 2010.
In the attached workbook, you will see Sheet2 that stores some user names. In Column D, each user will have a box score rating which is set up as a string. There are altogether 7 possible box score ratings that a user can have.
I need to create a macro that can put all of the unique box score ratings into an array (7 columns) into another worksheet, then sum up how many users there are with each box score.
Can anyone online right now help me?