|
|
Shared Workbook opens as read-only by
Miranda
I have a shared workbook which seems to work fine sometimes (multiple users
can edit at the same time) but other times when I try to open it I get a
message...
|
March 30th, 2010 08:12 PM
by Miranda
|
0 |
420 |
|
|
Tracking RANK by
Bob
Every month I create a spreadsheet that ranks customers by past due amounts
owed that I share with our sales team. What's important is the relational
change...
|
March 30th, 2010 08:08 PM
by JLatham
|
2 |
247 |
|
|
Brugervenlig udfyldning by
flemmingdane
I en faktura ønsker jeg at man ved at taste ENTER automatisk kan gå til
forudbestemte celler der skal indtastes. Eksempel hvis adresssefeltet starter
i...
|
|
0 |
118 |
|
|
Is Error Help on a formula by
Jim
Hello,
I need a little help changing this formula:
=IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10)))
to return a blank if the referencing cell is blank. I...
|
March 30th, 2010 07:47 PM
by JLatham
|
5 |
123 |
|
|
AutoFill Option Button by
Loris
I appreciate your response, but I guess I didn't make myself clear. It is
not Auto Complete that is at issue. It is Auto Fill. When dragging the Auto
fill...
|
|
1 |
143 |
|
|
|
March 30th, 2010 07:34 PM
by Mike H
|
3 |
153 |
|
|
Convert vertical data to horizontal data by
Kiley
I have a listing of 6 performance ratings for each employee. The ratings
appear vertically. How do I convert the ratings data to a single row for
each...
|
March 30th, 2010 07:33 PM
by Kiley
|
8 |
205 |
|
|
Location of Grand Total in Pivot table by
Rosemary
Is the a way to show the Grand total next to the selected Field as opposed to
the right now column ( I am using a file that had data results by Date)?
|
|
1 |
200 |
|
|
Simple IF statement by
Bob[_53_]
In simple terms i am trying to say if the value in box E2 is "CASH02"
or the cell is empty then put "ACTIVE" otherwise put "CLOSED"
I have tried many...
|
|
4 |
94 |
|
|
Excel 2010 Beta Professional by
Leonard Cravath
Will not "save" or "Save As". Response is that "Excel has encountered a problem and must close". Returns to working spread sheet . Further efforts to save...
|
|
0 |
175 |
|
|
AutoComplete feature - Turn off by
JMay
In certain files I work with the annoying feature above reacts and enters a
string of text as soon as I enter the first letter. I notice the ON/OFF
button...
|
March 30th, 2010 07:06 PM
by JMay
|
0 |
119 |
|
|
|
March 30th, 2010 06:10 PM
by Eduardo
|
2 |
123 |
|
|
Averaging all values for each hour??? by
Jennifer
I have been trying for hours to try to figure this out. I have data that has
been recorded every few minutes over a two week period for temperature, say...
( 1 2)
|
March 30th, 2010 06:05 PM
by Bob I
|
12 |
279 |
|
|
can't open Excel file by
shari
After a worksheet disappeared, I tried to re-open. Explorer lists the file,
but when I open it, the command section at the top is inaccessible and the...
|
March 30th, 2010 05:51 PM
by shari
|
0 |
113 |
|
|
function Making one row out of many by
dersonnenach
I have 72 rows, each one is about 10 cells long. Does someone know a function
to make one row out of this?
Thanks a lot!
Melanie
|
|
2 |
142 |
|
|
|
|
0 |
109 |
|
|
excel macro/funcion insert row if by
dersonnenach
I need to insert rows in my excel spreadsheet under certain conditions.
Specifically, I should always have six lines with certain data in it. But
sometimes I...
|
March 30th, 2010 05:31 PM
by Reg
|
1 |
139 |
|
|
|
|
2 |
105 |
|
|
Multiple Languages by
Infexus Bytez
I'm working on a community template, and was going to save the document in
multiple languages. Is there an easy way to convert the text, without having
to...
|
|
1 |
127 |
|
|
DropDown aand Auto Fill by
Maanu
Hi,
I have column with DropDown List.. The items are
a. Documentation
b. Logic
c. Optimization
Is there a option to automatically fill a cell, if I type...
|
|
5 |
143 |