Re: $$Excel-Macros$$ Group Data

2010-04-06 Thread Dave
Thanks AJ I was able to solve the problem. Thanks again!! On Mar 26, 12:18 am, Abhishek Jain wrote: > Hi, > > A sample file of your query would help to understand better, please attach > if possible. However, you may try subtotal. Data>Subtotal. > > Cheers! > > AJ > > > > On Thu, Mar 25, 2010 at

Re: $$Excel-Macros$$ Group Data

2010-03-26 Thread Abhishek Jain
Hi, A sample file of your query would help to understand better, please attach if possible. However, you may try subtotal. Data>Subtotal. Cheers! AJ On Thu, Mar 25, 2010 at 11:21 PM, Dave wrote: > Hi, > I have a spreadsheet with the following columns: > > Item # 1 to 1000 > Account Number al

$$Excel-Macros$$ Group Data

2010-03-25 Thread 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 number What I want to do is now

$$Excel-Macros$$ Group Data

2010-03-25 Thread Dave
Hi, I have a spreadsheet that has the followin columns. It has about 1000 rows. Item #> 1 to 1000 Id Number ===> -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Group Data Together

2010-03-25 Thread Dave
Hi, I have a spreadsheet with the following columns: Item # ID Number -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Fa