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