General

Excel 2003 Function Help
I need help coming up will a function that will average a range in one column based on if the hours match. Here is my set up. -------A-------B 1.....09:21....12 2.....09:46....24 3.....09:57....17 4.....10:04....22 I need to average column B if column A's hour is the same as the hour in a cell in another... 24 May 2010 16:50

Symbol = Character Code 25BA
Excel2003 ... Is there a way to "Conditional Format" based off of a specific Character Code such as Symbol Character Code 25BA? Thanks ... Kha -- Kha ... 24 May 2010 19:04

Limit Series in Chart Data Table
Can you specify which series are to be shown in a data table? Currently have a total of 8 different series and only want 4 to show up in the data table. ... 24 May 2010 15:44

Copy Data...propagate
Good afternoon, I have a master worksheet ("parent") for which I need to propagate other worksheets ("child") based on individuals. The master worksheet contains seven columns for which I need flow into individual worksheets based on the salesman's name. Any help is greatly appreciated. ... 24 May 2010 16:50

stike through font
Hi Pierre, Sorry Pierre, I never got a notification on this. It's 2007 version. Ray "Pierre" wrote: Hi Ray. What version of excel are you using? "RayNDM83" wrote: Hi, Is there a way to filter by a strike through font? Thanks, Ray ... 24 May 2010 13:29

sum if formula
=SUM(IF('Day 1'!$C$4:$C$37=A22,'Day 1'!$D$4:$M$37))+SUM(IF('Day 2'!$C$4:$C$37=A22,'Day 2'!$D$4:$M$37))+SUM(IF('Day 3'!$C$4:$C$37=A22,'Day 3'!$D$4:$M$37))+SUM(IF('Day 4'!$C$4:$C$37=A22,'Day 4'!$D$4:$M$37))+SUM(IF('Day 5'!$C$4:$C$37=A22,'Day 5'!$D$4:$M$37))+SUM(IF('Day 6'!$C$4:$C$37=A22,'Day 6'!$D$4:$M$37))+SUM... 27 May 2010 17:04

Compare dates in two different ranges
Hi. I have the following data in a worksheet: A B DATE NUMBER 05/15/2010 321 05/16/2010 558 05/17/2010 665 05/18/2010 262 C D DATE NUMBER 06/10/2010 321 06/11/2010 558 06/12/2010 ... 24 May 2010 13:29

Conditional format to change row colour
I've looked at quite a few posts but can't seem to get this to work. I have a spreadsheet with information about delivery dates and within forty eight hours of the delivery date I have to provide information. I need the row colour to change according to the date that is entered in column J, if the current dat... 24 May 2010 13:29

Converting Hours to Decimal
What equation do I use if my time goes past midnight? "CLR" wrote: As long as the timing does not go through midnight.......... =(B1-A1)*24 Vaya con Dios, Chuck, CABGx3 "Helen" wrote: In a timesheet, I'd like to be able to do a calculation for the hours worked, ... 24 May 2010 13:29

CONVERT HOURS AND MINUTES TO INT
What if I go over midnight? "Peo Sjoblom" wrote: Multiply by 24 and format as general or number =A2*24 -- Regards, Peo Sjoblom "3Nails" <3Nails(a)discussions.microsoft.com> wrote in message news:8902FC93-C724-4E4A-8DF3-47331D51EB90(a)microsoft.com... ... 24 May 2010 16:50