If 2 conditions exist in a range of cells
Tue, 19 Aug 2008 21:50:07 -0500
=IF(AND('SWF08'!$A$2:$A$1905=FallBookings!$C3,'SWF08'!$G$2:$G$1905=FallBookings!$F3),"OK","Review
Finish Date")
Excel 2003
I have tried the above formula but no luck even as an array. I want to check
the date entered in cell F3 against 2 conditions on another sheet, SWF08.
The 2 conditions in sheet FallBoo ...
|
Combine two worksheets into one summary worksheet
Tue, 19 Aug 2008 11:15:01 -0700
I want to combine two worksheets into one summary worksheet so I can create a
pivot table to chart dates along x-axis and numbers y-axis, legends being
Open and Closed. My worksheet 1 consists of 2007 data and my second
worksheet consists of 2008 data. They have same labels. ...
|
VLOOKUP Question for New User
Tue, 19 Aug 2008 10:10:22 -0700
I have a list of 800 items I must look up from one worksheet and enter the
price on another worksheet. The worksheets are not similar. Using a common
item number that appears in both worksheets, will VLOOKUP do this for me? In
other words copy a price from one worksheet to the proper column in another
wor ...
|
x = 1
Tue, 19 Aug 2008 16:23:53 +0100
Hi all, I am fairly new to excel. I want to put x's into a column and make
each x = 1 then do a count further down. Then in the next column put an x to
= 2 then do another count and so on in more columns increasing the value of
x. I cannot seem to get anything to work. I've tried to put into a cell x=1
and s ...
|
Sumproduct
Tue, 19 Aug 2008 17:27:23 +0800
I have a worksheet with data in the region C1:Z10.
I want to sum over everything in the region C1:Z10 which meets certain
criteria for columns A & B (more specifically: equal to 1).
Also, I don't want to create an extra column of sums for the region. All I
want is a formula.
I know I can use
SumProduct(( ...
|
How to remove an external data source
Tue, 19 Aug 2008 00:24:01 -0700
Hi,
Please guide me how to remove an external data source link in pivot as i
need to make a new link (I am using excel 2007)
Thanks
Dinesh ...
|
sorting
Mon, 18 Aug 2008 21:38:02 -0700
can i sort my data automatically without click on "sort" icon ...
|
|
|
formulas to match row in a table from given values
Mon, 18 Aug 2008 19:09:01 -0700
I have a table where column A is the size of the material, e.g.
0.5",1",1.5"..., columb B is the thickness, e.g. 11,14,16, of the material,
column C is the weight of the material per size and thickness.
Each size (column A) has 3 or more thicknesses (column B). So I'm trying to
write a formula that will find ...
|
List of worksheets
Mon, 18 Aug 2008 15:51:01 -0700
In a workbook with multiple worksheets, each with a unique name, how would I
create a list of of the worksheets? In addition, I'd like to be able to show
totals from each sheet beside the sheet's name. ...
|
how to use vba in excel
Mon, 18 Aug 2008 12:56:16 -0700
I would like to work with an example sample to enter vba int excel ...
|
