Find the 10% value
Thu, 4 Mar 2010 20:41:46 -0000
Hi,
I have a monthly report that contains data for a varying amount (each month)
of users across several column.
For each column I need to use conditional formatting to highlight the worst
10% for each measure.
Currently I'm doing this manually by sorting the column ascending, then if
there are 15000 ...
|
Excel Automation Question
Thu, 4 Mar 2010 10:49:05 -0800
I am trying to open an Excel spreadsheet in VB 2008 using automation. Once
the spreadsheet is opened, I want to modify it, and force a recalculation.
The auto calc function is disabled.
I can opene the spreadsheet and modify it successfully. When I try to get it
to recalculate, all the cells with formulas ...
|
Formula with to Criteria
Thu, 4 Mar 2010 09:45:01 -0800
Hi,
I have a row of numbers in Coloumn B ranging from 1 to 200 what I want is a
formula in cell A1 that will do the folowing.
Look at my range in coloumn b for example B1:B200 and countif the number is
the coloumn is over 25 >25 and below 100 <100.
I can do countif functions but don't know who to do the abo ...
|
I feel your pain. Looks like it has to do with the numbers.
Thu, 04 Mar 2010 09:37:41 -0800
I'm running into the same problems as you. To me, it appears that Microsoft has possibly made a major gaffe on developing Excel 2007. I tried many of the same things you did like:
1. Converting the file to a .xlsx file and closing and reopening it.
2. Changing to manual calculation.
3. Copying the data to a n ...
|
Balancing
Thu, 4 Mar 2010 22:44:07 +0530
Hi
I have a excel data range from that I have to create a daily balance
register
Say' in row 1 op value, row2 to row10 contains transcation details, I want a
new row to be inserted in the end of the row (end of the each date) and the
value of row1 & row2 to row10
to be combined in the inserted row
an ...
|
excel for analysis
Thu, 4 Mar 2010 06:46:52 -0800 (PST)
Hi,
Please how may i use excel for analysis as in SPSS package.Otherwise
which package works
best for statistical analysis. ...
|
excel for analysis
Thu, 4 Mar 2010 06:46:43 -0800 (PST)
Hi,
Please how may i use excel for analysis as in SPSS package.Otherwise
which package works
best for statistical analysis. ...
|
|
|
VBA problem
Thu, 4 Mar 2010 09:36:06 -0000
I would like a macro to run only if the active cell is in a specific column.
I have tried:
If ActiveCell.Column="X" Then
run macro etc
End If
But this does not work.
I think the syntax above is incorrect. Would appreciate help in correcting
this.
JP
...
|
Indirect function call?
Wed, 03 Mar 2010 18:00:32 -0800
Suppose I have an array of sines with arguments such as
=SIN(j*B3) where j is aninteger or another number.
That is, the array has arguments conisting of a product of numbers
multiplied by contents of a cell, for example.
Is there a way to have a cell containing "SIN" or the like to provide
the argument ...
|
Macro to find spaces?
Wed, 3 Mar 2010 16:06:23 -0800 (PST)
Hello.
Hello!
My spreadsheet error-checking macro didn't pass the test today. Here's
the situation:
There are several cells in the range where I tell the user to leave
them blank if they do not apply. So for the formulas for these, I can
just use If(d2=""...).
But if the user hits the space bar, then ...
|
