Maching Condition

  • Thread starter Thread starter jophy
  • Start date Start date
J

jophy

I need to Some favour..

I want to write a filter condition in VBA.

Customer Bank a/C Amount ANSWERE SHOULD BE AS
FOLLOWS
ABC AA 100 ABC AA 150
ABC BB 200 ABC BB 200
CBD AA 50 CBD AA 50
ABC AA 50


I have data in three column-COL-1 contain Customer # and COL-2 contain
Bank A/C and CoL-3 contain Bank deposit amount. Now I want to sum up
all the amount depending Emp# with same bank account

Can any one help me out ?
 
jophy,

Select your table, then use Data | Pivot Table... and set up a pivot
table to sum your desired values based on your desired criteria.

See help for more about using Pivot Tables.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup with multiple results 4
auto filter with condition 1
Counting question 5
How can SUM a column based on values of other columns? 6
Sorting a spreadsheet that is grouped/outlined 2
totaling criteria 1
Access Report Incorrectly Summing Grouped Data 1
Converting Rows into Columns 3

Back
Top