Range 3 columns with the common cells in the 3 columns

asked 2018-09-21 20:33:24 +0200

updated 2018-09-21 20:38:57 +0200

Hello

I have 3 columns that I want to range it is my lessons and other persons lessons I want to know which lessons are the same and what is the other lessons that i don't have but he has so my columns looks like this

A ------------------------ --B----------------------C

Maths -----------------English ------------Sport

English ----------------Maths-------------English

Sport ------------------Sport -------------Maths

My question is how to make that my columns looks like this

A ---------------- B -----------------C

Maths-------- -Maths----------Maths

English--------English--------English

Sport-----------Sport------------Sport

Please help !!!!

edit retag flag offensive close merge delete

Comments

It seems to me that you have to select each column one by one and sort it. Do not sort the entire table, but sort each column individually

JohnSUN gravatar imageJohnSUN ( 2018-09-21 21:27:40 +0200 )edit

Your example is flawed. How should it look if C has French instead of Sport, and B has Science instead of Math? If you want identical classes on a line, you will need as many lines as there are classes. Then maybe add all classes to each column, and apply character style Hidden to classes that a person doesn't take, with Hidden formatting not checked. . Then sort each column separately. After sorting modify the Hidden style by turning Hidden on, then you will only see the classes taken.

floris v gravatar imagefloris v ( 2018-09-21 22:24:48 +0200 )edit