How do I add a drop down box that will allow a user to pick from a list of
choices.  Also how do I add a radio button that would allow a user to input
an employee name, title, and then pick one of three levels of access (Input,
Reviewer, Approver)  These level of access would be ...

I want to know whether I can use sumproduct within an Autofilter to do the
following.
Column A: Company Name
Columm B: Weight of the Company (based on a scale of 1 to five) on the

I have 30 worksheet where all the employee name, salary number and overtime
have
Out put and result …………..> I want to make a master worksheet where I just
enter (in a cell) one employee salary number and it will display all the

Dana (and other VBA experts),
In the thread "Expanding Formulas", you offered the macro below as a
(great!) starting point.  I made some minor modifications.
The Replace() operation seems to make the appropriate substitution

I use a sumproduct formula which links different files to a single file. The
formula is
=SUMPRODUCT(------($A$2:$A$400="SME-1736"),--($G$2:$G$400="Business
Solutions -

I posted tis before but can't find it or the reply! I need to average a colum
of numbers omiting the zero values I found the formula in help and copied it
to my spreadsheet replacing the range values with mine the formula I used is
=AVERAGE(IF(d5:d32<>0,d5:d32,**)) excel returns ...

I have a spreadsheet with tabs for Jan, Feb, March, & April with totals for
each month and I am trying to figure the growth/loss for the 1st Qtr.  I have
created a new tab titled "1st Qtr Growth" and I need to enter a calculation
to look at the totals for all four months and give ...

I want my students to be able to see their grades online w/o viewing the
entire spreadsheet. My intention is to hide the working spreadsheet, & show
them a sheet with the same column headings (quiz 1, quiz 2, etc.).  The data
cells will populate w/ the data from the underlying ...

I have a worksheet (inherited) that uses Julian dates in one field - I need
to display the same date in another field in conventional date format.  Is
there a formula that will accomplish this?  Thanks for your help!

I am trying to auto fill information from one worksheet to another worksheet
(only select item to this worksheet). Please advice any good solution.

Need a way to create a list that allows multiple selections to show
concantenated information in a cell.  i.e. LIst contains 5 items and you can
select any variation of the list and it will put those items in the cell.

I had posted a question on how to fix a GPA formula with a null value.  This
was the formula given:
=IF(D17="','",Lookup(D17,{"a","a-","b+","b","b-","c+","c","c-","d+","d","d-","f";4,3.7,3.3,3,2.7,2.3,2,1.7,1.3,1,0.7,0})*E27
But the problem is that it is not multiplying in whole ...

[This may be a duplicate post... I tried continuing the original
thread, but it's not showing up so I'm reposting for more help!]
____
I have a table with 3 columns (employee's last name, first name, and

I have been using vlookup for several years now and occasionally run into
this problem.  My visually exact match does not find a match.
I am looking for an exact match in another table.  My formula is
=VLOOKUP(A1,Sheet2!Query_from_Navision,2,FALSE).

I am trying to average out numbers in a column if the number in another
column is a certain number.
1       Y         533
2       N         789