|
|
Dynamic List of names? by
RJJ
I have a calendar on a sheet. Under each date of the month, there are various
names that are updated and changed frequently (vacation schedule). The names...
|
May 6th, 2009 08:54 PM
by RJJ
|
2 |
71 |
|
|
Cell Protection by
pen
I need to protect only certain cells in a spreadsheet (mainly those that
contain a formula) so that no one can accidentally delete them. However, I
need all...
|
|
2 |
73 |
|
|
PDF macro button by
Neall
I would like to generate a pdf with my final tally sheet, can someone give me
some insight as to what to do, I am using a free PDF creator.
Thanks in...
|
|
1 |
91 |
|
|
Hide Blank Rows by
TamIam
I don't know how to use macros, (I'm assuming I would need one), but does
anyone know of one I could copy/paste into my spreadsheet that will hide
blank rows...
|
|
3 |
83 |
|
|
sort and blank cells problem by
Mrs T.[_2_]
Hi,
sorry - I have another problem! In my assessment sheet the data looks like
this...
F G H I J ...
|
|
4 |
124 |
|
|
|
|
6 |
108 |
|
|
|
|
0 |
91 |
|
|
unions, intersections or array constants by
Loadmaster
I am trying to make a conditional formatting formula in cell A3 that goes
something like this =$AK$2=JAN, MAR, MAY, JUL, SEP, NOV to format Blue and...
( 1 2 3)
|
|
23 |
226 |
|
|
auto/coditional format by
willemeulen[_3_]
I have the following sheet:
Column A = value inserted by user
Column B = value inserted by user
Column C uses index function using column A + B to return a...
|
|
1 |
79 |
|
|
|
May 6th, 2009 07:21 PM
by pen
|
5 |
69 |
|
|
Subtotals in Excel 2007 by
Nicole
Hi,
I have inserted a cell below a list to count the sum and below that I have
used a formula to get me the subtotal.
When I use the filter it shows me the...
|
May 6th, 2009 07:11 PM
by Nicole
|
0 |
69 |
|
|
Excel - Check Box Functions by
Mags
Is it possible to add a function to a check box so that when it's checked,
the words in an associated cell will automatically strike through?
|
|
2 |
93 |
|
|
how to count charactors in a cell by
sherehind
I am in need to figure out the number of charactors in a given cell. Any
help would be much appreciated.
thanks
Excel user
|
|
1 |
73 |
|
|
in range? by
Bruce Bowler
(I hope the following is clear, but it's probably not)
Is it possible to construct a formula (I know I could do it in a macro,
but for various reasons,...
|
|
4 |
72 |
|
|
|
|
3 |
87 |
|
|
IF Statement by
Sondra
I need to create an IF Statement that covers all the following:
If State=ID or OR field should say "NO CHARGE"
If State=NV multiple field A3 * 6%
If State=CA...
|
|
1 |
84 |
|
|
|
|
1 |
77 |
|
|
Solution for if x = 1 and Y =2 goto C3 by
Neall
Good day, I am hoping someone can help me with this formula
I have a result sheet and on the result sheet I have a section that shows
the part number (c33)...
|
May 6th, 2009 05:28 PM
by Neall
|
2 |
84 |
|
|
|
|
6 |
99 |
|
|
|
May 6th, 2009 04:39 PM
by PJFry
|
6 |
80 |