Can anyone help with this?
I wish to use say 16 numbers in groups of 4 on 5 seperate occasions and not
have the same number apear twice with any other numer used previously?
Is this able to be done or am I expecting too much!

I have a data list on one worksheet.  The list includes: sales rep id,
customer number, customer name, and a number of unique items sold to each
account.  On the second sheet I have a list of my sales reps and their sales
rep id.

I see the "&" in a lot of the answers here. What does that do or mean?

I have the following formula and can not get it to work.  Could someone have
a look please.
Thank you in Advance.
IF(AND(G3="Change"),IF(R3=1,'Data Validation'!C32,IF(R3=2,'Data

Shift    Status        1st Shift         20
2    2             2nd Shift             3
1    2             3rd Shift              3
2    1             Unknown              0

I am using the following formula
=COUNTIF(AU6.0,'I_O Summary'!B$1)
AU6.0 is the name of range.
One of the cells in the spreadsheet (in this case A2) contains the text

I have no idea why my sumproduct formula is not working. I am trying to have
it match 2 seprate valuse a then return the coressponding price from a price
list. the formula is
=SUMPRODUCT((A$1:A$5=E2)*(B$1:B$5=F2),G$2:G$7). See a saple of data below

I need to have an error message occur if the same name is used more than once
in that column. Is there a function or set of functions that I could use to
do that?

Hello Experts,
Customer is delinquent for 10 payments of total $25,850 (Col b2)/each
monthly payment of $2585(Col a2). I extract the customers arrears from data
warehouse which populates From Current billed to 90-120days (column C2 to G2)

Topic: Naming a cell or a range of cells using Insert > Name (Excel 2003)
I can see that you can define a name for a cell or range of cells using
Insert > Name > Define.
I can see that you can define a range using a row label by using Insert >

Does Excel look at every cell in the range while performing calculations?  I
have the following array formula and am wondering if it will slow things down
if I change the 12000s to 65536s.  By changing the number I would not have to
worry about missing any data but then again if ...

I'm trying to reference the page number and number of pages (Page x of y) in
the body of my worksheet - I don't want to do this in a header or footer.
I know this is possible in Word, but ... in Excel?  Howzat done?

I created an Excel worksheet template, but i can't figure out how to insert
it into a new sheet in an already-existing excel workbook.
I need to use this worksheet template monthly and wanted to keep 12 sheets
(a full year) in one workbook, all together.

Is there a way to convert cells with numbers to a CSV file and keep the
formatting??
I have a file with a list of 50+ items that are over 12 digits each . .
.when I save it in as a CSV file it defaults to the Scientific Exponential