I've a form with a control number in cell G3. Suppose the control number
starting from "PR 00001" and every time I'll print 100 sheets. I want the
form to be printed out in consecutive numbers, such as PR 00001, PR 00002, PR
00003 and so forth. What will the VBA code be so that I ...

i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 / 3 /
17 ) ... how can I convert these cells to sort by the second number value;
the 3 or 4 in the example ... Much Thanks !!

I have two accounts A and B. When I log in user A, I use my excel to do
function RANK, it has a struture: RANK(number; ref ; [order]). But when I
When I log in user B, I use my excel to do function RANK, it has a struture:
RANK(number, ref , [order]).

Thanks to previous posters of this group I've learnt that in order to
have a sum in Sheet1 of the Sheet2 column  that matches some expression
I must use this construct:
=SUM(INDEX(DATA,MATCH(D2,APPS,0)))

Column A contains a list of numbers.  This list will vary in length.  Cell C1
needs a formula to display the last (but not necessary largest/smallest)
figure in this list.
Any help would be appreciated

i have a listing of music and i have several rows that need to be swapped
between the 2 columns. ie. artist and title listing but on some lines the
title is in the artist place and the artist place is in the tittle place is
there an easy way to do the whole excel document queick  ...

I am using the following array-entered formula to retrieve data from another
sheet's column E when the data in columns A and B equal some parameters in my
current sheet:
=INDEX('Meetings List'!$E$1:$E$1000,MATCH(1,('Meetings

Hi, i hope I can explain this correctly in words.
What i'm trying to do is create a report that draws information from a large
table. The report will only be drawing on some of the aspects of the larger
table. I have tried the LOOKUP functions and they are not working in this

Guru's
I have a question which may be a brain buster! "Can I have Excel devide a
resulting value by only the number of cells containing data? Examle, I have
row/cells "H5" - "S5" values being calculted in a =Sum() function in cell

I have added an extra column to a pivot table to analyze the results.  The
pivot table is set up with a page filter for separate users.  Each user can
select their data to review without having to look at the entire data set
which is 240 pages.   I have used if statements so that ...

When I concatenate text from two cells, the texts get joined together. i want
to insert a space between the two text strings. Any ideas?

Hi   Someone Help me  please
IF(L3=M3+(N3=900),N3,"Backorder", IF(l3<>m3+(n3=900,"Future Order No Stock
Available",N3)
I keep getting the message  the formula you typed contains an error, I 've

I have a sheet that lists items and sales for each month for the last 24
months.
Example
Description, Oct04, Nov04,....Aug,06,Sep06

Here's a problem that I've yet to figure out.
I'm trying to determine the number of months, weeks and days between
two dates to determine what the cost of a rented item will be, when the
vendor offers a discount for monthly rates over weekly rates over daily

I have a large worksheet and I'm trying to pull some specific information
out of it, and I'm not getting the numbers I expected- so I think there is
something wrong with my syntax. I'm hoping that someone can help point out
my error. As the actual references are quite long, I've ...