| Thread | Last Post | Replies |
|
| Lost Excel formulae | 09 Feb 2006 11:10 GMT | 1 |
I have recently created a small spreadsheet in Excel X and saved it as a workbook appended (.xls). When I re-opened it and updated some of the entries, it no longer did the the math. Any idea what I did wrong, and how I could bring the formulae back into functionality mode? I'm
|
| Duplicate look_up values in VLOOKUP | 09 Feb 2006 11:06 GMT | 1 |
I've got a VLOOKUP formula functioning in the usual way. However, sometimes the look_up value is duplicated. When this occurs VLOOKUP always returns the first instance of the entry. Is there a means to get Excel to ignore entries it has already returned an entry for?
|
| date auto format | 09 Feb 2006 10:39 GMT | 2 |
Hi all, sorry if i'm repeating something that has allready been covered but I can't find it anywhere on the forums. I've got a problem with excel automatically changing numbers that I cut and paste from the web into date's
|
| entering a date into cell and get ## symbols | 09 Feb 2006 04:46 GMT | 2 |
i am entering a date value into a cell and i that it shows is "##" Even when i print it shown "##" and no date why?
|
| copy & paste | 09 Feb 2006 04:42 GMT | 1 |
How would I copy & paste to a new sheet the format & formula but not the data
|
| numeric data | 09 Feb 2006 04:14 GMT | 1 |
i've a csv file 001, apple 002, fish when i use execl to open this file, the data in column A become 1, 2, etc.
|
| Can accumulated totals be added to a calculated column in a pivot table? | 09 Feb 2006 03:03 GMT | 1 |
Let me explain it.. I have a worksheet with data about planned and real values of investment. The data is shown with several columns that describe some properties of the target market.
|
| Countif Help please | 09 Feb 2006 02:01 GMT | 6 |
Have a spreadsheet similar to below 12/9 ACT 14/9 SA 15/9 NSW
|
| Calculate A Date Excluding Weekends And Holidays | 09 Feb 2006 01:36 GMT | 9 |
I have a date and a series of tasks that need to be completed by a certain number of days from the intial date. The time to complete the tasks can not include weekends or holidays. Example: Initial date is 2/15/2006
|
| How do I use echo with ` sign? | 09 Feb 2006 01:33 GMT | 2 |
I am doing echo in Unix promt, but it gives me error on unit>> echo "`asdf" Unmatched `. TIA
|
| Assist with Macros | 09 Feb 2006 01:02 GMT | 1 |
I am working with importing Text files with data received on 2 rows. Need to move data received with fixed width of data but on 2 separate rows. Need to transpose two lines of input into 1 row to allow Sort/Subtotal functions. Anybody have suggestions other than OTFM. :) btw, ...
|
| Using Excel's Solver for Linear Programming Problem | 09 Feb 2006 00:06 GMT | 2 |
I would like to solve a Linear Programming problem using Excel's Solver as follows: Min C = 100*X1 + 150*X2 + 120*X3 Subject to constraints:
|
| hints, tips, tricks for using workspace files | 08 Feb 2006 23:26 GMT | 2 |
I use Excel (2002) as a calculator, data reduction, and analysis too for laboratory experiments. It often seems that I will end up with handful of workbooks that work together to acheive this end. As a example, I could have one workbook that contains information o
|
| Outlook Calender to Excel Spreadsheet | 08 Feb 2006 23:21 GMT | 2 |
I have a spreadsheet that will track my time at certain places. I also put this info into my Outlook calender, is there a way that I can put something in my Outlook Calender and have it automatically put it in my spreadsheet. Or vice versa.
|
| Copy and Paste Issue | 08 Feb 2006 23:16 GMT | 4 |
I have several users who are getting this isse. Whenever they are in certain spread sheets and want to do a copy paste funtion the My Documents dialog box opens referencing a XLS sheet that is no longer available. The document that is being referenced is no longer in a shared ...
|