Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort two columns of part numbers so that they align?
How can I sort two columns of part numbers so that they align?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort two columns of part numbers so that they align?
You're going to have to provide a better explanation. We can't tell what you
have and what you're trying to accomplish based on your request below. If you're trying to identify whether a list of parts in column A are present in Column B, then in column C you can just use the following formula: =IF(ISNA(VLOOKUP(A2,B:B,1,0)),"","Part found") That will at least tell you if the part in A2 is found anywhere in column B. Like I said, though, I can't really tell what you're after. -- Please remember to indicate when the post is answered so others can benefit from it later. "P/N" wrote: How can I sort two columns of part numbers so that they align? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Raw data output is poor excel format part 2 - align columns | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel |