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 >>



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 ...

Delete Range of cells and move left based on Cell value     Wed, 10 Mar 2010 08:42:56 -0800 (PST)
Hi..I am trying to delete a range of cells in a column and move them left based on whether or not a certain cell = 0. Any help would be great, thanks, Bill ...

Count Tick Marks from Code given by Jacob Skaria     Wed, 10 Mar 2010 08:32:09 -0800
I got this code from Jacob and now I need to know how to tally the columns and give a percentage of how many "x" marks were made. I am using Excel 2007, and no absolutely nothing about code, except maybe how to paste. Here is the code: Another workaround with fonts. Single click on any range to check/uncheck. ...

VBA Question: Formulas and Range variables     Wed, 10 Mar 2010 09:25:12 -0600
I've got a good background in Visual Basic, but am new to VBA for Excel.My question is, if I have 2 ranges of data, how do I assigne a formula to a third range? Here is a simplifed example of what I'm trying to do. A B C -------------- 12 | 23 | formula using A1 & B1 values 21 | 24 | same formu ...

Subtracting/Adding dd:hh:mm:ss     Wed, 10 Mar 2010 06:24:01 -0800
I am receiving data from several counters on field generators. The time is in dd:hh:mm:ss. I am needing to calculate the run time on the equipment from one day to the next and then sum the total time run for the week. I have created a custom format for dd:hh:mm:ss for each reading but the subtraction (for ca ...

PIVOT TABLE - Show Dates in months     Wed, 10 Mar 2010 06:09:03 -0800
Hi, I've got a list of items all with associated dates - I want to create a pivot table that will count the number of items for each calendar month - how can I change the display on the pivot to reflect the month? Dave ...

Transpose large data from columns to rows     Tue, 9 Mar 2010 23:30:28 -0800 (PST)
Hello thanks for the help if possible. I have 2 columns. Column A contains names of employees column B contains the trainings the employees attended. Each employee has different number of trainings (I got this data sorted by simple pivot table) A B Employee X ...

XL Sheet Display     Wed, 10 Mar 2010 16:45:29 +1000
Hi, I am using Excel 2003. For some sheets I do not want the Row & Column Headers showing, so in Tools > Options > View then in the "Window options" I uncheck the box "Row & Column headers". By doing this I can set each sheet individually. Some have the headers showing others not. What I want t ...


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