D
Dave
Hi,
I have a spreadsheet with the following columns:
Item # 1 to 1000
Account Number alphanumeric 20 characters long
Amount 1
Amount 2
Period 1
Period 2
Data is currently sorted by Amount 2 ( largest to smallest).
There are multiple entries for the same account.
What I want to do is now group the data so that All the same account
numbers are grouped together along with all other fields but in this
grouping I want the amounts to keep the current sort largest to
smallest ( largest to smallest).If an account as three numbers I want
them on the sheet in consecutive lines
Thanks for all your help,
I have a spreadsheet with the following columns:
Item # 1 to 1000
Account Number alphanumeric 20 characters long
Amount 1
Amount 2
Period 1
Period 2
Data is currently sorted by Amount 2 ( largest to smallest).
There are multiple entries for the same account.
What I want to do is now group the data so that All the same account
numbers are grouped together along with all other fields but in this
grouping I want the amounts to keep the current sort largest to
smallest ( largest to smallest).If an account as three numbers I want
them on the sheet in consecutive lines
Thanks for all your help,