|
|
Deleting Name from Name Box by
Workbook
Is it possible to delete a name(s) from the name box once you have given a
cell or group of cells a specific name? and if so could you tell me how I can
do...
|
|
5 |
60 |
|
|
Greatest Number by
Workbook
In Cell B30, I would like to create an IF Statement that will give me the
greatest number from the Cell Range B2:B29.
( 1 2)
|
|
11 |
95 |
|
|
IF Statement Modifications by
Workbook
Thank you TValko for this statement =IF(Sheet1!B7="H","JER",""). I am
wondering can it be modified to include the 4 following variations so that if
H, K, M,...
|
|
9 |
131 |
|
|
Long Formula by
Workbook
I got some help earlier with an IF Statement which was very helpful from Mike
H. The idea I am going for now is if I have the following ("Wireless...
|
February 19th, 2009 06:18 AM
by T. Valko
|
1 |
133 |
|
|
VLOOKUP by
Workbook
=VLOOKUP(B7,C4:D33,2,0), how can I modify this so that it works when B7 is on
Sheet 1 but C4:D33 are on Sheet 2?
|
February 24th, 2009 04:35 AM
by Workbook
|
4 |
93 |
|
|
Average Symbol by
Workbook
I've been looking for a while for the average/mean symbol which is an "X"
with a line over. To find it I went Insert/Symbols/ various Subsets such as...
|
|
8 |
63 |
|
|
Bullet Chart – Value Y Axis by
Workbook
I got this link http://www.exceluser.com/explore/bullet.htm
From Smartin. It’s a great link about how to create bullet charts. The
question I have is...
|
|
0 |
76 |
|
|
The One Formula by
Workbook
I am using this formula =SUM(C4:C46) however I want to change it so that it
counts any number in its range such as the number 2, 3, 4, 5, etc as a 1,...
|
|
8 |
62 |
|
|
Horizontal bullet graph by
Workbook
Can anyone tell me where I can find instructions for how to create a
horizontal bullet graph that does not involve a paste picture link? I pasted
some great...
|
|
4 |
169 |
|
|
Making Blank Cells by
Workbook
Cell K5 is linked to Cell H5, so that whatever gets entered in Cell H5 it
will appear in Cell K5. However, sometimes H5 does not have any data in it
and...
|
February 4th, 2009 02:25 PM
by Pete_UK
|
4 |
87 |
|
|
Making a Cell Go Blank by
Workbook
I want to modify this formula =IF(Sheet1!N2=241,1,""), so that if N2 is
blank the cell containing this formula will become blank. I have tried
variations...
|
|
6 |
66 |
|
|
Schedule Worksheet by
Workbook
In cell B2 I want to display a time. In cell D2 I want to display a time
that is always 30 minutes later than the time displayed in cell B2. I want
cell E2...
|
December 11th, 2008 02:37 AM
by Pete_UK
|
7 |
120 |
|
|
Value Axis Adjustment by
Workbook
I created a Gnatt Chart with 8 activities. The times on the values axis are
listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09...
|
|
1 |
88 |
|
|
Value Axis Adjustment by
Workbook
Thank you Jarek. I followed your advice and I made the major unit on the
Value (Y) axis scale 0.00347222222222222 to represent 5 min and it worked. I
still...
|
December 14th, 2008 05:54 PM
by Workbook
|
2 |
53 |
|
|
|
|
6 |
56 |
|
|
Drop Down Menu by
Workbook
In cell A2 I want to put a drop down menu/box. In other words I want to be
able to click on a downward arrow in cell A2 and then have the ability to
select...
( 1 2)
|
|
11 |
106 |
|
|
|
|
4 |
86 |
|
|
Linked Cells – If Statement by
Workbook
I am trying to set up an If Statement so that if Cell A2 has an 11 inside of
it, whatever contents are in cell H2 will also appear in cell K2.
This is the...
|
|
2 |
43 |
|
|
Multiplying Empty Cells by
Workbook
In cell N15, I am using this formula M15*24. However sometimes M15 is blank
and when it is I get a message in cell N15 that says #VALUE!. Which throws
off...
|
|
6 |
79 |
|
|
Column Width and Row Height by
Workbook
What size should I make the column width if I want it to be equal to a row
with a row height of 30? How did you figure that out?
|
|
4 |
84 |