Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel itemized expence report templet. If I enter all expences randomly,
from different accounts and dates,how do I arrange them by account and date when I am finished? |
#2
![]() |
|||
|
|||
![]()
Hi
Mark the WHOLE range of your data. ToolsDataSort by Accounts, and Date Save a copy of your file before you start - just in case!!! Regards Roger Govier ACWIZ wrote: In Excel itemized expence report templet. If I enter all expences randomly, from different accounts and dates,how do I arrange them by account and date when I am finished? |
#3
![]() |
|||
|
|||
![]()
select the data including the header row and do Data=Sort
select accout as your first key and dates as your second key. -- Regards, Tom Ogilvy "ACWIZ" wrote in message ... In Excel itemized expence report templet. If I enter all expences randomly, from different accounts and dates,how do I arrange them by account and date when I am finished? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
how do I troubleshoot date formats in a pivot table report? | Excel Discussion (Misc queries) |