Hi, I am using the Excel Solver to optimize my production-quantity. Now I have a problem with 2 products X & Y which are produced on the same machine: The sum...

I am trying to create a complex formula and not sure how to do it. Hoping that someone here can help. I have 2 spreadsheets, one's called "Angler of the...

What is the best way to apply conditional formatting to a large number of rows where each row is distinct from each other. Example: A1:H1 should contain the...

The month order as a column heading is in the correct order except that Sep is at the very end rather than after Aug. I'm new at working with pivot tables...

Using Excel 2003, I'm having an issue in creating a Pivot table that exceeds 65K rows. Starting data set is: - 504 rows - 78 columns, comprised of: - 6...

Hi everyone, In Excel, how would I go about linking one cell to another cell in a different workbook? I understand I can type = then point it to the cell in...

I need to calculate a range of cells from smallest to largest example formula will be in column E5:E50 I WANT THE SMALLEST TO LARGEST FROM column D5:D50...

Start Time End Time TimeTaken ActualTime Break Start Break End Total Break 14:33:49 14:34:12 00:00:23 X 14:33:51 14:33:54 0:00:03 14:36:07 ...

Ok.. here's the problem.. I'm re-creating a seniority list for my company.. I need a column to show an employee's 'seniority number'.. (ex, the employee...

Hi, - with the skill of Don Guillet (Excel MVP - thank you!!) I have nearly finished a ‘to-do’ list to help organise my life as an infant school teacher....

How can I set a date format for any cell and user has to use that format otherwise user is not allowed to enter any date.

Ok.. here's the problem.. I'm re-creating a seniority list for my company.. I need a column to show an employee's 'seniority number'.. (ex, the employee...

-- Randy

I have a large set of data (20,000 rows and about 100 coulmns). I wish to select about 5 columns for a pivot "rows" and about 60 columns to place in pivot...

I have used a macro to gererate fixtures for a league but it doesn't calculate properly. All teams should play each other once, (ie 10 teams - 90 matches). I...

This workbook comes up every time I open XL - then I have to create a new workbook. How can I stop this workbook from opening automatically? I am using...

I have a sheet that already has conditonal format where every 3rd row is highlighted green (the cond. format formula is =MOD(ROW(),3)=1 ). Now I want to add...

I have placed a Combo Box onto my spreadsheet. How do I create a hard-coded list of all the markets (one of the fields / columns in my underlying Pivot...

I have (with the help of some of the very talented Excel MVP’s) nearly finished a to do list spread sheet! http://www.box.net/shared/ejzn141dux The...

Hi, I'm experiancing really sluggish behaviour every time I carry out a function when working with Excel 2003. I'm having to wait 30 sec's or more and it's...