I hope someone can help me with this.
Suppose I have two columns in excel, A and B. Column has numbers 1, 9, 7, and 5. Column B has 7, blank, blank, and 1. I want to sort them so the numbers in both columns align with each other and leave the blanks if there is no matching number.
Does anyone know how to do this because I've been fiddling with this thing for over an hour with no success. Either I get a true, false, or it shows me the numbers that have duplicates, or it sorts it but doesn't match the numbers with each other.
2007-12-24
04:34:55
·
1 answers
·
asked by
corps2005
2