Hi all,
I have a spreadsheet with many thousands of rows and tens of columns. A small sample of the data is below:
batch_id Name_first Name_last
15908 Luis Abengozar
16828 Luis Abengozar
16968 Luis Abengozar
17156 Luis Abengozar
17156 Luis Abengozar
17178 Luis Abengozar
18087 Luis Abengozar
In general these 3 columns will have other columns between them.
What I want to do is for each last_name show a count of the total number of batch IDs and also a count of the unique IDs.
So the final output from the data above would be:
Name_first Name_last Total_Batch Total_Unique
Luis Abengozar 7 6
I'm familiar with using an array in this way :
myarray = Range("a1:a10").Value
However I think my searching skills are lacking or my vacabulary is not sufficient to properly bring up search examples of populating an X by 3 array.
Also would this approach be the right way to do this? Is there a better way?
Many Thanks for any input
I have a spreadsheet with many thousands of rows and tens of columns. A small sample of the data is below:
batch_id Name_first Name_last
15908 Luis Abengozar
16828 Luis Abengozar
16968 Luis Abengozar
17156 Luis Abengozar
17156 Luis Abengozar
17178 Luis Abengozar
18087 Luis Abengozar
In general these 3 columns will have other columns between them.
What I want to do is for each last_name show a count of the total number of batch IDs and also a count of the unique IDs.
So the final output from the data above would be:
Name_first Name_last Total_Batch Total_Unique
Luis Abengozar 7 6
I'm familiar with using an array in this way :
myarray = Range("a1:a10").Value
However I think my searching skills are lacking or my vacabulary is not sufficient to properly bring up search examples of populating an X by 3 array.
Also would this approach be the right way to do this? Is there a better way?
Many Thanks for any input