|
|
if-then statements or functions by
Becky
I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into
it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this?...
|
May 14th, 2010 08:21 PM
by Nadine
|
3 |
194 |
|
|
Excel File Size by
Nadine
I have an Excel 2003 workbook that has 22 worksheets. Some have smaller sets
of data and some have over 1000 rows and 80 columns. The workbook does have...
|
May 14th, 2010 08:07 PM
by Nadine
|
9 |
384 |
|
|
|
|
2 |
145 |
|
|
Limit Cell Content by
Bob Zimmerman[_2_]
I would like to know how to limit a cell to only allow entry of the following
number values of 1 decimal point.
My limits are any value =15.0 to =100.0 as...
|
|
4 |
216 |
|
|
|
|
1 |
188 |
|
|
convert 200701 to Jan-07 by
CW
Hi
I have raw data with a date in the format 200701 (as extracted from DB).
Does anyone know how I can conver this to Jan-07?
Thanks
|
|
1 |
138 |
|
|
|
May 14th, 2010 04:49 PM
by Steve
|
4 |
226 |
|
|
extract hyperlink with worksheet by
RRRYBAlex
I have an excel document with a column of hyperlinks. I needed to extract
the text of the hyperlink from that column and did successfully using this...
|
|
0 |
159 |
|
|
|
May 14th, 2010 04:26 PM
by Glyn
|
11 |
453 |
|
|
long printing on a plotter by
Jeff
I have created a schedule for the rest of the year, each cell being a day. I
would like to plot this on our plotter as one really long continuos sheet but...
|
|
1 |
129 |
|
|
formula for visible cells by
jpstormy
Can I copy a worksheet so that the new worksheet looks exactly like the
visible portion of the old worksheet. For example, if I filter and sort, I
only want...
|
|
3 |
132 |
|
|
If iserror help by
Help in nottingham
Hi can someone tell my why this does not work please, have used this combo
many times in the...
|
|
1 |
112 |
|
|
|
|
2 |
107 |
|
|
|
|
5 |
238 |
|
|
Converting Excel to HTML by
Christopher Naveen[_2_]
Hi,
Can you pls. help me How to convert excel to HTML and use pivots in HTML?
Christ
|
|
0 |
139 |
|
|
Convert excel to HTML by
Christopher Naveen[_2_]
Hi,
Can you pls. help How to convert excel to HTML and use pivots in HTML?
Chris
|
|
0 |
139 |
|
|
A list which don not include zero by
Manos
Dear all
I have in column A accounts. In column C i have the values. Let's say that
all values should be zero.
The lines are more than 15.000.
I need to...
|
|
5 |
148 |
|
|
Countif gone wrong by
Isis
Hi,
A B C D E
2000BC DEF DEF DEF 2000BC
ABC 2000BC DEF 2000BC DEF
2000BC 2000BC 2000BC 2000BC 2000BC
ABC 2000BC DEF DEF DEF
This normally works but Im having...
|
May 14th, 2010 09:19 AM
by Mike H
|
2 |
153 |
|
|
Show zero values in specific area by
IanC
I know it is possible to show zero values in a sheet by ticking "zero
values" in options, but I have a situation where zero values should only be
shown in...
|
May 14th, 2010 06:17 AM
by IanC
|
4 |
179 |
|
|
How do I fill nonadjacent cells? by
Momby
I am working on some worksheets to keep track of activities of people in my
group. They complete activities at a different rate of speed, and I want to
show...
|
|
1 |
147 |