Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



Averageif?     Thu, 11 Mar 2010 15:35:34 -0800
1 -20 1.6 -20 2.4 pass 3 35 1.5 14 2.7 7 How do I average the numbers in column A if the numbers in column B are greater than 0? There is some text in column B. ...

Dropdown list     Thu, 11 Mar 2010 12:38:14 -0800 (PST)
Using XL 2003, i have a workbook that has hundreds of cells to enter data in. i want the user to be able to select from a dropdown list. The data that would be in the list would look something like this.. 1 15 minutes 2 23 minutes 3 33 minutes 4 44 minutes etc, etc. What i would like to do is to have t ...

Show data depending on value     Thu, 11 Mar 2010 11:02:54 -0800 (PST)
I want to automatically populate the "Rates" from another worksheet. I tried the formula =IF(ROW(G50)<=COUNTIF('Working Data'!K:K,F50),INDEX('Working Data'! L:L,SMALL(IF('Working Data'!$K$6:$K$207=F50,ROW($A$6:$A $207)),ROW(G50))),"") but, the return value was blank. The value should have been .1465 I have ...

Excel 2010 Slicer Connection / Pivot Table Problem     Thu, 11 Mar 2010 09:53:08 -0800 (PST)
Working in Excel 2010 beta. I have two pivot tables created from different SSAS cubes. I have PowerPivot add in installed, but not using it for this project. The two pivot tables both share several similar dimensions. When I try to connect a given slicer to both pivot tables, the 2nd pivot table is not availabl ...

add numbers in same cell with Auto Sum     Thu, 11 Mar 2010 09:21:01 -0800
I am using XP 2003 Excel and have a spreadsheet with a large column of cells that have multiple numbers in each cell and the numbers are separated by a slash or divide line, ie: '170/13/3. These #'s are actually 170+13+3. Is there a way to do an Auto Sum on this column without changing the slash lines to ...

Showing Cell Outline     Thu, 11 Mar 2010 15:10:39 -0000
Can anyone explain to a dummy how to keep the grid lines of a worksheet visible after making the background coloured? I have been to Advanced Properties and set 'show grid', but it disappears when I add a colour. Many thanks in advance for any help you can give. ...

Formula to extract first listed item     Thu, 11 Mar 2010 03:34:04 -0800 (PST)
Hi all If I have in Column A a list of countries such as: Australia USA/Australia USA/UK/Germany USA I want in Column B a list of just the first listed country. I have a solution which seems pretty clunky and am wondering how to improve on it. My formula looks like this: =IF(A1="", "", IF(ISERROR( ...

Using english and non-English Excel commands simultaneously in a non-English installation     Thu, 11 Mar 2010 02:29:37 -0800 (PST)
Hi community, I like this forum very much - I got many valuable insights from it. In the past I had an English Excel installation at the office available, recently my employer moved to the German version and deinstalled the english one. Now, when i use a english command like =VLOOKUP(A1,'Sheet 2'! A1:H200,8,FA ...

conditional formatting & formula     Wed, 10 Mar 2010 19:41:44 -0000
Hello I'm working on a spreadsheet and would like to highlight the highest value across. i.e. Name 1 2 3 4 5 6 7 Mary 1% 2% 2% 25% 45% 15% 10% These are the student's probabilities to achieve grades 1 t ...

Count Tick Marks from Code given by Jacob Skaria     Wed, 10 Mar 2010 11:19:46 -0800
Dave, For whatever reason (code maybe?) all it returns me is "FALSE" in the cell where I type those formulas. It does not seem to be acknowledging those "e"s or "r"s. Dave Peterson wrote: =countif(a:a,"e")will count the number of cells with e=countif(a:a,"r")will 10-Mar-10 =countif(a:a,"e") will co ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us