|
function to change cell position and allows dragging
I want to enter a formula that will reference a particular cell, and then
allow me to drag the formula down so it references every third cell.
So, if my data is:
A
1 XOM
2 WFT
3 SLB
4 HD
5 LOW
6 BAC
7 GE
8 MSFT
(Imagine the list is much longer) and I would like to write a formula that
allows me to create a smaller list composed of every third entry. So the
firs...
|
3 |
19.09.2006 21:07:19 |
|
|
formulas
To you pros out there this may sound stupid. If taxes are 8.160% what
formula would I use to get the exact amount. Not sure where to put the
decimal point.
Thanks...
|
5 |
19.09.2006 21:03:34 |
|
|
sorting protected sheets
I have a worksheet that has a column of locked cells but all the rest are
unlocked. I want all the locked cells protected to keep multiple users from
messing up formulas. Is there a way to sort this sheet after it is
protected? I am having to unprotect the sheet everytime I want to resort the
data. thanks!...
|
1 |
19.09.2006 20:31:01 |
|
|
How do I sort data?
I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types....
|
3 |
19.09.2006 19:47:05 |
|
|
Working night and day..... Timesheet
In Out In Out The total time I
get Overtime
15:00 18:30 19:20 02:00 -13,83 0,00
I'm using this Formula:
=IF((((D13-C13)+(F13-E13))*24)>24;8;((D13-C13)+(F13-E13))*24). Why doesn't
this work? I get negative hours in the total worked hours and no overtime...
My computer doesn't understand the new comming day...
Th...
|
6 |
19.09.2006 19:36:02 |
|
|
How do i add a column of values based on another column in excel
I am doing up a minor budget scheme and I am a little stuck on this one.
I have 2 columns. First column is an amount and the second column has
different they type of amount of the first column.
eg:
Cell A1 = 700
Cell A2 = 200
Cell A3 = 150
Cell B1 = "Amount 1"
Cell B2 = "Amount 2"
Cell B3 = "Amount 1"
What I am looking for is a way to add up the values of Column A by the type
...
|
3 |
19.09.2006 19:29:02 |
|
|
Sumif referring to range names formulas not updating
I have several sheets rolling into a summary sheet. The data is by location
and data type. Using SUMIF referring to range names to get the numbers in
the right place. My formulas are not updating automatically though automatic
calculation is selected in Options.
In order to update the formulae, must go through each cell and F2 [ENTER].
I tried F9 and all the variations of F9 - does ...
|
2 |
19.09.2006 19:14:01 |
|
|
Excel formula
I am looking for the formula to enter in Excel to populate a cell with the
text description that corresponds to the selected numeric value selected in a
separate cell.
Thanks....
|
2 |
19.09.2006 19:03:02 |
|
|
Macro within a function?
Is it possible to put a macro inside a formula? For example, can I make the
true value fo an IF function run a macro? If so, how? I can't find it in the
HELP!...
|
2 |
19.09.2006 18:57:39 |
|
|
HOW CAN I SERIALIZE SHEETS IN EXCEL
I am trying to serialize a purchase order form in excel automatically so the
number each time I print it will advance by increments of 1...
|
2 |
19.09.2006 18:31:02 |
|
|
Excel 2003 SP2
when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install...
|
4 |
19.09.2006 17:48:35 |
|
|
Worksheet Link
I built the following formula as instructed in the Help.
=DSUM(BUD2006.XLS!ACTUAL,23,$A$9:$B12)
When I close the BUD2006 file, the formula changes to the following:
=DSUM('D:\work\BUD2006.XLS'!ACTUAL,23,$A$9:$B12)
The formula appears to produce a value, up to this point.
When I copy this new formula to other rows, both the copies and the original
generate a #VALUE! error.
...
|
2 |
19.09.2006 17:09:02 |
|
|
Looking for a way to summarize data?
I have payroll data reports emailed to me every week from our time and
attendance system (Kronos) in excel format. The data is not in a database
format ie: there are blank columns and rows.
I'm looking for a way to summarize the data. There are columns and row
labels, but I don't think I can use a pivot table because the report is not
in database format. I'm looking for suggestions....
|
1 |
19.09.2006 17:05:02 |
|
|
Virus error opening all files
I just installed Excel 2003. It will not open any files. Error states that
my virus scanner has detected a problem. Anyone experienced this situation?
I have Excel 2000 on other machines and have no problem....
|
1 |
19.09.2006 17:04:01 |
|
|
Calculating values from multiplesheets with multiple criteria
I'm sure this is simple nut I have no idea!
(Apologies for incorrect terminoligies)
*Background*
My workbook two worksheets of data.
I want to sum up the values of a range of cells, within a coloum, from both
of these worksheets into a new sheet and the values are based on more than
one criteria.
The info i wanted sumed is in $ format, the criteria in both worksheets are
the same an...
|
20 |
19.09.2006 16:38:02 |
|
|
MATCH?
I have 10 columns/1 row that have different numbers. I want the 11th column
to match for a specific number if found. Here's an example with expected
result
1 2 3 4 X
a c x e 1
t a e k 0
x b i l 1
X=result
Can someone help me with the formula? Thanks!
...
|
2 |
19.09.2006 16:29:02 |
|
|
Referencing a specific number to more general values in a table.
Hello, I'd really like to know the best way of doing this. I'll try to be as
specific as possible.
I have a series of ten cells, in each one a value can be entered. They are
all medical test results for patients. Each number that can be entered may
be low, normal or high for that particular test. I have 10 seperate tables
for each of the ten cells. In the tables all the possible clin...
|
1 |
19.09.2006 16:11:02 |
|
|
code help please
i am trying to create a simple macro whereby i add in a new person to a
holiday chart which involves adding in some formula lines and so on, but how
do i make sure my macros start copy pasting at the next available line ?...
|
3 |
19.09.2006 15:40:02 |
|
|
is it possible to make certain cells required based on criteria
I am trying to lock and unlock certain cells based on data input into a cell.
Is this possible?
Example: If user types "New" into Cell A1, then lock Cells A2 and A3, and
put cursor into Cell A2 ready for next input.
If user types "Existing" into Cell A1, then unlock Cells A2
and A3, but lock Cells A4 and A5. Then put cursor into Cell A4 ready for next
input.
Thanks...
|
1 |
19.09.2006 15:26:02 |
|
|
Conditional formula
I have a series of data in a two row and need to make a conditional lookup.
The problem is, that a conditional formula is restricted to 7 arguments.
The problem:
I have two rows. In the upper row is a target value for each month and in
the lower the realized value is entered. In a column i need: 1. the latest
entered realized value 2. the target value corresponding to the latest
enter...
|
5 |
19.09.2006 14:55:34 |
|
|
date/time calculation needed
I'm looking for a simple formula to add 140 hours from a entered data/time.
Example: In D6 a date/time is entered. In E6 140 hours is added giving the
results in a new date/time format.
This is probably simple but having problems making it work. Also, how would
these cells be formatted?
Thxs in advance...
|
3 |
19.09.2006 14:54:40 |
|
|
If statement based on currency format
I have a spreadsheet that has a column (column B) of numbers. Some of the
numbers are formatted in Euro currency and some are formatted in USD currency.
I would like to put a formula in column C to automatically calculate the
currency conversion of the Euro to USD.
If cell B1 currency = Euro, then cell C1*1.45, else cell B1
Is there any way to do this?...
|
5 |
19.09.2006 14:40:02 |
|
|
DES Encryption functionality
I am after a function or module that I can use or import into an Excel
spreadsheet to support DES encrypt/decrypt calculations?
Also, I aslo need to support XOR as well!
Thanks
...
|
3 |
19.09.2006 14:33:02 |
|
|
Excel adds significant digits, resulting in errors in calculations
I have data from an 8th grade science lab - before and after measurements of
mass. We are plotting a histogram of the differences in mass for a set of
data. However, when I plot the histogram, the results do not match the data,
which is significant to 2 decimal places. Excel says that the result when
you subtract 21.45 from 21.43 is NOT -0.02, but is -0.199999999999996. This
is CRAZY...
|
7 |
19.09.2006 14:27:02 |
|
|
Offset Question
I have the following OFFSET formula in a named range
=OFFSET('Summary Data'!$D$2,0,0,LASTROW-30)
I want to modify it as follows
'Summary Data'!$D$2 ->
'Summary Data'!$D$ & lastrow - 30
If LASTROW - 30 >=2, LASTROW-30, 2
I'll need other similar things for the rows up or down, etc. I'll get to
those as I need them.
Thanks
...
|
2 |
19.09.2006 13:49:37 |