| Thread | Last Post | Replies |
|
| must list products,qty. and customer sign-up | 19 Sep 2006 22:09 GMT | 1 |
Making a sell-sheet. need products listed on left.....blocks for qty ordered, and customer sign-upswith phone number on top of sheet...as in fund raising ordersheets . help?
|
| Duplicate cells | 19 Sep 2006 21:31 GMT | 1 |
I have a large spreadsheet consisting of about 16,000 rows and 8 columns. The first columns are longitude and latitude coordinates. Is there a way to sort and display the rows where both the values in columns A and B are the same? I have sorted on A then B but sometimes places ...
|
| fill column with pattern of information | 19 Sep 2006 19:36 GMT | 2 |
I'm trying to fill in a single column in a worksheet with warehouse locations as follows: 01AA01AA01 01AA01AA02
|
| 65536 Rows for how long???? | 19 Sep 2006 19:31 GMT | 12 |
I was wondering: is Microsoft planning on expanding the 65536 row limit? They most deffinitely should! Best regards, Albert
|
| Pasting a range | 19 Sep 2006 18:50 GMT | 3 |
I need to paste the range "WHrange" from sheet "WidthHeight" to R1C1 in sheet "Results" BUT I only want Values and Formats. Incidentally, what already exists in the Results" sheet has to be moved to the right to make space so seven columns must be inserted first - I can do
|
| how to calculate the age of an employee | 19 Sep 2006 18:11 GMT | 13 |
I have a list of employees with their date of births - for example 1/1/1988. I need to have a column that works out the age with todays date. Is this possible? Thanks
|
| Counting # of events per day` | 19 Sep 2006 17:48 GMT | 2 |
I have a file with the following format col a event name col b event date (e.g., 9/01/2006) col c event day of week (Mon, Tu, etc)
|
| READ BEFORE INSTALLING OFFICE 2007 B2TR | 19 Sep 2006 17:48 GMT | 38 |
The B2TR patch has some nasty surprises for users in store. The most important one being that Word 2007 Beta 2 files saved in the new file formats (extensions docx, docm, etc) might not open at all once B2TR has been installed.
|
| using someone else's spreadsheet | 19 Sep 2006 17:46 GMT | 3 |
One of my work colleagues has created an Excel spreadsheet that pulls date from another Excel file and use it in a chart. The files store production deata for his shift He keeps both files on his desktop
|
| Formatting a decimal representation of millions | 19 Sep 2006 17:40 GMT | 3 |
How can I format a number in a cell such as 0.55 (the cell heading is $ millions in another cell to read $550K? Is this possible? Thanks, s
|
| Apply Headers and Footers | 19 Sep 2006 17:13 GMT | 1 |
Is there a way to apply a header and a footer to each worksheet without typing it in for each worksheet
|
| imposiible to print comments, neither titles | 19 Sep 2006 15:47 GMT | 3 |
I try to print comments but with no sucess whatever I make the options in PrintPreview -> Setup -> Sheet Tab:: Print area: Print titles -> Rows to repeat at the top
|
| Problem with links in workbook | 19 Sep 2006 15:13 GMT | 2 |
Not sure how it's happened, but somehow on the current workbook i'm working on, a link has been put in to a totally unrelated workbook. I've gone into Edit to see where the link is but can't get rid of it. Any ideas?
|
| How to delete most of the "custom sort list" | 19 Sep 2006 13:33 GMT | 1 |
I didnt like what Excel imported now I have a lot of junk that will take a very very long time to remove from the custom list. Is there a way to delet them? I tried shift control and selecting the ones but that didnt work.
|
| Vlookup & Macro Help! | 19 Sep 2006 13:20 GMT | 2 |
I am seeking help w/ a complex Vlookup formula. I am trying to write a formula that allows a user to enter a product number in a cell and have the product description and subsequent price appear in the adjacent 2 cells. The information would be pulled from a product catalogue ...
|