| Thread | Last Post | Replies |
|
| Help Excel Formatting | 07 Jun 2007 20:03 GMT | 1 |
I have a word document that I want to convert to an excel file, that looks like this: Product: Apple Price: $1.00
|
| formulas appear in cell as entered.. | 07 Jun 2007 18:52 GMT | 3 |
whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula just appeared as normal text, displaying exactly what I typed in. how can I get it to work? I do not think this is due to the manual calculation update option, as it
|
| Finding missing values in a column | 07 Jun 2007 18:45 GMT | 1 |
I'm looking for a way to automaticaly find missing values in a column of numbers. Here's an example (all values are in the same column): 50 51
|
| Need Help Creating a Macro Multiple Workbooks to One | 07 Jun 2007 18:20 GMT | 1 |
HI I need Help Creating a Macro for my job! We currently have two workbooks, one has multiple worksheets containing invoice information. The other has one worksheet containing all of the information of the other workbook.
|
| Formatting Cells? | 07 Jun 2007 18:19 GMT | 2 |
I need to know how to put an * before and after each value I have in a column. For example, if Column A is 1 to 5, I will paste them in B, and then change them to barcode font. My scanner only reads barcodes that start and end in an * . It is easy to do it for a few by hand, ...
|
| Dispay two values in one cell with the / border separating them. | 07 Jun 2007 18:12 GMT | 2 |
Is there a way to display two values in one cell with the / border separating them?
|
| how can i make a list of numbers automatically | 07 Jun 2007 18:09 GMT | 1 |
i'm trying to make a calendar for a project and would like the 'fill handle' button to automatically correlate the numbers. anyone could let me know how to do that? sometimes it happens automatically but other times it doesn't seem to work
|
| Help with Hlookup/Vlookup and Lookup. From multipul sheets | 07 Jun 2007 17:53 GMT | 1 |
there are a total of 2 sheets that I am working with. I would like to lookup a value on sheet 1 and corespond with anothee value on sheet 2 and then take the value parallel to that in sheet 2 and input that value in sheet 1. then I would like to frag down the function so I do not ...
|
| unable to see postings after 6/5/07 | 07 Jun 2007 17:24 GMT | 1 |
I am unable to see postings after 6/5/07 on discussion lists and have been notified of replies. But since I can't see anything after 6/5, I can't see them. Please respond to this email so that I can fix this? No one from our organization can see after 6/5 either, so I don't know ...
|
| Sum of Column with next column containing specific word | 07 Jun 2007 17:12 GMT | 2 |
Here is the situation: I have a spreadsheet I am using for a timecard, in column Q, rows 18-31, I have a spot for employees to type in their "other" hours. In Column R in the same rows I have a spot for them to choose from a drop down what type of
|
| SUMIF Conditions | 07 Jun 2007 16:34 GMT | 3 |
=SUMIF($F$6:$F$2000,$O8,$G$6:$G$2000)*AND($M$6:$M$2000<=60) this function ignores the AND statement.....Please Help Thanks, Adam
|
| HOW CAN I MAKE AND OR ADD NEW SYMBOLS TO THE LIST? | 07 Jun 2007 16:28 GMT | 1 |
I WANT TO ADD BIM PICTURES OR DRAW HEM MYSELF.
|
| IF..THEN..ELSE | 07 Jun 2007 16:11 GMT | 9 |
=IF(ISBLANK(I2),X2,I2) If both I2 and X2 are blank I get 0 (zero) What I need is a blank cell How do I modify the formula to get the desired results.
|
| Conditional Average | 07 Jun 2007 16:03 GMT | 1 |
I have many columns of information. And I want to average the information in one of the columns based on a certain value appearing in another column. I am using Excel 2002. In example below I would like to average the numbers in column 3 if its associated number in column 1 is ...
|
| Filtering diverse values | 07 Jun 2007 15:56 GMT | 1 |
I'm trying to filter out diverse values in a column Assume: A1:A5 = Name1 A6:A10 = Name2
|