This content has been marked as final. Show 2 replies
I need to group clients by product category. For that i have a straight table with ID in first column, concatenated categories in the second, and in the third column i need the name of the category which occurs most in the second column.
How do i find the rank of eatch CatName in column 2 (by row, not column) and display the one with highest rank in column 3?
Thanks in advance.