Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Question
I have two columns of data that I want to match up. The
problem is that one of the columns has less data than the other. I want the cells to line up when they equal the same number. Some of the cells will not have an equal though. I know that I can sort both columns, but the data will not line up because one of the columns has less data than the other. I can do an insert to push the data down so that it lines up, but that is time consuming. Thank you. Tim |
#2
|
|||
|
|||
Here's one solution: a list of numbers- I used 1 thru 10- in A1:A10. A
second, shorter list of numbers in C1:C3. I wrote the following formula in E1 and copied it thru E10: =IF((ISERROR(MATCH(A1,$C$1:$C$3,0))),"",A1) This does not require the lists to be sorted. Will that do it for you? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
sorting question | Excel Worksheet Functions | |||
sorting question | Excel Discussion (Misc queries) |