|
|
Sorting by Group of Cells by
-random-
I doubt this can be done, but it sure would be handy.
Column is grouped by conceptual blocks, (note, there is not second column of
unique data)...
|
|
4 |
147 |
|
|
MAX & MAXA returning 0 value by
-Rocket
I am trying to simply get the highest value in a column.
I have tried both MAX & MAXA functions, as well as ensured the values are
formatted as a number...
|
March 19th, 2007 05:31 PM
by -Rocket
|
6 |
109 |
|
|
using worksheet references in formulas by
-sb
I'm referencing data from one worksheet in a formula:
=SUM(IF('1'!F5:'1'!F16 = 6,IF('1'!G5:'1'!G16 ="YES", 1,0),0))
I'd like to reuse this formula for...
|
July 27th, 2006 09:26 PM
by -sb
|
2 |
163 |
|
|
File name equal cell contents by
-tinka
Is it possible to make an Excel (2003) template (or a macro in the template)
to save a file with a specific cell-contents as file name? For example...
( 1 2)
|
|
14 |
420 |
|
|
Pasting to Protected Cells in Xl2000 by
-VMill
I am trying to prevent users from making changes to certain cells in XL2000.
I have the cells 'Locked' and both the Sheet and the Workbook are Protected...
|
|
3 |
113 |
|
|
number of rows with cells by
..::CyrusD::..
I want to know if it is possible to put in one formulates I number of the
tie row to the value of a cell
thank
|
November 24th, 2006 05:14 PM
by tim m
|
1 |
138 |
|
|
|
February 7th, 2010 09:31 PM
by ..[_2_]
|
0 |
149 |
|
|
how can you link images to cells? by
.: usman :.
hi there,
im using excel as part of coursework for my A-Level ICT, and i need to
somehow link images into the program. I have a list of names which i...
|
|
2 |
232 |
|
|
Setting up Invoices by
.:RoKsTaR:.[_2_]
Here's what I need to do:
Invoice and average of 50 different customers each month for one or more of
the dozen services I offer.
I figure I need a database...
|
|
4 |
258 |
|
|
|
|
1 |
114 |
|
|
|
|
9 |
166 |
|
|
|
May 11th, 2010 12:13 PM
by Mike H
|
1 |
322 |
|
|
|
|
2 |
121 |
|
|
How to lock a file (wholly or partly) by
0-0 Wai Wai ^-^
How to lock a file (wholly or partly)
Hi.
1)
I would like to lock my file.
Thus if someone opens my file, it needs password to access it.
Do you know how I...
|
November 27th, 2005 09:17 PM
by Tonto
|
1 |
136 |
|
|
|
September 8th, 2005 02:00 PM
by Mike
|
1 |
303 |
|
|
|
December 23rd, 2005 10:04 PM
by paul
|
2 |
107 |
|
|
Reference cell formats + content by
0-0 Wai Wai ^-^
Hi.
How can I tell one cell to follow content AND/OR formating of another cell?
Here's an example:
A1:
=I am the bbest!/b (b.../b means bold...
|
|
4 |
110 |
|
|
Change/Reverse the table by
0-0 Wai Wai ^-^
Hi.
There's the table:
A1 A2
B1 B2
C1 C2
1)
I would like to make the table upside-down, ie:
C1 C2
B1 B2
|
December 7th, 2005 03:30 PM
by Ian
|
5 |
107 |
|
|
Strange Calculation Error in Excel by
0-0 Wai Wai ^-^
Hi.
I have a table of numbers, and I do some simple Math based on this data.
Eg:
4.1 4.1 3.97 4.03
4.15 4.15 4.1 4.1
For the formula "=A4-B4", the answer...
( 1 2)
|
|
15 |
265 |
|
|
|
|
2 |
131 |