| Thread | Last Post | Replies |
|
| Looking for excel templates | 22 Aug 2008 20:13 GMT | 2 |
I am a real estate investor and looking for a template for my repairs and costs. I am not sure how to make my own templates. Can someone help? Thanks
|
| Concatenate with date range | 22 Aug 2008 20:09 GMT | 7 |
I have 3 columns and multiple rows. Column A contains the product name Column B contains the start date Column C contains the completion date
|
| Matching data/columns from two seperate files | 22 Aug 2008 20:09 GMT | 5 |
Can someone tell me the best way to list data that comes from two seperate files? Example: I have two files 1) A Plant & Store master excel file (list all store numbers and the plant)
|
| How to ignore blank date cells in sumproduct | 22 Aug 2008 20:06 GMT | 5 |
I have a worksheet in which I am tring to sum the data based upon a code range, a date range and cost range. However when I enter this formula it sums the data from blank cells into the cell i wish to sum all the costs for January.
|
| Excel 07 gridline appearance | 22 Aug 2008 20:00 GMT | 3 |
I just installed Excel 2007. The gridlines appear very light blue and are hard to see. Is there any way to make the gridlines appear darker?
|
| How to send specific cells on a worksheet in office 2007? | 22 Aug 2008 19:58 GMT | 3 |
In Office 2003 you could send specific cells on a worksheet by selecting the cells that you want to send. I can seem to figure out how to send it without sending the whole worksheet in Office 2007
|
| Dynamic Range including some blank rows | 22 Aug 2008 19:58 GMT | 2 |
I am trying to find the last non-blank cell in a range that also contains blanks. The data is a list of data with the corresponding date, but there will be blanks for days which are a Sunday or Holiday. The range increases every day, but I don't want to base the list on the ...
|
| Advanced Filter Grayed Out??? | 22 Aug 2008 19:44 GMT | 3 |
Why would the advanced filter option be grayed out when trying to remove duplicate records. I have close to 40000 records, but I know there are duplicates. I am trying to slim down the file to unique records only, but when I try to select Advanced Filter, it will not let me chose ...
|
| Calculate elapsed time Excel 2003 | 22 Aug 2008 19:43 GMT | 3 |
I want to calculate the time between start and end times. For example: Start time would be 2:30 pm and end time would be 5:45 pm. Then I want to take that value and multiply it by 13. Any help is greatly appreciated
|
| Extracting Data | 22 Aug 2008 19:38 GMT | 9 |
If you have addresses in a field, how can you extra the number portion of the address & put it into a separate field/box?
|
| if formulas | 22 Aug 2008 19:36 GMT | 2 |
I'm trying to create a formula to do the following. Can someone help me put this in the correct format? If E8=X, then G8=(g4*m8) and if E8 is blank, leave blank
|
| Bar graph and stacked bar graph on same graph | 22 Aug 2008 19:26 GMT | 3 |
This is a strange request. I know how to do graphs with multiple y-axis, but I've been asked to graph 5 columns of data. The first 3 columns as a bar graph on the left y-axis and the last 2 columns as a stacked-bar graph on the right y-axis.
|
| Add in Flowchart symbols | 22 Aug 2008 19:22 GMT | 1 |
I downloaded computer flowchart symbols off Microsoft's site with Excel 2000. I can't seem to find the add in for Excel 2003. Does anyone know the name of the Microsoft addin for Excel 2003 that lets you put in computer flow chart symbols?
|
| vlookup & multiple values for one customer | 22 Aug 2008 19:05 GMT | 1 |
I'm using VLOOKUP to combine data from 2 years. I want to organize data across columns, but problems arise when a customer has more than one entry per year. Here's what the raw data looks like before using the formula (the dashes
|
| custom pop up message | 22 Aug 2008 18:43 GMT | 1 |
When an excel spreadsheet is opened, can I have a custom message pop-up for other users? It is for documentation control.
|