|
|
Condensing data from 3D to 2D by
Garbin
Hi there,
I have a spreadsheet containing data representing a 3 dimensional data
structure in the following form;
Z1 Z2 Z3 Z4 ...
Y1 ...
|
December 5th, 2007 07:29 PM
by Garbin
|
7 |
73 |
|
|
Nested if help by
Curtis
I need to have a formula that looks at cell a1 and produces the following in
cell b1
if a1 4% outcome needs to equal 'None"
if a1 =4% but greater than 3%...
|
|
1 |
53 |
|
|
|
December 5th, 2007 06:01 PM
by Mike C
|
0 |
75 |
|
|
|
December 5th, 2007 05:24 PM
by RagDyeR
|
3 |
69 |
|
|
|
|
14 |
158 |
|
|
help with formula for bolding font by
Roger
I need a calcualtion formula that will result in the bolding of a cell.
If cell A1 is less than half the amount of cell B1 then bold cell B1.
example
A1...
|
December 5th, 2007 05:08 PM
by Roger
|
3 |
70 |
|
|
|
|
1 |
79 |
|
|
Scatter Plot Point Labels by
Dallas
Hello, I would like to make a scatterplot with X and Y parings and a name for
each of the points that it creates. I have set up the data as...
|
|
2 |
107 |
|
|
Convert MM to inch and add to comment by
rpick60
How would I convert a number from MM to Inch and add the results to
the comment?
here is what is the cell
800X400X300
the results can be entered in to a...
|
|
4 |
99 |
|
|
Excel cell Formatting by
Scott
I would like to type numbers including leading zeros while still being able
to do calculations.
Is this possible? What is the format type? When I use text...
|
|
1 |
74 |
|
|
|
December 5th, 2007 03:50 PM
by Stephen
|
2 |
91 |
|
|
|
|
2 |
73 |
|
|
|
December 5th, 2007 02:48 PM
by joel
|
3 |
72 |
|
|
Finding the Location within an Array by
Sh0t2bts
Hi All,
Thanks to this Group I was provided a snipit of code to find out is a
value is within my Array:-
If Not IsError(Application.Match(some_value,...
|
|
2 |
70 |
|
|
|
December 5th, 2007 12:00 PM
by Stephen
|
1 |
81 |
|
|
|
|
1 |
67 |
|
|
|
|
4 |
52 |
|
|
Countif Help by
Curtis
cell c2 = 80%
Column of data is c5:c27
I need to calculate the % of sales greater than the value in cell c2.
thanks
|
|
8 |
84 |
|
|
HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL by
madmhaha
I work on commission. what I sell decides the percentage. I want to know if I
can make a word have a value in excel. if i type the word, will it know the...
|
|
2 |
90 |
|
|
|
|
1 |
93 |