CODEWITHSUNDEEP
excelsortingmissing-data
Grisu70
Grisu70

Reputation: 57

Excel sort 2 column with missing elements

I have a sheet with 4 columns and N rows. I would like to sort the columns leaving the empty fields when corresponding value is missing in the other columns. I need your help as I don't find a way to solve.

Maybe the example will help understand my question:

Example

Many thanks in advance

Fabrizio

Upvotes: 0

Views: 758

Answers (1)

kolcinx
kolcinx

Reputation: 2233

Copy all letters, remove duplicates, INDEX MATCH

You can try this:

enter image description here

Upvotes: 1

Related Questions