Over laying combined data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have years of sales history in 3 different work sheets and I woul like to
overlay them so that I can look at each company for a 3 year period. I need
to do this while not repeating customer names and knowing thatsome customers
are not on all lists?

Any help?
 
Hi Zane. Would it be possible to create a 4th sheet with all your customer
names and use VLOOKUP on the other 3 sheets to draw in the information into
the 4th?
 
You must log in or register to reply here.

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

summing total sales formula 1
Accumulative sheet data 5
Show me your highest mileage HDD? 0
Highlighting Like Names in a Column 3
Combining Data on two worksheets 2
Sumif with references on different tabs 4
Counting NONZERO Cells - Filtered and Pivoted 6
Pivot tables 2 row labels 4

Back
Top