Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining alike cells?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining alike cells?
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. -- T Tipsy "HoganD87" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining alike cells?
You can easily Filter for customer names with DataFilterAutofilter
Don't know if that will help but give it a try. Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 14:10:01 -0700, HoganD87 wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining cells | Excel Discussion (Misc queries) | |||
Combining 2 cells | Excel Worksheet Functions | |||
using formula to compare two text lists that are not alike and ma. | Excel Worksheet Functions | |||
Excel DB alike? | Excel Discussion (Misc queries) | |||
combining cells | Excel Discussion (Misc queries) |