Hello again. I appreciate your help in the past and would appreciate your
assistance here.
Below is a sample file I created in Excel as a *.csv file so you may paste
it into your worksheet and see a sample of what I'm trying to do.

Is there a way to count unique values in a list that is not continuous and
contains merged cells?
I have a list in one column which regroups data (numbers) in several
categories and each value can occur in several categories.  And there are

Instead of using VLOOKUP to bring back a cell value, I want to GO to that
location by double-clicking.  VLINKUP would have the same sorting,
first-column requirements as VLOOKUP, and a "not found" should envoke a NOT
FOUND msgbox.

Create a spreadsheet that would insert the current date into a cell or
expression when opened.
For example the cell would be something like...
                            [The membership roster as of Date()]

I would kike to calculate the average in a column if it meets a criteria in
another column.  I have tried Average(if(.......   this is not working.
I need to know the average probability of sales against the sales executives

I need to create a formula wich contains an if clause and a validaiton (list).
A1= will be "member" or "non member" (will be selcted from a list: ok)
A2= 0.30 is A1="non member" and 1.0 A1="member" (if clause: ok)
A3= amount will be entered (manually)

I'm trying to return multiple results using IF function for the following.
If A1 is greater that 0.01 and less than 2.50 then enter 3.99, but if A1 is
greater than 2.50 and less than 3.50 then enter 4.99.
I can do it for one:

Problem with a VLOOKUP. EX: When "Elmer Fudd" is chosen from the drop down
in a spreadsheet, EF should auto appear in the appropriate colmun. But "AP"
for APPLE PIE shows up. All others work.
Formula is =IF(C2=0," ",(VLOOKUP(C2,$AM$1:$AN$11,2)))

I am using Word 2000.
I have the following formula in cell B1
=IF(A1="Alan",85,IF(A1="Glen",85,IF(A1="Tony",85,IF(A1="Trevor",47,IF(A1="Bob",47,IF(A1="Bobby",47,IF(A1="Andre",47,IF(A1="Clive",47,IF(A1="Claire",47)))))))))
How do I edit the formula to 'combine' Alan, Glen & Tony ...

Is there a funtion I can use to automatically pick up the first business day
of the month based on a given date?
For instance, if today is 5/14/08, I would like a function to pull in the
first business day of the month (5/1/08), based on 5/14/08.

I want to be able to fill out a Excel Sales form and have the totals sent to
a Data File when I print the form out for the customer.

I have 2 tables, column A contains ID, col.B names of employes, col.C
element of pays which it's adjustable. Sometime, same names employees are
retail. Now, I need whis names are retail and how can I paste only same names
on the second sheet,

HOW TO SOLVE "TOO MANY DIFFERENT CELL FORMATS" IN  MICROSOFT OFFICE EXCELL
,WE CANNOT DO ANY INPUT WHEN IT APPEARS.
HOPE YOU CAN HELP US TO SOLVE THE PROBLEM

I received a data worksheet from colleague, I tried to insert columns but
come back with the message that "Excel cannot shift nonblank cells off the
worksheet". I use CTRN-END and found the last cell is IV4036. I tried to
delete columns but still last cell is IV4036 and not able ...

I have created some 15 sheets in an excel 2007 workbook. My problem is that I
went on creating  the sheets , one for each one of my employees, as & when i
needed to, but now searching for them whenever I want a particular employee
sheet is very timeconsuming. Is there anty way I ...