P
Peruanos72
I have multiple lines of data in columns A,B, C, D,E,F,G AND H where column H
contains a dollar value. The data in each column, except H is the same for
multiple rows and then the data in columns A,B, C, D,E,F,G changes. This
continues for multiple rows. What I need to do is somehow seperate the lines
of data into groups where the data in columns A,B, C, D,E,F,G are the same so
I can then subtotal column H for that group of data.
Example:
I need to subtotal the dollar value for ABC, HER and KLE
Note: The data will change from day to day so I can't simply search for a
particular value.
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $500.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $248.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $300.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $5,896.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $4,785.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $4,456.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $12,489.00
Thanks in advance!!
contains a dollar value. The data in each column, except H is the same for
multiple rows and then the data in columns A,B, C, D,E,F,G changes. This
continues for multiple rows. What I need to do is somehow seperate the lines
of data into groups where the data in columns A,B, C, D,E,F,G are the same so
I can then subtotal column H for that group of data.
Example:
I need to subtotal the dollar value for ABC, HER and KLE
Note: The data will change from day to day so I can't simply search for a
particular value.
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $500.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $248.00
ABC 2009040 780312737 8 WAFRIJEN 6/4/2009 204984337001 $300.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $5,896.00
HER 2009041 780748728 8 522660V1 6/4/2009 571201170018 $4,785.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $4,456.00
KLE 2009042 780546059 8 3469-1-7 6/2/2009 521779986001 $12,489.00
Thanks in advance!!