Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching like numbers/data points residing in different columns
Hello,
I apologize if this question has already been answered, but I was unable to find an answer by searching the message archives. Perhaps this is because I am not exactly sure how to describe the function that I want to perform. I have to columns of numbers/data points. Column A contains say 35,000 numbers/data points and Column B contains only 33,000 data points. For every number/data point in column B there is an identical number/data points in column A. Basically, 2000 data points have been removed from coumn B. I want to align (or perhaps sort) the columns such that identical data points are aligned by row. When there is no corresponding number in column B for the number in column A a blank cell will be in column B -- indicating the lack of an identical number. If this was not clear (which I'm sure it wasn't), below is a much simpler version of what my data looks like now and what I would like it to like. What the data looks like now: Col A Col B 9 9 8 8 7 6 6 5 5 4 4 2 3 1 2 1 What I would like the data to look like: Col A Col B 9 9 8 8 7 6 6 5 5 4 4 3 2 2 1 1 Thank you, Brad White Graduate Student Center for Global Health and Infectious Diseases Department of Biological Sciences University of Notre Dame 5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
Returning a value in excel my matching 2 data points | Excel Discussion (Misc queries) | |||
Verifying and moving non matching numbers in columns | Excel Worksheet Functions | |||
How to create reports based on data residing in multiple workbooks | Excel Discussion (Misc queries) | |||
Matching data in columns | Excel Discussion (Misc queries) |