Hello, I work with chart and I'd like them updated automatically. My data are in raw and not in column. To explain more, I have new values each month and I...

I've copied a list of English suffixes ("-able", "-ation") etc. into a row of my Excel worksheet. However, because the web-page table I copied them from has...

Hi there whenever i type an enumeration member of the CommandBar into a cell, in a speadsheet, I get #NAME? error. For example, if I type "=msoBarTop", I'd...

I have words in column A and B. I'd like to use conditional formating to highlight just those words in A that also occur in B. The following is close, but...

How do I set a value for a cell based on another cells value using increment. if cell b6 is V then cell b7 is Y based on the following interval: V = 1-10...

I am aware of conditional formatting, but what I want to be able to do is colour multiple cells on a single row based on the 1st cell (being a date)...

Im wondering if the following is at all possible in excel? I want to place a button on the worksheet that on enter (press) it would duplicate and insert a...

when working out a time sheet for example, i want to be able to enter time using a decimal point (.) instead of a colan(:) and be able to add them together...

when working out a time sheet for example, i want to be able to enter time using a decimal point (.) instead of a colan(:) and be able to add them together...

I have a workbook with 5 worksheets. The first work sheet is with "raw" data - date, names, and duty, etc. the other 4 sheets are meant to be for...

Hi. I have two excel files, Excel-1 and Excel-2. I must copy from Excel-1 to Excel-2 only some columns (for example A,B,D and G). After this copy, in the...

Hi. I have two excel files, Excel-1 and Excel-2. I must copy from Excel-1 to Excel-2 only some columns (for example A,B,D and G). After this copy, in the...

Hi,on sheet 2 =if (sheet1!a3=USA) then i want to copy all data next to usa there is 5 colum b3,c3,d3,e3 or entire row on sheet 2. what kind of formula do i...

Hi, in cell E9 have date 1/15/2009 i have the following formula but its return false.please solve this what mistake i...

Hi, how can i take printout with date on footer without using custom footer everyday. is there any formula to update date everyday on my print page.i used...

Hi, i have sheet1 with date a:h and a1:a10 many names i want to sort by name with their data on another sheet . For instance A B ...

no-one? Okay, does anyone know what the 'formula too long' is referring...

I am trying to put a warning message on cell that will pop up if the value of that cell is not the same as the value of another cell. (using data...

I am trying to put a warning message on cell that will pop up if the value of that cell is not the same as the value of another cell. (using data...

I have a very large table of non-unique items shipped; the table contains “item id� and “ship date� columns. I need to find the number of unique...