|
|
Frequency Table by
Luke McTighe
Ok, Instead of raw data I have a frequency table, and I want to do a
statistical analysis. For example 100 students take a test with 10
questions and their...
|
|
6 |
306 |
|
|
MIN IF by
Chris Ashley
Does anyone know of a formula which will give the minimum value of a
range (ex. A1:A200) excluding the zeros (0).
|
|
7 |
211 |
|
|
can't replace ' by
JulieD
have a worksheet made from imported data - all cells have ' in them (doesn't
show) - need to delete this where the cell is (otherwise) empty - tried find
&...
|
June 17th, 2004 06:02 AM
by Ragdyer
|
1 |
150 |
|
|
|
|
2 |
165 |
|
|
row to column by
mangesh
hi
I have entered no. 1 to 100 from A1 to A100 i.e in a row. Now i want
to convert that same from row to column i.e i want to enter 1 in column
A, 2 in column...
|
June 17th, 2004 05:14 AM
by JulieD
|
1 |
216 |
|
|
Fill the form with 10 rows by
plumstone
I have 3 columns and each columns has 30 cells. Let's say they are in A1:C30. Now I want to copy them to a new table which has only 10 rows.
So I want to copy...
|
|
7 |
170 |
|
|
Converting crosstab data to a list by
Igor, Annet, Linda & Ramon
Hi,
I'm struggeling to find an efficient way of converting data that are stored
in a crosstable format to an excel list. Anyone any solutions?
Thanks in...
|
|
3 |
268 |
|
|
Excel Flowchart Functions? by
TheRobsterUK
Hi,
Does anyone know if it's possible to make the flowchart diagrams in
Excel perform calculations, or are they purely for show?
By this I mean that suppose...
|
|
1 |
355 |
|
|
Dynamicly Hiding Rows or Columns by
too much to view
Does anyone know how to hide a row or column based on
what its content is?
E.G. If I have a sheet with multiple client's
information on it; how do I hide the...
|
June 17th, 2004 04:54 AM
by Et3rnal
|
2 |
453 |
|
|
Erweiterung einer Pivot-Tabelle by
Alexander
Hallo,
ich habe mir eine Pivot-Tabelle erzeugt, in der ich nach dem Ausdruck
noch Felder individuell handschriftlich erfassen möchte. Leider ist es
mir bisher...
|
|
5 |
407 |
|
|
Conditional formatting by
Yinka
Hello,
I am trying to write a conditional format formulae, but I am not getting any joy.
I am using the 'Formula Is' as below
=IF(L2TODAY(),"YES"," "), and...
|
June 17th, 2004 04:44 AM
by Steve
|
4 |
175 |
|
|
Conditional Formatting by
Colin Jarvis
Hi
I Have a Worksheet with several columns that need
conditional formating. When I copy the conditioal
formatting using the format painter it does not...
|
June 17th, 2004 04:37 AM
by Steve
|
4 |
431 |
|
|
Excel 2000, Does not Recompute by
Martin
I use a large (13MByte) Excel 2000 workbook in manual
compute mode, and update through F9.
Problem: Some worksheets do not update even after an F9.
Example: A...
|
June 17th, 2004 04:14 AM
by Martin
|
6 |
213 |
|
|
Average mean radius by
erich
I have a list of coordinates (x,y) and need to determine the average mean radius for these coordinates. I don't know the excel formula to use to do this. Can...
|
|
2 |
185 |
|
|
|
June 17th, 2004 03:03 AM
by Mark
|
1 |
549 |
|
|
Colors by
Hans Knudsen
Hello
I am aware that the following may not be exactly an Excel question, but none the less I hope someone will explain. Why is it that in
Excel's Colors...
|
|
3 |
183 |
|
|
|
June 17th, 2004 02:11 AM
by Florian
|
3 |
538 |
|
|
Formula 'GOTO' by
helpdesk genie
Hello,
I have a user who prior to a reimage of her drive had the ability to place her cursor in a cell in Excel(workbook 1) and if the formula was linked from...
|
|
1 |
192 |
|
|
Preventing refresh link prompt by
MTBer
Is it possible to stop excel asking if links want to be refreshed when
opening a file. I'm having to distribute a file to users who won't have
access to the...
|
|
1 |
232 |
|
|
looping shapes by
bg18461
how would you put this line of code in a for loop for shapes (saying i
have 10 form check boxes), ex:
For i = 1 To 10
Sheets("Sheet1").Shapes("Check Box" &...
|
June 17th, 2004 02:07 AM
by bg18461
|
4 |
164 |