Thread: Sorting Columns by conditions in column A

Hello,

I have another help question.

Imagine I have 2 partitions, one is a single column (A) and list ID#s. The second partition (Columns B, C, D, E, F, G, H, I) contains 1 column (B) with a list of ID#s plus some corresponding attribute data in (C, D, E, F, G, H, I). Some of the ID#s present in Partition 1 (A) that are present in Partition 2's B column. I want to sort all of the partition 2 ID Values and corresponding attributes by the order of values as specified in Parition 1. Sometimes there will no corresponding value in ID#s in Partion 2 (Column B) to the value I want to sort by from partition (A); in those scenarios I would like if there could be a 0 entered in to the rows (C, D, E, F, G, H, I).

Any Ideas on how I would do this. If you need clarification please ask.

I have uploaded a file that I hope will help.