Need to create a column based on sequence of variable appear in another column
Hi All,
I want to create a column based on :Client_ID and how many times ( a number of sequence is counted as 1 count only, see the the :Comment column) it is appearing in the data set. My requirement is :Final Requirement and would be happy to have :Required Column 1 as well. I can not re-arrange/sort the data.Any help please ?Many thanks, -HSS