I have the following two lists: LIST 1 Product Date Quantity A 11 Nov 2007 130 B 13 Nov 2007 150 C 15 Nov 2007 200 C 17 Nov 2007 250 B 19 Nov 2007 240

What is a good formula for tracking vested options under the following schedule: after 1st year, 1/4th vest. 1/48 vest monthly thereafter for full vesting...

I have a worksheet with circular reference and I setup the calculation to manual and with Interation fo 100. The worksheet was working fine, then I add some...

This is part of a formula I am trying to make work. Any help would be greatly appreciated. $B$102=53000, $B$103=7000, and $B$104=6000, $D$96=12 What I would...

I have 3 columns of dates ( MM/DD/YYYY) from 2000 to say 2010. How do you display ( filter) only the year 2000 ?? 2007 ?? etc. Thanks, Clint E.

I'm having an issue trying to total large time values. I've made sure to set my cell format to :mm:ss for both figures and total, but anytime I sum these...

Can anyone help me with this... I think I need to do conditional formatting? I have a number of rows of data in 3 columns A, B & C For each row I want to...

I have posted this before but I couldn't get the correct result. I have two drop down lists (columns I & J). One has numeric codes for fee bearing work,...

VBA help to add tickmark to range that has data only trying this code 'Format the column to Add Ticks Dim X As Variant If...

calculate minimum number of undercarpet heaters to keep in stock.

I am running into trouble calculating large hour totals into even larger hour totals. 1Name Total Hours Name 1 171:06:28 Name 2 140:37:48 Name 3 87:00:26 Name...

How can i disable or enable a drop list using a Excel functions (Not a VBA macro). Here I'm talking about I've been using Combo Box from From control as...

Hello All: I have column headings for the month's of the year and row headings are item #'s. In the row/column field I have forcasted qty's that will be...

Is there any way to pivot on a shared workbook while it is being shared? Or is the only way to pivot to be the exclusive user? Excel 2003. Thank you

I frequently use pivot tables to analyze cost variances from one month to the next. Is there a way to change the total column to show the difference between...

Hi In a worksheets property dialogue, there is a possibility to add customized properties and assign them values. How can I use these properties in a...

I have 2 workbooks. The first contains data for events that I run and the data for each event is on a seperate worksheet. The second workbook is a summary of...

=MIN(IF(P3:Q30,P3:R3) I am using CTRL,SHFT and ENTER to enter this formula as an array but it won't except it MS Office 97 " If I copy an old formula as...

Hi all, I have a combined text file made up from 7 individual files. However now I have 7 headers in my combined file. How do I create a new text file...