Anyone know of a way to enter times and dates without hyphens or colons? Would like to 10-key a six-digit date and 10-key a four-digit time without keying...

Hello, I have a worksheet with the following data Column A Column B Column C Start Date End Date Total...

I am trying to figure out how to input data into a master worksheet (sheet 1) and have that data filtered into separate worksheets and keep newest data at...

I have have a spreadsheet - (DOH!) - and I am dealing with a ton of information - broken up into areas. What I would like to do is set it up so that a button...

I have a datafiltered spreadsheet with 2 columns that have a fill color applied - yet when i print the spreadsheet the 2 colored columns STILL print in b&w...

Hello, I looked around without success. In a Pivot table, there are 2 existing fields, linked to a spreadsheet, 'N' and 'N-1' for items split in 2...

I am trying to get a formula that will give me time in tenths. For example; 20:30 to 09:00, should equal 12.5 I want the formula to use every 6 minutes as...

we are trying to set up a spread sheet that contains two columns. One would have current expenditures and the the second would be YTD. We want to have the...

I am using Excel 2007 and I have a chart with measurements associated with gallons (ie. 1" = 10, 2" = 20, 3" = 25). I want to type in a measurement and have...

Very simple but would save me a hell of a lot of copy and pasting. Ive got a spreadsheet that has a list of names in each column. i.e. Col A has Rob in rows...

Hello all, I have constructed this =SUMPRODUCT(--('Sites_A-K'!G:G=A2),--('Sites_A-K'!I:I (date()-60))) in my attempts to count the rows where column...

I have a list with entries like so: 1990CJ000123 1991CJ000124 1992DJ000124 1993CJ000125 1992CJ000124 1992CJ000125 1992CJ000126 1991DJ000137

Have lots of sales data, and would like to have a column display the most recent price for an item. Source data includes many shipments for various items,...

I posted before with a problem which was answered and then tacked this onto it, but I think it's worth starting another thread as it has gone unanswered...

My problem: I have a workbook (wb1) where the formulas reference to another workboook (wb2). Wb2 is placed in another folder. The formulas then comes out like...

we need a reminder function like a task creation from a workshhet, but specifically tied to a cell within a worksheet.

I have a text string as follows LAST NAME, FIRST NAME Smith, John. I need to put the last name in one column and the first name in another column. I can do...

Doing a simple formula Cell A-Cell B and when I change data in cell A or B, the total is not changing automatically. I event started a new excel sheet and it...

I want to convert a number like 12.56 to read Twelve Dollars and 56/100

Suddenly, links to my email are appearing when I click on a cell and it is maddening. I've tried getting rid of them / don't know how they appeared / don't...