Excel sort 2 column with missing elements

Question

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

1. Is VBA an option? 2. Explain what happens in the example please, it is hard to understand. At least what happens with the "b". You will increase your chance of getting the answer. 3. Explain better what you expect to be the result. E.g. I want the letters (rows) to be aligned in both sets of columns, leaving empty cells for letters that are not present in the original set. — kolcinx, Commented Dec 28, 2016 at 14:29

kolcinx · Accepted Answer · 2016-12-28 14:54:32Z

1

Copy all letters, remove duplicates, INDEX MATCH

You can try this:

answered Dec 28, 2016 at 14:54

kolcinx

2,2331 gold badge17 silver badges38 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Excel sort 2 column with missing elements

1 Answer 1

Copy all letters, remove duplicates, INDEX MATCH

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Copy all letters, remove duplicates, INDEX MATCH

Your Answer

Sign up or log in

Post as a guest

Related