Hello,
I’m sure this question has a really simple answer but I just can’t seem to find it. Here is the issue I am facing:
I have a spreadsheet where columns C D E are data from a database. I want to compare a corpus of data (columns A and B) to this database.
The words in A and C are similar but there are more rows in C and I only need the ones that match up with A.
How can I sort C to match the words in A ?
Thank you in advance
Please provide sample data
So basically I have something like this. I want to find a way to align CDE’s rows with A, knowing that the names in A and C will be similar but there are more entries in C.
Create a custom series of Column A, and then use Sort on Column C by selecting custom sort.
Select the range of data in A and go to Tools->Options->Libreoffice Calc->Sort Lists and add your list to it. In column C select the range and Sort->Custom Sort and select your list in the dropdown.
Thanks ! it works only for the first few rows and then it’s not aligned I don’t get it.
Maybe because sometimes in A there are more than one row with the same word ?
Is there a way to get around that ?
Would there be any way to have a blank row when A and C don’t match up ?