|
|
fomula required by
Keith[_22_]
I'm attempting to get a formula to reflect as a %.
A1: $4 (a stock high)
A2: $2 (a stock low)
A3: $3 (current price)
How can I get a...
|
|
6 |
130 |
|
|
|
January 7th, 2010 07:13 AM
by enna49
|
2 |
116 |
|
|
|
|
4 |
171 |
|
|
Multiple Users - Different PC/Locations by
teelee
I have a excel spreadsheet that 3 people need to work on, I email it out
after I edit it then so on. I'm on my pc and the other 2 people are on their
pc's...
|
|
2 |
118 |
|
|
Indirect function by
JD
A couple weeks ago I posted on here with two tables that I wanted related. I
did get one response but I can't seem to make it work.
Here was my original...
|
|
2 |
158 |
|
|
Locking comments by
MarkVW
Hello.
Is there a way to lock comments in a column.
i would like the column to appear red with the word locked in each row. and
only see the comment with a...
|
January 7th, 2010 03:40 AM
by MarkVW
|
0 |
115 |
|
|
Decision tree by
Mickeddie
I used to have a decision tree add-in, but since upgrading to the latest
Microsoft version, I cannot find it. Nor can I find out how to re-load it.
How can...
|
|
2 |
112 |
|
|
Calculating a date by
Hugo[_4_]
I've discovered a pile of mortuary cards and I'm trying to put them in an
Excel file. But often is only the date of death and the age mentioned,
without the...
|
|
3 |
97 |
|
|
text fragment comparison by
ChrisM
i must count similar pathways, but to a limited extent:
eg: column:
RIOASSUDroit Ã* partir de 2010
RIOASSUDroit avant 2010
RIOASSUDroit avant...
|
|
2 |
87 |
|
|
Traspose Column data into Row by
Zia
Hi,
I want to transpose column data in to row. I have seen many posts (using
INDEX or OFFSET functions) but all these solution assume a fixed block of
data...
|
|
3 |
118 |
|
|
|
January 7th, 2010 12:24 AM
by Max
|
3 |
97 |
|
|
Dynamic chart by
Flemming
Hi
Maybe you can help me out. I have a classic sales table...
Jan Feb Mar etc.
David 20 21 23
James 18 22 17
Sam 21 25 20
Jane ...
|
January 7th, 2010 12:19 AM
by Eva
|
1 |
71 |
|
|
Match values in more than one column by
Richhall[_2_]
Hi
I have three columns of data and wish to highlight the matches or
change the format if there are any duplicates.
i.e
A B ...
|
January 7th, 2010 12:13 AM
by Max
|
6 |
117 |
|
|
subtracting 28 days from a date by
Billrpc
I know this is simple, but I am at a loss...A1 is a given date...A2 needs to
be 28 days prior. Formula please?
--
Bill
RPC
|
|
3 |
78 |
|
|
|
|
2 |
112 |
|
|
random integer with sum constraint by
Karin[_3_]
Hi
I want to generate two random integers that fall within a certain range
("min" to "max", e.g. 0 to 10) AND that sum to equal no more than a given
value...
|
|
8 |
86 |
|
|
|
January 6th, 2010 10:07 PM
by bigisle
|
9 |
64 |
|
|
Variance Analysis and Excel by
Mur
Cell A1 is 10 and input
Cell B1 is 5 another input
Cell C2 is 5 a formula A1 - B1
I want to only look at variances that are greater than 25% of cell A1 and i...
|
|
1 |
93 |
|
|
|
|
6 |
96 |
|
|
Fill color by
Tomg
When I open a spread sheet, the menu bar shows the fill color as yellow.
When I change it to another color or "no fill" and use it, everything is
fine. ...
|
|
2 |
104 |