Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Aligning Two Columns by common number
I am trying to sort two columns in the same worksheet. Column A is my item #
from a cash register item table. Column F is my item # from my inventory. There are discrepancies between the two (Column A has an item # 6, and Column F doesn't, etc.). I am trying to sort them so Column A and Column F matches align, and the non-matches are put at the bottom or on a separate worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Aligning Two Columns by common number
Add a third column and place this formula in it:
=Exact(A1,B1) This will return true or false, then you can sort on ascending or descending on true or false to align them. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Andrew" wrote: I am trying to sort two columns in the same worksheet. Column A is my item # from a cash register item table. Column F is my item # from my inventory. There are discrepancies between the two (Column A has an item # 6, and Column F doesn't, etc.). I am trying to sort them so Column A and Column F matches align, and the non-matches are put at the bottom or on a separate worksheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Aligning Two Columns by common number
I meant
=Exact(A1,F1) -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Andrew" wrote: I am trying to sort two columns in the same worksheet. Column A is my item # from a cash register item table. Column F is my item # from my inventory. There are discrepancies between the two (Column A has an item # 6, and Column F doesn't, etc.). I am trying to sort them so Column A and Column F matches align, and the non-matches are put at the bottom or on a separate worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
Matching and aligning columns | Excel Worksheet Functions | |||
aligning two columns | Excel Worksheet Functions | |||
Sorting or aligning columns | Excel Discussion (Misc queries) | |||
aligning small #s in wide columns | Excel Discussion (Misc queries) |