I have been using an IF OR formula to calculate prices based on different
texts in column 4.  Depending on the text the mark up is then calcualated in
one of 3 different ways.  My problem is now that when I have tried to add a
new text into the formula I get a message saying ...

What should be the syntax if I have a list of first letters of my entries
(looking something like
A
A

I'm hoping someone can help me since I have hit a snag in trying to modify a
formula.
This formula is working now (in J3) to sum starting with the value in row 11
and then adding every 7th row: =SUMPRODUCT((J11:J221)*(MOD(ROW(11:221),7)=4))

I have a spreadsheet which has 2 columns. Col A contains names and col b
contains either Open or Closed. I want to count the number of closed for
each name. E.g
Amy    Open

how to get slope with a forced intercept of zero in excel

I want to have a Control Box (Text Box) that will allow me to type a value
and then it filters a colum for the exact value I typed in the Box.  For
Example if I type "2546" it goes to Colume X and filters it with "2546"
Is this Possible?

I'm trying to use the SUBSTITUTE function to replace a double quote (") with
a regular text.  The function works well with other special characters but
not the double quote.

How to extract numbers from a alphanumeric cell.
Eg: If a cell contains fdsfa24655, my result should be 24655
If a cell contains fd123fds, my result should be 123.

What I would like to do is have a drop-down list that lists all the
divisions/departments of a company, and when I select a particular
division/department from the drop-down list, I would like the box
underneath or anywhere on the worksheet to automatically update with

I have a list of ID numbers and I want to see the duplicates and delete all
the other records.
I have tried the Advanced Filter and it does not filter the list...
I know that it can't be too difficult to filter out.

I want to combine two address books made in excel that have duplicate
information.
Once I combine them together I don't have to have to look threw 1000+ names
to find duplicates. Is there a function that will do that for me?

After already having my data entered the font and size i was using got
smaller and would like know how to get it back to the original?

have recently learnt abount this and its brill. I have a spreadsheet at work
were if the value of a product is below £50 i have to treat it different to
over £50. So i have set up conditional formatting to turn red if its below.
My question is once the cell turns red is their ...

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?
Thanks,
Steve

I am looking for help on a formula, so far the only way i can figure it out
is to make a table and then do a vlookup.
The general gist of the formula is as follows - you make a set payment into
a bank account, you receive interest giving a higher total, the following