pbreezy
07-13-2017, 10:29 AM
Hi,
I have an excel 2016 spreadsheet with about 1000 rows of data. Each row has a name like ***_type1, or ***_type2, or ***_type3, etc. They also have further subdivisions, another column has a number (1,2,3,4, etc.) I would like to keep track of how many rows of each type the spreadsheet has and also how many are within each subdivision.
For example if the spreadsheet contains 100 rows of type1, I would like it to show on a separate sheet that I have 100 rows of type1 and 20 are in subdivision 1, 30 are in subdivision 2, 50 are in subdivision 3.
Does anybody have a macro that could do this or know a way I could make this happen?
Thank you!
I have an excel 2016 spreadsheet with about 1000 rows of data. Each row has a name like ***_type1, or ***_type2, or ***_type3, etc. They also have further subdivisions, another column has a number (1,2,3,4, etc.) I would like to keep track of how many rows of each type the spreadsheet has and also how many are within each subdivision.
For example if the spreadsheet contains 100 rows of type1, I would like it to show on a separate sheet that I have 100 rows of type1 and 20 are in subdivision 1, 30 are in subdivision 2, 50 are in subdivision 3.
Does anybody have a macro that could do this or know a way I could make this happen?
Thank you!