|
What is wrong with this formula?
I have a spreadsheet with multiple worksheets. I need one sheet called
Customer Lookup to pull data from another sheet called Liability Policy
Expiration, which has many columns of data. There are 26 columns I need to
pull data from bases on a customer number.
The customer number is in column B. When that number is entered into the
lookup sheet I need to pull the following columns: ...
|
7 |
27.09.2006 01:00:49 |
|
|
sumproduct of two categories
I have a sumproduct to count items within a given date range:
=SUMPRODUCT(--(((TDL!P2:P700<=AE4)*TDL!P2:P700)>=AC4))
but I need narrow this even further to count only items that match "Gadget"
in another range of entries.
.....and (S&D!H2:H700="Gadget")
I keep getting errors (#N/A)....
|
2 |
27.09.2006 00:52:01 |
|
|
and function
I'm trying to compare 2 worksheets into a third using this basic formula...
=IF('Latest Fosia'!G3='DVE open'!F4:F151, "On Both", "On Fosias" ). I need to
check in the reverse so =IF('DVE open'!F117='Latest Fosia'!G3:G500, "On
Both", "On DVE"). how can I combine these 2 into one formula?...
|
2 |
26.09.2006 23:28:42 |
|
|
3 level sort, last special order
Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific list,
which is not alphabetical anymore, but it does not seen to work and puts it
in alpha order anyway. Are "special" sort orders only good for the first
level of sort?
--
David...
|
5 |
26.09.2006 23:26:01 |
|
|
SEARCH A NAME ON COL A & SUM THE VALUES ON COL B
ON COLUMN A I HAVE A NAME ON SEVERAL ROWS. ON COL B I HAVE DIFFERENT VALUES
FOR THAT SPECIFIC NAME. I HAVE TO ADD THIS VALUES ON COL B FOR THAT SPECIFC
NAME....
|
4 |
26.09.2006 23:12:51 |
|
|
[VBA] How to highlight rows in PivotTable
Hi,
I have PivotTable in Excel 2003. In "Row Fields" there is dimension called
[DepartmentEmployeeProject] which consists of [Department], [Employee] and
[Project] levels. In "Page Field" there is dimension called [ProjectTypes]
which consists of one [Types] level. The "Page Field" [ProjectTypes] has two
items: "closed" and "opened". When all the items in "Page Field" have been
chosen I wo...
|
1 |
26.09.2006 22:57:29 |
|
|
what does the +1 do in =INT(6*A2)+1?
i need to know the purpose of the +1....
|
4 |
26.09.2006 22:31:02 |
|
|
[VBA] Hiding rows in PivotTable
Hi,
I have PivotTable in Excel 2003. In "Row Fields" there is dimension called
[DepartmentEmployee] which consists of [Department] and [Employee] levels.
To hide rows I used the following code:
Sub Hide()
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
Set pt = ActiveSheet.PivotTables(1)
Application.ScreenUpdating = False
Applicat...
|
2 |
26.09.2006 22:18:30 |
|
|
excel worksheets
how can i put totals of 1 page to the next page for another report. from page
1 to page 2 of a workbook so that i don't have to redo the second report.
sort of like hyperlinks but the info in the cell goes to the second page of a
workbook...
|
3 |
26.09.2006 21:39:02 |
|
|
Relative vs Absolute referencing of Workbooks
I normally do not post across groups, but this one impacts each of the 3
groups that this is posted to.
There are many times when I would formulas and charts to refer to only the
workbook that it resides in, not the workbook that it was originally created
in. That is cause I have several workbooks with the same structure, but the
data is specific to the area it covers, which in this case, ...
|
5 |
26.09.2006 21:34:09 |
|
|
Auto advance after scanning
Can someone please tell me how to set up my form to auto advance cells after
I scan a piece of equipment. The scan, hit down key is getting old. Thank you
in advance for your help....
|
1 |
26.09.2006 21:32:01 |
|
|
getpivottable function?
can you add two cells in a getpivottable function?...
|
2 |
26.09.2006 21:27:43 |
|
|
vlookup for maximum value
Hi,
i have a table with two columns: in column A are five different companies
and in column B are the numbers of outgoing invoices. i would like to find -
maybe by using vlookup function - the highest outgoing invoice nzmber at one
selected company. are there some kind of combination of formulas to solve
this problem?
thx in advance!...
|
5 |
26.09.2006 21:16:01 |
|
|
displaying a formula's answer into a separate cell
Hello, I'm having a problem with combining strings, basically I will
have two cells with names that will be combined so I did the
=a1 & " " & a2
assuming that a1 is first name and a2 is second name,
then what I am trying to do is copy the full name over to a different
spreadsheet
but when I copy that cell over, it just copies the formula... :(
So the only thing I can think of is ...
|
7 |
26.09.2006 21:00:01 |
|
|
Excel Dates w/ No Slashes
Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes?
For example...If I want to type into a cell the date for Sept 10th 2006 and
i type 091006 is there a way for it to format in the cell with the slashes.
If I format the cell with a date format (and slashes) and I type into the
cell 091006, I get back 02/28/49...
|
4 |
26.09.2006 20:25:36 |
|
|
Can I get multiple trend data on one curve?
I need to find points in a curve where the data slope changes. I have been
doing this manually and was wondering if there is a trend function I can use
to find these points automatically?
Here is a Very simple example of my data. (usually have 200 points)
1 0
2 10
3 20
4 28
5 36
6 41
7 46
8 51
9 54
10 57
11 60
12 62
13 64
14 65
15 66
16 67
If you graph this, you can plai...
|
1 |
26.09.2006 20:25:02 |
|
|
Average Error
I got some help yesterday with an average issue.
I'm attempting to average specific cells not in a range while ignoring div/o
errors.
This is what I'm using:
=AVERAGE(if(ISERROR(AC4,AC40,AC85,AC94,AC121,AC139,AC175,AC202,AC220,AC247,AC274),"",(AC4,AC40,AC85,AC94,AC121,AC139,AC175,AC202,AC220,AC247,AC274))(AC4,AC40,AC85,AC94,AC121,AC139,AC175,AC202,AC220,AC247,AC274))
I can't make it work. Wha...
|
3 |
26.09.2006 19:23:20 |
|
|
Time Sheet list linkage
I am in the process of developing a Time & Materials daily time sheet, with
variables being name, position, hours (straight & Overtime) and rates. I
would somehow like to link specific rates (straight & overtime) to specific
positions, with positions in a drop down list.
Is there any way to do that?
...
|
3 |
26.09.2006 19:21:28 |
|
|
Calculating Networkdays and Business Hours
I have been trying to come up with a formula that will calculate the time
difference between two given cells. To get the correct amount of time it
takes employee's to complete the task, I must factor in networkdays and
business hours (8am-5pm). Unfortunately I have been unsuccessful in my
attempts to calculate both factors. Is there such a formula? Any help is
greatly appreciated!
...
|
4 |
26.09.2006 19:02:01 |
|
|
Error with SUMIF but not SUM(IF)
Can anyone tell me why I get an error (#VALUE) with
=SUMIF('C:\[doc.xls]sheet'!$M$4:$M$1000,"page",'C:\[doc.xls]sheet'!$G$4:$G$1000)
and when I use this I get correct answer :
{=SUM(IF('C:\[doc.xls]sheet'!$M$4:$M$1000="page",'C:\[doc.xls]sheet'!$G$4:$G$1000))}
Is SUMIF not able to work on multiple workbooks?...
|
4 |
26.09.2006 19:00:33 |
|
|
Pulling Data in Excel
I want the information that is associated with a number to be placed in cells
next to that number by pulling the information from any worksheet that may be
existing in the workbook in excel (but that info is only being inputted
once). Any help?...
|
4 |
26.09.2006 18:45:02 |
|
|
Formula/Function to insert month by name in a cell
Hi, I would like to write a formula that would automatically write the
current month, by name, in a cell. thanks in advance. Mike
...
|
3 |
26.09.2006 18:44:19 |
|
|
Naming Cell in diffetn worksheet
I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet,
So every week i enter the scores on each sheet, then using a namecell, i
copy to the master sheet....
What i need to do, since i have many teams and many week to enter.
On each sheet, i need to enter and name 26 cell diiferently.
EX: A1=T1WK1 - A2=T1WK2 AND SO ON!
As you see the naming is almost the same but...
|
11 |
26.09.2006 18:36:22 |
|
|
Displaying Document Properties in Excel
This should be pretty straight forward, but I can't find it for the life of
me. I have a document with a bunch of properties, and I want these properties
to be displayed in certain cells on my spreadsheet. What formula can I use to
retrieve the document property??
Thanks...
|
4 |
26.09.2006 18:30:02 |
|
|
Quote marks in Formulas passed from VB Script in Excel
Interesting one. I have a calculation subroutine that goes row by row to see
if there are any matching records that have three same fields of information
in them. If they do then it tries to replace the value of the last record
with a formula that will calcuate a difference between two times.
Unfortunately I don't know how to pass the " marks in the
TEXT(CELL1-CELL2,"h:mm") formula. Or I...
|
3 |
26.09.2006 18:29:02 |