Howdy, I am working a homework problem involving non-linear programming for an operations research class. The problem is in three parts. The objective is to...

Is there anyway to select a cell, say B1, then click a selection from a Combo Box and have it populate B1 with that value. I know how to add one Combo Box...

I am trying to Match 2 prices i have 4 columns. I have item number for both prices on 4 columns for example ITEM # retail price ITEM # ...

hello, I have set up the second variable in a VLOOKUP function (the 'table_array') to be from another worksheet in the same workbook. In this case, is there...

Using the following formula to count text values selected from a drop list (menu day). Once selected (menu list), value from "menu day" is added to a...

I need to return the date of when my stock will run out based on the forecast. LMCode Avail 1-Sep-08 15-Sep-08 29-Sep-08 13-Oct-08 27-Oct-08 10-Nov-08...

Please help with formula. I have a table that adds up (totals) a list of "time" in decimal form, and I want to also show this total number in hours and...

I am trying to schedule meetings amongst various volunteers at various locations. In addition these volunteers availability varies on different days of the...

I am trying to update the name of a spreadsheet used in a formula through a cell reference or some tool that replaces the old name with a new name. Hopefully...

I am trying to look up how many times a person is listed on a worksheet. They are listed as lastname, column A and first name, column B. I've been doing a...

Please view my Excel files to better understand what I am talking about... http://www.geocities.com/bushiebrow2000/Fall_2008_Budget_Test_Sample.xls On the...

is there a way to remove the cells that are still in all caps without losing the "proper" column?

I have a monthly report that uses external data. If I import the data into excel in a code column and a data column format, how can I place this data in a...

C2 to IK2 have dates from 1-Aug-08 to 31-Mar-09, B4 to B159 eployee names,I want a formula to count blanks before todays date,Example:if today is 4-Aug-08, I...

This may be a somple question for all of you. I want to use conditional formatting to change fill color that specifically excludes blank cells. The question...

Is there any way to link 2 excel workbooks together in a separate workbook? Every week I export an excel spreadsheet from my business program and store it...

I am new to Excel and know a little, but I cant figure out conditional formatting. Im doing a worksheet for my job and I need a group of cells in a row to...

sheet 2 total1 = sum of sheet1 cell d2 if sheet1 cell b2 = sheet1 cell c2; plus sum of sheet1 cell d3 if sheet1 cell b3 = sheet1 cell...

Hi I don't know if this is possible but can you turn a four digit number e.g 1234 into 12.34 in excel. I have tried many things but nothing seems to...

I have a spread sheet where I show the days of the week in one line Monday thru Sunday B3 thru H3, below that line, I show what the employee is supposed to...