| Thread | Last Post | Replies |
|
| Finding a future date | 15 Sep 2006 11:12 GMT | 12 |
I need to find the date when several events occur forward from today. Typical would be the Wednesday in the second week of next May. Given: A1 = 2 (second week of the month)
|
| Sort Alphabetically | 15 Sep 2006 09:41 GMT | 2 |
I have six columns of entries. Each column of entries has several headings. Under each heading the entries are sorted alphabetically but not the headings themselves. All is fine except for one list of entries that will not sort correctly.
|
| Stopping spreadsheet save | 15 Sep 2006 09:19 GMT | 2 |
We have a spreadsheet that we share among users by keeping it on a shared location on server. The problem is that we want everyone to be able to modify the sheet but we want to stop users making copies of the sheet to avoid versioning issues. Is there a way to do that?
|
| Putting a word into a cell. | 15 Sep 2006 08:03 GMT | 2 |
I would like to put a word into a cell depending on the value in another cell. Example: Cell A1=399
|
| Find replace | 15 Sep 2006 03:59 GMT | 5 |
Here's an easy one for you clever people, how do I find and replace on a single sheet or column? please. D R
|
| Assign Values to String Value | 15 Sep 2006 02:43 GMT | 1 |
I am trying to assign a numeric value to cells with string/text variables. For instance, 10-2 would signify 4 hours... so the value I would like to calculate would be 4. Is there an easy way to do this? Thanks
|
| Conditional Formatting with Arrays | 15 Sep 2006 02:36 GMT | 2 |
Hi, I have a question regarding arrays and conditional formatting. I have two columns. One is my master list which contains the numbers that I need. The other column has numbers that may or may not be inclunded in the Master list. Is there a way I can create a new column that would
|
| Lottery check | 15 Sep 2006 02:13 GMT | 13 |
We buy 35 tickets twice a week and always the same numbers. Can I make a spreadsheet that will check our tickets against the winning numbers?
|
| Two excel problems | 15 Sep 2006 02:09 GMT | 5 |
I am using Excel 2000, I have two problem, one small, one big Small problem I have a worksheet with just under 5000 rows and half a dozen columns. Two of the columns contain telephone numbers. Unfortunately in the conversion
|
| Consolidating Rows based on Cell Numbers | 15 Sep 2006 02:07 GMT | 5 |
I have rows cells that I need to consolidate to another page by a reference number found within the list. For example: Sheet 1 A B C D E
|
| Using VLOOKUP to display required information | 15 Sep 2006 01:55 GMT | 1 |
Hey all, I'm trying to create a spreadsheet that references an existing Excel file that contains data in the following format: Supervisor Name Email Phone # Bob Joe a@b.com 555-555-1234
|
| Problem Importing Fixed Width Data | 15 Sep 2006 01:42 GMT | 7 |
I have a data set of about 700 entries from an old Pascal program that was exported to a text file in this fomat: ID # : 10106 Sex : Female
|
| How do i set up a budget with self totalling column | 15 Sep 2006 00:40 GMT | 2 |
I have made a basic budget with columns Date, Money in, Money out, Balance what I want to know is if there is a way for me to put a formula in the Balance column which will recognise if there is a number in the in r out
|
| Pivot Tables: Locking Certain Features | 15 Sep 2006 00:30 GMT | 1 |
I'm looking for a way to prevent users from both adjusting pivot filters or refreshing the pivot. Does anyone know a way to lock these features, but still alllow users to move/add/remove fields from the table or select data within the fields?
|
| Using formulas for pivot table | 15 Sep 2006 00:28 GMT | 1 |
I know you have the count field but is there away to input a formula? For example customer ordered 25 cases and each case weighs 4 lbs and the end result would need to be total pounds ordered. Thanks!
|