I have  a list of codes in F$19:F$1500.
I was attempting to use the following code to assign a number to each
unique value in the list and repeat the previously assigned number if
it is duplicated.

Any one able to assist with formulae like the above which for me is quite
advanced yet I am sure it is intermediate.
I would like to attach a file to give as n example of what I am trying to
do. (How do I do this on the newsgroup?)

I have a yearly accounting of expenses. The type expense in top row and the
months in the 1st column. I have a worksheet for each month and also one
called "Summary" which I have formulas in which identify which cell I want to
populate in the summary sheet. It would be nice to ...

I need a formula on one worksheet (such as  =$A$22+50) whereas the 22 comes
from an entry in a cell.
I tried with “INDIRECT”, but did not succeed... Any other ideas?

We have an XLUSRGAL.xls file that contains custom charts which has worked
fine for years. However on SP3 when you use a user defined custom chart ,
excel just crashes, and then try's to recover the file. The issue does not
occur on SP2. I have tried copying various files (XL8GAL) ...

There are 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D, E, F, G, H, I, J, K and L
In B3 down is: B, A, H, C, F, I, K, J, H, C and J.
The result which I want is to list or select the data which is NOT exist in

When I try to save an Excel spreadsheet to My
Document/[Activities]/2008-05-05 I recieve an error that some characters are
not allowed.  [ and ] are both valid characters for a file name.
What can I do to get Excel to accept these characters at the SaveAs dialog

Can any one can help me to solve this I don’t know why I get error #value
next to Reference in the Index Function argument window
=INDEX((A1:C6,A8:C11),2,2,2) even I got the error the result comes  back ok  
but with one area selected there is no problem

Some years ago I created an Excel file to store telephone numbers from my
mobile phone. This went missing and I lost all the numbers but thought my
file would be my saviour - but alas- even though I know I wouldn't have
changed my Password To Open I cannot get the file to open at ...

I have created an excel database that links to word to be used for a mail merge. For the most part it works fine, however i have check boxes in my letter for word and I was wondering how I could include data from excel that links to the check boxes?
Thanks,
David

I've got two Excel sheets containing data about employees.  Sheet A
is
a complete list, and Sheet B is a shorter list with only employees
who

I created a userform to accept information from the user.
My problem is ,eg  i would like the TxtAmount.value to display the amount in
Currency when i enter the number. The same for the percentage control.
I am new to this.

I have a spreadsheet that has offers on parts from multiple
clients.    The spreadsheet is 12,000 lines long.  I am looking to
select on a range (of offers) and the highest offer gets put into a
BEST OFFER column on the same row.

Have a string of codes similar to below.
Any way to separate (LEFT, or RIGHT) all text to the right of the
first number in the cell?
(Some codes have more/less characters before and after zero, so using

Below please find a "Cut Stack Order" subroutine I wrote for Microsoft
Word. This script generates numbers in Cut Stack Order sequence and
saves the numbers into a TXT file. I import this TXT File into an
Excel row next to my data and use that as my Sort field: