I have a master sheet and three more sheet (opening stock,receipts &
closing stock) and within these 3 sheets there is product code ,
description price and the week numbers(i.e from wk 12 to wk 52) which
have quantities. I want to put a function in master sheet that will

I wish to query two ranges of cells. the cells are on two separate worksheets
in the same workbook, but do not know how to specify more than one range in
an IF function. i need the formula to look at both ranges for a particular
value

Let me start with a diagram....
A            B          C             D          E
    Aug-06        Sep-06    Oct-06
Sales    300        400    500

it doesn't appear to be a simple text to columns function. here's what i want
to do:
i have cell that contains :02110610 and I want to reduce it to 010. is there
a formula, or the like, that will strip out the the first four characters

Is it possible to hide specific cells in Excel without hiding an entire
column or row?

Hey Group:
I need an Excel template that will calculate Retail Gross Profit in
percentages
when I enter my cost of goods and sale price of the product.

I have two columns of data which seperately may have duplicates but when
combined are unique numbers.  
example:
Row Col. A   Col. B                          Col. Z

I have a column of 7 cells which may or may not contain comments. Such as
A1: Comment 1
A2: Comment 2
A3:

I know it's simple, but I don't know how to write it.  G3 contains a number.  
If G3 starts with a 3 then it's to yield "ZMO" in H3.  If it's anything else,
H3 is to be blank.
Connie

I noticed that my table got reformatted on posting .. here is a revise
model to explain the spreadsheet structure (I have also attached a smal
.xls file to make things clear.
____A__   __B__  __C__  __D__ __E__

There is a cell that when I select it the formula inside appears a
follows:
{=Sheet1!$B$14:$G$14}
when I go to edit the formula it then looks like this:

I created a pivot table from a data sheet.  I am grouping on a field and I
see the detail for each group except the last group on the sheet.  All the
detail is blank.

Hello to you guys. I want to know if u guys can help me solve it.. this
isnt going to be easy guys.. but if u guys know a formula.. please help
me
A             B                     C                    D

I have a spreaadsheet which contains two columns of
different item numbers.  I would like to count the number
of occurences (rows) which statisfy two conditions at a
time..ie countif((b2:b200,"xx") and (c2:c200, "yy")).  

using Excel xp
I have a worksheet with names in one column and address in another column etc.
I want to be able to sort the worksheet so that I can have the names in
descending order but also have the other columns re-aranged as well ie each