Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to match between same numbers
Hi,
I have to columns, each one start from 1 to 500. the data is mixed (No. and letters) What I want to do is matching between the same data with a color or sort them by each other and the unmatched date should be at the end of both columns. also, can those matched No. be color? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to match between same numbers
Let's say that you have column A and B on the same sheet.
Insert a new column B, then insert another column, so that your original data is in columns A and D. In cell B2, use the formula =ISERROR(MATCH(A2,D:D,FALSE)) and copy down to match your list in column A. Then in cell E2, enter the formula =ISERROR(MATCH(D2,A:A,FALSE)) and copy down. Then sort columns A:B based on column B (the TRUE values are not matched). Then do the same for columns D:E. HTH, Bernie MS Excel MVP "ghost" wrote in message ... Hi, I have to columns, each one start from 1 to 500. the data is mixed (No. and letters) What I want to do is matching between the same data with a color or sort them by each other and the unmatched date should be at the end of both columns. also, can those matched No. be color? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum numbers that match two conditions? | Excel Worksheet Functions | |||
how can I match numbers from two columns? | Excel Worksheet Functions | |||
how can I match numbers from two columns? | Excel Worksheet Functions | |||
How to find MATCH numbers ? | Excel Worksheet Functions | |||
Match numbers in range | Excel Discussion (Misc queries) |