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 |
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? |
All times are GMT +1. The time now is 08:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com