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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and sort two different tables
Maybe I'm missing something, but if customers are added/deleted from month
to month, how can the 2 lists match up? Maybe some examples would help. HTH Otto "yowzers" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and sort two different tables
Thanks for the response. I hope the example below will clarify.
Currently my list looks like this: Jan Feb A A B C D D F E H F L G M H I would like it to look like this: Jan Feb A A B C D D E F F G H H L M "Otto Moehrbach" wrote: Maybe I'm missing something, but if customers are added/deleted from month to month, how can the 2 lists match up? Maybe some examples would help. HTH Otto "yowzers" wrote in message ... 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? . |
Reply |
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 |