I need to create a new function in VBA (this function is similar to the
vlookup one). This new function will have a range of cells as arguments.
public function myFunction (x as Range) as String
As a formula in one cell, I have

I need help comparing 2 lists in excel. Here is my goal; I have one list with
4500 names and one list with 400 names. I would like to find out which of the
400 names is on the 4500 name list. how do I do it? thanks for your help.

hey people!
i have a question.  the chart is similar to below
Location                      Fuel Type                Volume i
Liters

am trying to separate out the contents of a single cell within Excel
into multiple cells. The text contents within the cell have been input
in a columnar format within the cell. I have tried a number of similar
solutions that I have found on this site but nothing is working. The

Hello all, I am looking for some help with a seemingly simple issue. I want
to have several "groups" containing a list of items, and I want to be able to
change these items. I need to simply count by ones and have each of the items
have thier value incresed by one each time I ...

Hi.  I have been working on this for two hours.  Everytime I change a "sheet"
in my 2 sheet workbook it changes the other page to match it. Can you PLEASE
tell me how to stop that from happening!!!!

Ok, I have read others problems but they haven't helped, so here is m
problem.  I have a 4 main worksheets that pull data from the other 20
worksheets in the Excel Book.  I tried to use the Consatenate functio
but that doesn't work b/c it returns it as text and that doesn't work

OK here goes. I am trying to use a formula from "Excel 2002 Formulas" by
John Walkenbach on pg. 207 for those that have it. The formula is
summing based on text in a cell. =SUMIF(Office,"=Oregon",Amount) Where
Office is the header of Column B, Oregon is a text value in Column B,

Good Morning all,
I am unable to get any colour (color) commands to work in Excel 2003.
Can't colour Tabs, fonts or cells. Never had this problem before any
help appreciated.

How do I add "Comments" to a protected work sheet.  The cells I am trying to
add comments to are not locked but I still can't add commetns.

If I wanted to check that the Surname AND the Firstnames were the same
in each of four columns,
what changes would I make?  Ideally I would wwish that the output was as
below:-

I am new to VBA or formula set up for excel.
I would like for someone to help me write a formula to interest rates that
are computed on a day rate.  Excemple:
Discover Card charges interest on a daily bases.

i want to be able to look for a worksheet that matches a name in a given cell?
Examlpe - the text in cell A6 is master, so i want to look for the sheet
called master so that i can look for specific cells in that sheet. This is so
that i can use multiple sheets for a work training ...

I need help with a formula.  
I have a spread sheet that tracks equipment, replacement cost, lifespan,
replacement date and a second replacement date (xx months after it was
originally replcated)

Here's my problem:
First I need A5 to be divided by 2.
Second Part: Whatever that number may be - if greater than or equal to
500 then $2.24. if less than or equal to 499 then $2.54