|
Peculiar Result with SUM
I have 7 rows of data in one column, the SUM of which adds up to Zero,
as expected, except it doesn't. In the SUM cell formatting to 13
decimal place shows as 0000etc13. I've even retyped the 7 rows of data
(max of 2 decimal places) and my result is still the same. I even
pasted-special values ROUND after that and same result
How can that be?...
|
5 |
12/30/2008 4:35:06 PM |
|
|
Generate sequential numbers with define format.
I need to generate sequential numbers with the following format; EI-P-0001.
I have tried the TEXT function but apparently ("E) causes some #value error.
If I use other letters its fine, but the "EI-P-0000" returns an error. Help! ...
|
4 |
12/30/2008 4:27:23 PM |
|
|
unprotect specfic cells in worksheet
...
|
4 |
12/30/2008 4:27:18 PM |
|
|
AmortInt function
Hello,
Is there an AmortInt function in excel? A financial model i am using has
this function but it doesn't seem to work and I couldn't find the function in
the help section of excel. Is it possible that this is a non-english
function (e.g. specific to an Spanish version of excel)?
Any help would be greatly appreciated.
Thanks,
Tom...
|
4 |
12/30/2008 3:52:17 PM |
|
|
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE
Text Effects - similar type in Word...
|
4 |
12/30/2008 3:04:58 PM |
|
|
Can I use the content of a cell as part of filereference in other
I can't believe there is not an easy way to solve the following, but thusfar,
I've not been able to find it. Your help is much appreciated:
I want to use the value of one cell to determine the filename that is used
as a reference in a different cell:
A1='\\....\[weekxx.xls]'Sheet1'!$C$15
Where xx is the value of Cell A2.
So if A2=41, then the reference is to file week41.xl and A1 will be f...
|
6 |
12/30/2008 2:44:19 PM |
|
|
How do I get all the tabs and pages of the worksheets to appear?
All of my workbooks are missing the tabs and their pages. I went to unhide
tabs and that didn't work. I've done this before and I thought it had
something to do with the view but I can't figure it out. Can anyone help me?...
|
7 |
12/30/2008 2:08:52 PM |
|
|
Change different cell based on conditional statement
I am trying to get a cell to display a message based on the date. I know that
if I was in that particular cell, it could be done easily;
=IF((A6>Sheet2!A14),,Sheet2!A15)
where A6 is a given date, Sheet2!A14 is a 'checking' date which changes and
Sheet2!A15 is the message I want displayed if FALSE.
This is fine, but what I want to do is to get the formula to display my
message in ...
|
5 |
12/30/2008 2:00:05 PM |
|
|
Sum with a Twist Q
How could I add up all values in two ranges where the value in a
separate range equals one of 2 values?
As an example
I wish to add all values in Ranges H10:H22 IF the corresponding value
in J10:J22 is one of 333333 or 444444 or 1111111 or 2222222
+
All values in Ranges H28:H40 IF the corresponding value in J28:J40 is
one of 333333 or 444444 or 1111111 or 2222222 + etc etc
An alterna...
|
3 |
12/30/2008 1:11:22 PM |
|
|
Return to Home Row
Is there an option which would allow me to return to my 'Home Row' when I hit
the Return key? It functions that way when I tab from column to column, but
not when I arrow from column to column.
Thanks!
--
Jeff...
|
5 |
12/30/2008 1:08:10 PM |
|
|
"filtration" of dataset
Hi everyone.
I've got 2 spreadsheets. The first one, named "DATA" consists of 4 columns:
column A: product ID (thousands of records; unique numbers)
column B: name of group where each product belongs to (there are
hundreds of product groups; each group consists of several products)
column C: product description
column D: product price
It's more less like this:
product ID |name of group...
|
4 |
12/30/2008 9:37:46 AM |
|
|
Sum quantities per hour from inconsistent intervals on a 24hr cloc
I need to create a function that will identify and compile data for specific
24 hour periods. (In Excel 2003)
It may be a two step process but if there is some way to get it all done
with one function i am happy to hear it.
Data is in two columns, Reading Time (over a 24hr clock, for every day in a
month) and Raw Readings (which are running totals, not separate quantities).
Readings ar...
|
4 |
12/30/2008 9:18:17 AM |
|
|
checkbook balance
I created a checkbook balance, but would like to add all of the same entries
into another worksheet in the same workgroup. I have tried VLookup, Index
Match, etc and can't seem to make this work. I have several entries for Auto
Payments, same amounts for the entire 12 month periods of 2008, which
function would allow me to tell the 1st worksheet to look up all of the Auto
Payment entri...
|
4 |
12/30/2008 8:48:24 AM |
|
|
Using a formula to select a cell using the row and column values
With a value in cell C2 of 1. Can't I use a formula in cell D1 that says
let D1 equal the contents of cell A(c2). So D1 will equal the value of cell
A1? Or if c2 equaled a value of 4 then D1 would be equal to the value of
cell A4?...
|
9 |
12/30/2008 8:15:02 AM |
|
|
date/time calculation
Can someone please tell me how to add time to a date/time and have the date
change accordingly? That is, I’d like to add 10 hours to a GMT date/time. For
example, if I have the date/time of: 28 Dec. 2008 7:00PM GMT…how do I get it
to 29 Dec 2008 5:00AM to reflect Sydney time?
Many thanks...
|
4 |
12/30/2008 8:05:00 AM |
|
|
adding positive and negative numbers
I am trying to create a formula that will allow me to add both negative and
postive numbers in the same column. It appears that when I use the SUM
function, EXCEL is doing the addition first and then subtracting any negative
from there producing the wrong outcome. Ex: a1 to a10 all have 100 in it.
total would be 1000. When I introduce a -100 anywhere witin a1 to a10, I
recieve 800 instea...
|
4 |
12/30/2008 3:53:01 AM |
|
|
Calculation with EDATE Help Needed!
The formula below is producing an "#N/A" error.
=IF(K5="","",IF(TODAY()>EDATE(H5+45),"Failed to Enroll on Time"))
What I am trying to do is the following:
If a date is posted in cell K5 (which is the enrollment date) than the
second half of the formula should not produce the FLAG "Failed to Enroll on
Time" regardless. If a date is NOT posted in cell K5, than the "Failed to
Enrol...
|
3 |
12/30/2008 1:58:04 AM |
|
|
VLookUP with multiple reference columns
Is there a way to do a Vlookup that refers to more than the first column of
the table. If not, does anyone know an easy way to connvert a table
(multiple rows and multiple columns to a table with only two columns and
multiple rows) so that I can use the vlookup funtion? ...
|
7 |
12/30/2008 1:40:01 AM |
|
|
same time range on different days
If I have data sets as below (up to 1000 on daily basis), how can I set a
formula that returns:
"breakfast" if the time is between 7:00 and 8:30
"lunch" if the time is between 11:30 and 14:00
"dinner" if the time is between 17:00 and 20:00
and
"midnight" if the time is between 23:00 and 1:00
the date is not important and should not be regarded, what is important is
the time period.
...
|
7 |
12/30/2008 1:38:01 AM |
|
|
How do I get rid of a drop down box exported from a worksheet?
I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could
not delete a drop down box....
|
3 |
12/29/2008 11:14:13 PM |
|
|
auto populated price multiplied by quantity?
I have a spreadsheet with a size column, a price column and a quantity
column, along with others that are not relevant to my questions. Currently
when you select the size from a drop down list, the price automatically
populates from a corresponding list and then the price column is totaled.
However, i would also like to take into account the quantity column. So i
guess what I need it to ...
|
4 |
12/29/2008 11:06:04 PM |
|
|
ignore text in formula
i am using the following formula
=J17*H17
the problem is J17 is imported from another file, and that always contains a
number value along with some text value (ex. 5 CS). when the formula is
calcuated, it returns #VALUE!
can the formula be written so that it looks at the number value only and
ignores the text?
thank you,
jat
...
|
12 |
12/29/2008 10:34:55 PM |
|
|
SUMPRODUCT with If condition
=SUMPRODUCT(--(Other!$G$2:$G$10000>=C$4),--(Other!$O$2:$O$10000 =
""),Other!$H$2:$H$10000)
The formula above works fine. However, I need to modify it to do the
following:
If Column J on the "Other" worksheet has a value, I need my match to refer
to column J. However, if column J is blank, I need the match to refer to
column G as it is doing above.
...
|
4 |
12/29/2008 10:19:10 PM |
|
|
Concatenate results of scores and return sum of percentages
I have 3 columns. Rows 2 to 20 can have either "1", "0", or
"" (blank).
ColT ColU ColV
15% 20% 65%
1 1 1
1 1 1
1 1
1 0 1
1 1 1
1 1 1
I need a result in ColW based on the 27 permutations available:
15% 20% 65%
1 1 1 = 100 (15+20+65)
1 1 0 = 35 (15+20 'cos C3 is 0)
1 1 = 100 ((15+20)/(15+20), C4 is not applicable)
1 0 1 = 80 (15+65 'co...
|
5 |
12/29/2008 9:07:10 PM |
|
|
Calculated Field using Summarized Value Pivot Table
I've made a pivot table in an excel 2007 spreadsheet - and for one of the
fields, I've had it do a count of a text field. I want to take that field
and have it be part of a new calculated field I'm creating, but it isn't on
the field list and I don't know how to add it....
|
3 |
12/29/2008 9:04:01 PM |