Combining alike cells?

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

Guest

For my job I am trying to make a spreadsheed that will be used and updated
over the next couple of years. It will be a document of differant customers
and products we have sold. The Y axis will contain Customers the product sold
while the X axis will be the dates. Is there something I can do to click a
cell with a customers name and it highlights or shows every time their name
was placed in the spreadsheet?
 
Your request seems like a good candidate for a pivot table if you data is
structured correctly.

I would suggest you start with column headings of 'Customer,' 'Product,'
'Qty,' 'Amount,' and 'Date.' You could then create a pivot table to assist
in displaying and analyzing your data by customer, date, or product, just to
name a few. As you get more experienced you can group this information by
customer type, or product category, etc. Pivot tables even have decent
graphing capabilities for trend analysis. You can find a lot of information
in EXCEL's help feature , or on the internet.
 
You can easily Filter for customer names with Data>Filter>Autofilter

Don't know if that will help but give it a try.


Gord Dibben MS Excel MVP
 
Back
Top