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