Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting rows of 2 Seperate Columns Together
I have a task where I have to compare the balance of each individual customer
account in our company accounts receiablve in the current week to the previous week. For each week, I have 2 columns- one for customer account numbers and the the second for account balance. A cusomter may appear on the list for one week and not thefollowing week's list in the case where the customer has paid resulting to no balance in the account the following week and vice versa. When puting all data in one spreadsheet for week-by-week comparison of each individual customer account balance, I am having a problem with how to sort the rows in each of the customer account column wherby each customer account number in the current week column line up across with the same customer account number in the previous week column so that I can make a week-by-week account balance comparison for each individual account numbers. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting rows of 2 Seperate Columns Together
Without using a macro this can be done using VLookup. You will need to get a
unique list of accounts that only had activity for the past two weeks. I usually do this by copying the first weeks list of accounts (column A only )to a new worksheet. then copying the second weeks list to the end of the first weeks list in column A. I usually sort this list. Then I select the combined list and go to menu Data - Advance Filter I select Unique values and select copy to new location and select the new location. Now you can use the unique list to create a vlookup. Copy the unique list into column A overwriting the old data. Then put a Vlookup in Column B for one weeks data and then but a second vlookup in column C for the 2nd weeks data. "jcortes" wrote: I have a task where I have to compare the balance of each individual customer account in our company accounts receiablve in the current week to the previous week. For each week, I have 2 columns- one for customer account numbers and the the second for account balance. A cusomter may appear on the list for one week and not thefollowing week's list in the case where the customer has paid resulting to no balance in the account the following week and vice versa. When puting all data in one spreadsheet for week-by-week comparison of each individual customer account balance, I am having a problem with how to sort the rows in each of the customer account column wherby each customer account number in the current week column line up across with the same customer account number in the previous week column so that I can make a week-by-week account balance comparison for each individual account numbers. Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting rows of 2 Seperate Columns Together
Excel 2007 Pivot Table
Consolidate weekly tabs, view in columns. http://www.mediafire.com/file/af432y5zyjj/03_30_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data from Rows to columns in seperate worksheets | Excel Worksheet Functions | |||
How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
Sorting rows AND columns | Excel Worksheet Functions |