Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and sort two different tables
Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column G,H,I has the same corresponding sales data for the next month. Although Column A and F both have customer names, there are many changes month over month with the addition and deletion of certain customers so the rows do not match up exactly. Is there a quick way to have the rows match up according to customer names in column A and F and then sort them alpabetically? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to match the values within Tables? | Excel Discussion (Misc queries) | |||
Match and Tables | Excel Worksheet Functions | |||
Match and Index for Tables | Excel Worksheet Functions | |||
Nested MATCH with two tables | Excel Worksheet Functions | |||
sort tables | Excel Worksheet Functions |