| Thread | Last Post | Replies |
|
| Fun trying to convert xls to document everyone can open! | 13 Sep 2006 22:26 GMT | 4 |
I have Office 2003 and created spreadsheet for class schedule that I could use formulas, hide columns, etc. Excel seemed to have more advantages over keeping it in MS Word. However, not everyone has Excel so I have had fun trying to convert it. It is only a two page document ...
|
| HOW DO I DELETE NUMBERS IN A COLUMN out of each cell | 13 Sep 2006 21:23 GMT | 2 |
I have a list of part numbers in a column, over 5000, and I need to change it while keeping other information in tact. For example 1025-00-128-5463 (Each of these numbers are in a cell which totals
|
| Populate a cell based on adjacent cell | 13 Sep 2006 21:14 GMT | 1 |
I have a worksheet that contains outgoing call data. The first column is the Group Number column, so each record begins with this group number. I've inserted a column to the left of the Group Number column. I want
|
| Transpose a variable length list into Excel / Access Table | 13 Sep 2006 19:37 GMT | 11 |
Example given of a variable length (library) list, but which may actually be 1000 long. How can I transpose the data into a Table in either Excel or Access? LC Control Number 79013607
|
| merging data from 1 excel file, into a master excel file | 13 Sep 2006 18:39 GMT | 2 |
I have 2 spreadsheets - a master spreadsheet and sheet #2. Sheet #2 contains all of the information from the master (with the same exact columns), plus new rows that are inserted throughout. The first column of data uniquely identifies each row. Most of the rows are identical ...
|
| Export from Excel to Word | 13 Sep 2006 17:30 GMT | 2 |
I have a 20 page Excel document that has a LOT of formating involved, it is text not data. Is there a way that I get it into Word without having to redo all the formatting? It is 11x17, landscape.
|
| Deleting or cancelling large amount of data in excel | 13 Sep 2006 17:25 GMT | 2 |
Got the following problem apparently easy but it's driving me crazy. I've a large file (c40mb) containing large matrices full of datas and formulas (ie thousands of rows / approx 100 columns) Whenever I try to delete the content (or clear content) of one of this
|
| sorting data to obtain a fixed amount | 13 Sep 2006 16:42 GMT | 2 |
Please help!! I have numbers in a row of cells and I would like to have a formula to sort the data to give me a fixed total... (like which cells would equal x) i don't know which of the cells make up that total... can excel tell me which cell combinations would equal any given ...
|
| Conditional Formatting for a certain month | 13 Sep 2006 16:26 GMT | 8 |
Having a bit of an issue at the moment, ive got the Cell for instance A1 Which contains 04-Jan-06
|
| Is there any way of calculating a running total within a single cell in a column | 13 Sep 2006 13:22 GMT | 2 |
Can anyone help with this query? e.g. I want to work out how many people are working at any time in a 24 hour period. The number of people rostered on differs each day of the week.
|
| Last ModifiedDate -15 days | 13 Sep 2006 12:50 GMT | 5 |
I have a function which does the following: 1. Remove .xls from the file and use reminder as a wild card by additing * at both the ends 2. Query the directory (source path) for the wild card
|
| Adding rows in Excel worksheets and 'deduping' | 13 Sep 2006 12:34 GMT | 20 |
Can anyone help please? I have a table of staff members and tasks set out as follows (the real one is a lot bigger) Task 1 Task 2 Task 3 Task 4 Total
|
| Inputting a US map into Excel? | 13 Sep 2006 12:24 GMT | 1 |
I gotta quick question: Has anyone ever tried to input a dynamic/auto-updated US map int Excel? Let's say I have a database which includes a column calle "state" and a column called "count", which has integer values countin
|
| How do I easily divide an excel list of names/addresses among 6 pe | 13 Sep 2006 12:05 GMT | 4 |
I am very new to Excel and need to divide an excel spreadsheet with 250 names, addresses, dates, etc between 6 people in an order of wedding date. Is there a really easy way to divide the list up so that each of the 6 people gets the next name on the list?
|
| set up print prefs in vba screen | 13 Sep 2006 11:01 GMT | 2 |
vba project window under heading VBA Project (Workbook.xls) open folder Microsoft Excel Objects I am given a list of worksheets & their given Names
|