|
|
"FILES OF TYPE" by
ROD BRIM
When I open Excel, how can I get the same file to open
each time in "files of type"? "ALL MICROSOFT EXCELL
FILES" is the default and I would like to have...
|
|
1 |
407 |
|
|
"find" and "filter" working weirdly by
weiin t via OfficeKB.com
hi
i hv an excel sheet with more than 60,000 rows of data (abt 8 columns)
i need to find one particular number in all that data. i use ctrl-f to
search for...
|
|
1 |
161 |
|
|
"fixed object" warning message by
Grldtn
I received a warning message while attempting to cut a group of cells from
one sheet to move them to another sheet. "warning - fixed objects will move"
with...
|
|
1 |
257 |
|
|
"Format cells" not working by
v matheson
I have some Excel files in which "Format Cells" is not working. I cannot
bring up the format cell box either through Ctrl-1, the task bar, or
right-clicking...
|
|
1 |
620 |
|
|
"Format" Toolbar by
Bill Martin -- (Remove NOSPAM from address)
Somehow I've broken my format tool bar -- the one where you can click
buttons to force a cell to formats for "$", "%", ",", etc. Everything
works normally...
|
|
4 |
291 |
|
|
|
|
1 |
112 |
|
|
"Go To" without using a macro by
HGood
Hi,
I have a spreadsheet I want others to use. I use high resolution on my
laptop and can see the entire at once. But others use lessor resolutions and
have...
|
March 9th, 2005 09:43 PM
by HGood
|
4 |
126 |
|
|
|
June 14th, 2005 07:34 AM
by Alain79
|
4 |
621 |
|
|
|
|
1 |
89 |
|
|
|
|
3 |
261 |
|
|
"If "Formula by
tojo107
A
1 10
2 17
Want formula for cell b1 that will look at A1, if = 14, then A1*.5 . If
A1 is =15, then it would multiply the first 14*.5, then from 15 on...
|
|
3 |
133 |
|
|
"If in last week" formula by
oatmeal
I have a number of simple two column sheets, one column contains dates.
Basically each sheet is an employee, and the items list the date and
notes for any "one...
|
October 2nd, 2005 03:04 PM
by Cutter
|
6 |
163 |
|
|
"IF" Formula by
Mike R
xl2000—Totaling time worked at each of three stores for a two-week pay
period. What I have is Columns C, D, E, F, G, H, & I, are week one. Columns
M, N, O,...
|
|
3 |
230 |
|
|
"IF" "THEN" Clauses? by
aedcone
I need to figure out a formula for the following senario:
I have three columns; Column "A" has is a list of "license" numbers; Column
B Would be a name...
|
|
1 |
117 |
|
|
"If" and "or" function by
plumstone
If A2=100, or 200 or 300 or 400 or 500 or 820, Then let C2=B2*2
How can I write this formula?
Thanks.
|
|
2 |
128 |
|
|
"IF" Formula Help by
Korgan26
Here is the starting of my formula.
=IF(I12I69,I69.I12)
My problem is that if I69 is empty I want it to return I12.
How can I get it to do...
|
|
2 |
92 |
|
|
"If" Formulas by
Steve
Hi,
I have a spreadsheet that asks "yes" or "no" questions. I want to assign a
value of 1 to all yes reponses and a value of 0 for all no responses. I...
|
May 27th, 2005 02:12 AM
by CLR
|
2 |
106 |
|
|
"IF" statement in a pivot table. by
Elizabeth
I need help in writing a "IF" statement in a pivot table. My data consists
of sale orders numbers that may have several line items - I am trying to do a
count...
|
|
1 |
88 |
|
|
"IF" type formula by
G118
How do you create the formula for the following:
If cell X has a certain character (1,2,3,4,5,6) then I want cell Y to be
populated with a determiend value...
|
|
1 |
102 |
|
|
"Input Sheet" template by
Kev
"Input sheet" that distributes data to other worksheets.
I wish to create an "input template" that based on the
name in a "customer" cell it should place the...
|
October 30th, 2004 02:46 PM
by Kev
|
2 |
363 |