Hi everyone,
I am Kong from Malaysia. I would like to ask, if I have the following data:
Column A Column B
1111 0
1112 0
1113 1111
1114 1112
1115 1111
1116 1118
How do I sort the data so that if the value of Column B is identical with a value in Column A, it will appear below the row of the identical number in Column A. For example: (If value in column B is "1111", its row appears below the row in which "1111" appears in Column A)
Column A Column B
1111 0
1113 1111
1115 1111
1112 0
1114 1112
1116 1118
Appreciate everyone who could help.
With thanks,
Kong - Malaysia
Bookmarks