| Thread | Last Post | Replies |
|
| Spilting Data in the same cell | 16 Sep 2006 09:40 GMT | 3 |
I have a Excel Spreadsheet that contacts both the names and addresses in the same cell. I want to separate these to items making one cell for the name and another for the street address, city, state, zip. Is there a way to do this without having to redo the data by moving it to ...
|
| Cell format in Excel | 16 Sep 2006 09:10 GMT | 2 |
When I try to enter a credit card number in an cell it always chages to zero when I push enter
|
| Number Formating Cells (Time) | 16 Sep 2006 08:09 GMT | 6 |
I am having a little problem here. I am employed for a small television station, and have created a worksheet to track how many times each commercial spot is played, and at what time it is played. I need to be able to insert the times quickly without typing in the colon, and ...
|
| copy non-consecutive rows | 16 Sep 2006 07:39 GMT | 7 |
i am copying non-conseutive rows from 1 workbook to paste into another workbook. when i paste excel is pasting the enitire range of rows instead of only the selected rows.
|
| If I have date, can excel calculate the day for me? | 16 Sep 2006 06:01 GMT | 6 |
If I have date entered in a cell, can Excel calculate which day it was for me?
|
| Multiple criteria/Countif question | 16 Sep 2006 04:13 GMT | 3 |
How can I have multiple criteria counted in the same range? Specifically, I am looking to count the total number of individuals who are working either 10 or 24 hours on a given day together in one cell. They are listed in coulmns that correspond to the days of the month. I ...
|
| I want to combine 2 workbook data bases and remove duplicates | 16 Sep 2006 03:20 GMT | 1 |
I have multiple data bases in Excel I want to use for labels in mail merge but I want to combine the data bases and remove duplicates. the compare & merge workbooks under "tools" is greyed out.
|
| SHOPPING CART | 16 Sep 2006 02:53 GMT | 1 |
I need to add a shopping cart to my website - does FP support this internally, or do I need to purchase a separate application. If so, any recommendations? Thanks,
|
| Pivot Table - hide if no data | 16 Sep 2006 01:19 GMT | 2 |
My pivot table layout looks at only some of the fields in an underlying Access table. I'd like see only the rows that have data in these fields. Ex: I want to see customer, product, current year sales, gross profit. My underlying data also includes prior year spending. I don't ...
|
| Conditional SUMPRODUCT | 16 Sep 2006 01:07 GMT | 2 |
Following seems simple enough, but I haven't figured it out so far. I have some columns with percentages and dollar figures, like so: T U Range as Expected
|
| Charts and formulas | 15 Sep 2006 23:57 GMT | 3 |
I am trying to create a spreadsheet that imports from various servers the total size of the drive, total free space and presents the data as a percent of free space. This must be presentable in chart form. I tried but I can't get the formula to work and the chart is unusable ...
|
| formula question | 15 Sep 2006 23:54 GMT | 2 |
Is there a way to de-concatenate a concatenated string of text? I have the following formula, =CONCATENATE("Avg $ per week is: ",DOLLAR((N2/COUNTIF(M14:M167,">0")))) And I would like to extract from that text string the numerical value used
|
| formula | 15 Sep 2006 23:31 GMT | 6 |
I have a spreadsheet where, cell U6 is an average of Z6-AE6. i also need U6 to =0 if any cell within Z6 - AE6 is a 0. Can anyone help please
|
| How do I remove a flash object "stuck on" my spreadsheet? | 15 Sep 2006 23:03 GMT | 1 |
I copied info from a table on a web page. My selection included an ad by accident. Now I cant select the Macromedia Flash object, so that I can delete it by right click. Any Ideas?
|
| Cannot print a complete page of labels | 15 Sep 2006 22:55 GMT | 1 |
I checked whole page under the labels but only 4 in one row are being printed. This problem occurs in Office 2003.
|