|
|
Use DocProps in a change declaration by
chris w
Below is a change declaration I have in a sheet, is it possible to have a
similar change declaration using docProps in another cell? So when the
change is...
|
|
7 |
245 |
|
|
getting a percentage by
Mikewoodmsw
I want to convert a test score to a percentage, however the fraction may
change
e.g. column E displays scores which are out of 14. How do I have...
|
|
3 |
104 |
|
|
VLookup? Or something else by
JICDB
I have a workbook with two tabs(worksheets) on it. The first contains a
copied 6 column database from an external source. In the second worksheet I
want to...
|
|
5 |
112 |
|
|
Time In Decimals by
Superslinky
Can anyone help me do this? D1-B1-C1=8.5 hours for the day. How do I format the cells so that excel knows that 0.5 = 1/2 hour. As I have it right now I get a...
|
|
7 |
203 |
|
|
automatically resorting of new entries by
mircea
i have a sheet with a list
i add a new row and after that i need to automatically re-sort list for
including that row at his alphabetically position
but keep...
|
January 22nd, 2005 01:16 PM
by mircea
|
0 |
87 |
|
|
|
January 22nd, 2005 01:23 PM
by mircea
|
0 |
404 |
|
|
Order ranking. Any suggestions? by
gb_S49
I want to rank / rate the top 20 cells contents in order. ie if i use
(=max(A:A)it will give me the maximum (highest) value. likewise unsing min.
Is there a...
|
|
4 |
101 |
|
|
|
|
2 |
131 |
|
|
Counting days worked by
anonymous person
I am working with a client that has an old accounting system. I can get the
data over to excel, spend some time reformatting it and get a good sheet to
work...
|
|
3 |
229 |
|
|
SUMPRODUCT HELP by
JHL
Hello,
I have the following formula:
=SUMPRODUCT(--(A4='RRBB804 wKLY
011505'!$A$2:$A$1332),--($C$2='RRBB804 wKLY
011505'!$C$2:$C$1332),--('RRBB804...
|
January 23rd, 2005 12:09 AM
by Max
|
3 |
79 |
|
|
Comparison Function by
Michael
Hi Folks - I have the follwoing data:
Col A Col B Col C
45 50 Increase
60 75 Increase
65 ...
|
|
6 |
102 |
|
|
|
|
3 |
113 |
|
|
removing duplicates testing in 2 coloms by
Warzel
I want to remove duplicates from a sheet testing for values in two coloms
in the first colom are hunderds of firstnames
in the second colom hunderds of...
|
January 23rd, 2005 12:39 PM
by Ola
|
3 |
240 |
|
|
=Cell( , ) by
Steven
I cannot get this function to work when using a VLookup.
My formula is =Cell("contents",VLOOKUP(D5,D8:E10,2,0))
where the VLookup returns an A1 or B1 or C1...
|
|
5 |
99 |
|
|
|
|
1 |
220 |
|
|
|
|
12 |
201 |
|
|
|
|
3 |
101 |
|
|
# of Functions per cell by
SUB-ZERO
Hi
Is there any way to change the number of functions allowed in each cell?
I have a spreadsheet and I need it to handle more functions than 7.
10-15...
|
|
3 |
403 |
|
|
Counting for two criteria - brain drain by
seve
Any help would be greatly appreciated.
I need to count the number of dates in column C for each rep (column A)
for each Equipment type (column C).
A B ...
|
January 24th, 2005 12:29 AM
by Ola
|
2 |
95 |
|
|
combining VLOOKUP and IF by
z.entropic
I'm trying to get around the problem of VLOOKUP looking up only the first
found match. Here's and example:
Each row in the first worksheet has a unique value...
|
|
4 |
98 |