General
in [Excel]
|
Excel close on startup, but stay in task manager Some of my users complains about problems opening Excel documents. About 2 sec. after they open a document it close automatically. I have found out that the excel.exe process stay as an active task and can be closed from the task manager. It is not happening every time but almost! I have tried starting Excel in ... 20 May 2010 03:00
Error in Copying "Exact" Function I have an excel spreadsheet with two columns, legal forename and preferred forename. I ran a "exact" function so it would appear true if the two surnames were the same or false if not. There are 180 odd rows so I wanted to just copy and paste or drag the "exact" formula instead of having to manually entering it ... 18 May 2010 08:10
Conditional formatting Hi, i have a date in a cell (17.06.2010). I need conditional formatting to change the cell color with 30 days before that date to expire. Something like this. if today is 18.05.2010 and i have 17.06.2010, than the color of that cell to change. Can this be done? Thanks! ... 18 May 2010 08:10
Dynamic data ranges in pivot tables I am using Excel 2002. I have defined a dynamic data range and am using it in a pivot table, which works OK. I have added a new column to the data range, but when I use the pivot table wizard to update the layout, the new column is not available. If the range is dynamic, why wont it accept new data? Thanks... 19 May 2010 13:48
How do I get to change my xl document in to readable text or numbe I have a few documents that I cannot read I think they may have been done in works but I cannot read the documents ... 18 May 2010 07:05
Formula Help Hi, Hope you can help me, I have a report which I need to delete some lines of data. The criteria is as follows: Each record can have numerous lines of data and has a unique reference i.e. MEBACI, however if this record contains any of 9 conditions in column M the record should be left in full with no dele... 18 May 2010 07:05
MAX IF Dear, I am looking for a formula which would give the max value of each city in column D based on the entry's in column B. Please help. Col A Col B Col C Col D Texas 76 Texas = Detroit 252 Detroit = Detroit 29 Tenesse Texas ... 18 May 2010 07:05
I need help with a macro please! This bombs at the end - with a no cells were found message. My objective is to copy a file to another file and delete the blank rows - where company is blank. - Thanks for any help.. Here's an example of my file: COMPANY VENDOR INV DESCRPT INV_AMT 3042 40315-3042 04/10 Sales Tax 0 0 ... 19 May 2010 19:24
IF Formula I'm needing a formula that will do the following... If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows with the word Performing. If A1 is 3 it shows with the word Leading. Thanks ... 17 May 2010 22:24 |