General

D-Concentrate numbers
I am trying to delete some numbers from a column for example: column A has total duration of a task times 0587-1856 and I would like to have column B with only first four numbers 05:87 (start time for the task). Please help on this formula. Thanks in advance for your help. Kimti ... 5 Apr 2010 19:30

Charts Resize on Open
I have several workbooks containing charts. Everytime I open these files, the size of the "plot area" has shrunk to the point that you cannot read the information on the charts. Each time I open these files, I re-adjust the "plot area" and re-save the file, but it continues to happen. Is there something that... 5 Apr 2010 15:01

Size of drop down in validation list
I have a validation list which contains about 50 elements. The drop down only shows 9 entries which I can then scroll through. Is there a way to get the drop down to show more entries? There is nothing below the cell which contains the validation list. Thanks for any help on this. ... 5 Apr 2010 17:16

AutoCalculate
I selected "none" as the option and now I can't enable the function. ... 5 Apr 2010 15:01

Named range error
I created a spreasheet with named ranges, then added another worksheet in the file. Some of the fields on the 2nd tab refer to information on the original information and it's causing a number of named range errors. I'd simply go delete them but I can't . . . why not? Help! Thanks. ... 5 Apr 2010 13:53

lost ability to sort by color
Once was able to filter by color but option is no longer available on the drop down menu ... 6 Apr 2010 16:29

The picture is too large and will be truncated."-excel Warning
I select a single row or column in excel and then select copy and then get a pop up window from excel that warns "The picture is too large and will be truncated." Could anyone please advise on the cause and a solution? It happens in any worksheet even with or w/o macros. I am not dealing with a 'picture' so the t... 5 Apr 2010 13:53

Vlookup
COL of codes in A (full List of codes of about 2,000) COL of codes in B (selection of COL A codes of about 850) IF COL B code matches COLUMN A code, then true, else false ... 5 Apr 2010 16:08

Form and protect sheet
Hi - I have a worksheet and colleagues prefer to input data (including new data) by using the 'Data - Form'. However, if I protect the sheet (Tools - Protection - Protect Sheet), then the option to create a new record or delete an old one is grayed out in the form. Is there a way round this? I am using Excel 20... 5 Apr 2010 17:16

sum multiple columns with SUMIF or SUMPRODUCT
Thank you! I checked for text in the cells and found that was the issue. I appreciate your help. "T. Valko" wrote: they all return "#Value" 3rd try =SUMPRODUT((A1:A3="x")*(B1:B3+C1:C3+D1:D3)) Try #3 should work although it can also be written like this: =SUMPRODUCT((A1:A3="x")*B1:D3) ... 5 Apr 2010 11:38