CODEWITHSUNDEEP
excel
S.A
S.A

Reputation: 1

Sorting one column based on another one in excel

enter image description here

How do I get column E to skip rows where there no duplicate in column A.

enter image description here

Upvotes: 0

Views: 1255

Answers (1)

JNevill
JNevill

Reputation: 50273

Instead of trying to figure out how to insert blank rows in Column E and F where there is a missing value based on A... use a Vlookup() in Column D to grab the relevant pieces from Column F:

Assuming your data starts on A16 according to your picture, in D16 enter:

=Vlookup(A16, E:F, 2, False)

And copy that down. Now you will have Column F values in their appropriate rows in Column D.

Upvotes: 1

Related Questions