This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Any help in grouping a large data set using the requirement detailed in the example below would be greatly appreciated.
The first four rows fall into the same group due to the fact that a record within the row (marked in bold) has been categorised previously. Row 5 contains a completely unique data set, therefore a new group is created, as has Row 7.
Essentially, if any value is repeated throughout Col A, B or C, which has already been grouped, it should inherit the same group.