Grouping Data by Category and SubCategories and Summarizing unique data
Dear Experts,
I need help with writing a VBA code that will group data under a category and sub-categories and summarize unique data by using data suffix.
Attached is the sample spreadsheet.
Output1: From the raw file, group each data (File ID) under each category (Folder) and sub-category (Sub-Folder)
Output 2:
ColA: Summarize all File IDs
ColB: Unique suffix data (value before first dash of the File ID)
ColC: Value of Concatenated ColB Data, separated by Vertical Bar Pipe
Thank you!
Try
Please Login or Register to view this content.
@jindon. Super! That works! Thank you!
@Jindon - I expanded my data and I am having "Runtime Error Mismatch 13" on this line:
x = Split(Split(Application.Trim(r(3)), ": ")(1), ", ")
It happens when characters after "FIleIDs:" go beyond 235 characters.
Example:
Location
Folder 3
SubFolder2 FileIDs: 12346-4, 56787-6, 56787-11, 56787-4, 789014-5, 11111-1, 111111-2, 1111111-3, 1111111-5, 1111111-6, 12111113-1, 12346-4, 56787-6, 56787-11, 56787-4, 789014-5, 11111-1, 111111-2, 1111111-3, 1111111-5, 1111111-6, 12111113-1, XYZ-1, 11334-1
Last edited by mgcarino14; 12-04-2019 at 01:02 PM.
Try change that line to
Please Login or Register to view this content.
Thank you @Jindon, that fixed that error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks