Search results for query: *

Hello, My VLOOKUP formula ( VLOOKUP(B2,key2,4,FALSE)) works only for the first row, i get "#N/A" for all other rows. I should get the same outcome for the first 10 rows (same individual), but I get the right result only for the first row. My identifier column (common column) has been sorted...

Hello, I would like to graph the quantities as bars and the values as lines for each country. Would it be possible to align the countries on the same graph? 2005 2006 2007 2005 2006 2007 tons tons tons million yen million yen million yen U.S. 25,866 27,597 16,064 3,936 3,718 3,048 Russia...

Hello. I have an excel sheet with the following exchange rate data 01 jan 1999 0.1 02 jan 1999 0.5 ... 30 dec 2007 0.2 31 dec 2007 0.3 I could not group the dates and get an average exchange rate per year. The error I get is: Could not group that selection. I formatted my first column...

Hello. When an excel document is printed the headings (column titles) appera on every page. I would like the headings not appear on the last page. How can I do that? Thanks.

Hello. The number of colors one can use in Excel is rather limited. How may I add more colors (like in Word)? Thanks. (yes I know, it is a weird question)

Hello all. I read the thread about never splitting a cell, but I need to do this. This is what I have: col1 col2 col3 col4 AA 5% 3% xxxx BB 7% 2% yyyy I need to display data as: col1 col2 AA xxxx D5%, C3%...

Hello. I would like to point out the cell value under a certain condition: if cell A1 or cell A2 is greater than 0.001, then write the greatest value of A1 and A2 in cell A3. =IF((A1>=0.001) OR (A2>=0.001), MAX(A1,A2),"")?????? Thanks for any hint.

Hello. Is it possible to set a picture as a background in an Excel chart? I searched the forum, but did not find any question related to this subject. Thanks.

Hello all. I have a column with multiple identical records. I would like to create a column with unique records. Example: from col1 to col2 A A A B B c C B Thanks for any hint.

Hello, I am using this formula to fill the blanks in a column based on values on an adjacent column. =IF(C5 <> "",C5,B4) Instead of the values, I get the formula itself (it becomes a string) Would you please tell me why I can't make it behave? Thanks.

Hello all. I would like to compute the % per column. For 1996, first cell, that would be 0/55207= 0%; Last cell of 1996, should be 55207/55207=100% and the total of all cells for 1996 should be 100% (like the last cell). Well I can't get excel do it right. The total are over 100% for all years...

Hi. I have a long series of number that go from january 1998 to december 2007. I would like the x-axis scale to show only jan-98, jan-99, jan-00..... How would I do that? Thanks for any hint. Happy Holidays to all.

Dear all: I have a huge table, and i would like to compute subtotals by year. this is my data. 1989 12 E 1605102025 1220 1 686 1839 0 1989 12 E 1605102025 1220 7 3810 22518 0 1989 12 E 1605104010 5880 30 20000 112504 0 1990 1 E 1605104005 1220 2 17690 196382 0 1990 1 E 1605104005 5800 27 17561...

hello all. I would like to draw a chart with this data month max min Jan-06 1,717 1,567 Feb-06 1,725 1,600 Mar-06 1,725 1,600 Apr-06 1,725 1,600 May-06 1,725 1,600 Jun-06 1,693 1,557 I would like a line to go from minimum to maximum for each month. How can I do that? Thanks in advance.

How do I set the clock or Outlook to chime every hour (if possible)? Thanks

Hello. I would like to split a cell in excel, but i do not find the tool to do like in word (right click the cell, split cell) thanks for any hint.

Hi. I have cells that contain 5+3 instead of 8, for example. (2+3, 5+0, 6+4, 1+7...) What is the best way to change this from text to number? Thanks a lot.

Hi. I have two cells containing dates. in cell A, I have jan-19, and in cell B, I have February 2, 2004. What i would like to get is jan 19-February 2, 2004. the date in cell A is stored as a date, but in cell B as text. I tried to use this formula: =TEXT(B8,"DD MMM YY") &"-"&C8 I got this...

Hi. I am looking for a list of popular sound softwares to use for multimedia applications. Thanks.

hello. i am trying to prevent users from entering duplicate keys. data, validation, allow=custom, formula=COUNTIF($B$14:$B$30,B27)=1 i get a message error when i enter a duplicate key, but when i copy and paste a value that already exists, i do not get a message error and the value is...