|
|
Calc with time by
Maria Soto
I need sum cells with time. I have this case:
A1=15:17 and A2=23:04
When I sum A1+A2 the result is incorrect:
=Sum(A1:A2) = 14:21 Why????
Thank you.
|
October 9th, 2003 12:53 AM
by Andi
|
4 |
122 |
|
|
Function to find value in cell by
Ken Wright
If you just want the last value in the column, regardless of whether or not you have any blanks in
your data, then the following will both do...
|
|
9 |
308 |
|
|
HLOOKUP by
Steved
Hello from Steved
=HLOOKUP(A1:B1,C4:AT125,3)
would like it to be
=HLOOKUP(A1:A2,C4:AT125,3)
The above formula works fine on A1
I want to change B1 in the...
|
October 9th, 2003 01:26 AM
by Max
|
4 |
197 |
|
|
|
|
1 |
364 |
|
|
Date stamping entries by
Dino
I hope that someone can help me with this:
I am setting up a 20,000 item spreadsheet, where my staff
will put an "X" in an adjacent column when they are...
|
|
2 |
139 |
|
|
Discount table by
Max
Nothing wrong as far as your VLOOKUP set-up is concerned.
Take it that the VLOOKUP cells are formatted as percentages.
Kanga...
|
|
1 |
208 |
|
|
unlocked cells in a protected worksheet by
mscpa
I have my excel worksheet protected except for the cells
that will be used for data entry. In an older version of
excel, when I pressed the tab or enter key,...
|
|
1 |
404 |
|
|
Data in A1:A5 to A6:F6? by
Clipper-44
Is there a quick way to fill a row, say A6:J6 with data
from a column, say A1:A10?
I have a worksheet with eventdata in columns, event-1 in
cells A1:A35,...
|
|
2 |
112 |
|
|
workbook references by
Marie
I have a folder containing various Excel files that are
linked to one another. I recently had to move the entire
folder to another location. In the...
|
|
4 |
127 |
|
|
basic question!!! by
sylvain
Hello,
I have a simple question, I tried to look in help but no
result.
Here is my problem I want to take a value from another
worksheet.
display cell's...
|
|
5 |
158 |
|
|
Re HLOOKUP by
Steved
Hello from Steved the below formula came fom Max
Please I am learning my way round so please bear with me
=HLOOKUP(A1,C4:AT125,A2,FALSE)it is returning...
|
October 9th, 2003 06:37 AM
by Max
|
5 |
98 |
|
|
|
October 9th, 2003 08:13 AM
by EVS
|
0 |
101 |
|
|
|
October 9th, 2003 09:43 AM
by Koo
|
0 |
601 |
|
|
Protecting Macros (Excel2000) by
Ed Beattie
Help!!! I'm trying to incorporate a password protected
worksheet function into a macro with little or no success.
I've have quite easily incorporated a...
|
|
1 |
177 |
|
|
Extracting information by
Jill Berry
I have data from Alpha 4 (DOS Database). I have already
exported the data and the following is an example of what
I would like to do:
We currently bill our...
|
|
1 |
100 |
|
|
|
|
1 |
78 |
|
|
process a list through a cell by
Tim
I am trying to reproduce / simpilify what the solver and
goal seak tools do.
I have one cell (input) that I want to recieve values from
a list. There is...
|
|
1 |
216 |
|
|
conditional formatting by
Jack
Hi,
In conditional formatting is there a way to format cells
to "Blue" if the cell is a value and "Black" if the cell
is a formula.
If it is not possible, any...
|
October 9th, 2003 01:35 PM
by Paul
|
1 |
111 |
|
|
Passing Variables into a Link by
Alec
I have written VB code that, on the press of a pushbutton,
creates new sheets from a template, it also puts the sheet
name in cell A1 of the new sheet.
I also...
|
October 9th, 2003 02:12 PM
by Alec
|
4 |
265 |
|
|
|
October 9th, 2003 03:12 PM
by Amelia
|
3 |
99 |