Hi, I have a little table which looks up a period number, and also has 4 columns for the week numbers of the period. Example Period week 1 week 2 ...

Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

I have a bunch of Excel 2003 graphs that are now being updated with new data. In the course of this, we are also saving as Excel 2007 macro-enabled files...

i am a new excell user 2007 how do i get the formula to say if A@ is greater than 2000 add 250

Hi I have made some tax calculators and would like to know how to insert them onto my website. I have tried the frontpage route but the user will have to...

I am trying to restore the grid lines on a work sheet and can't get them back. The tools/options/view button is not doing it. Any help?

I wanted to sum the values from an column but for some cells it doesnt sum it to the total. Why is this?

Please can someone help me. I have just purchased a netbook, with Windows XP operating system. Have loaded my Office 2003. Excel works fine, excpet for...

I have made my own statistic worksheet for my husband's baseball team. I would like to enter stats from each game & then get season totals on one sheet...

im using office 2007 and i couldnt be more frustated with all the new changes to the new office software, especially excel. i just wasted half an hour trying...

JUNE - 20 DECEMBER - 56 JUNE - 96 JUNE - 56 DECEMBER - 66 dear All, i have this data in 2 columns and what I want is: to appear 'june' automatically in one...

If today is the last day of this month, then return today+2, else today. Does anyone have any suggestions on how to determine whether today is the last day of...

Copying the contents of a box causes a lock up for 10 to 20 seconds. The jagged line around the box is stationary and after a period of time start to move....

I have a column of data that is almost 5000 cells deep. I want to be able to have the groups of duplicates colored a unique color. For example, if there...

I prefer the standard color pallet from Office 2003. All of my spreadsheets are based upon that color pallet. Is there any way to make the Office 2003 color...

I have 12 different tabs. I want to average a number on each tab only if the number is greater than zero. So, on tab 1 cell b6=140, tab 2 b6=245, tab 3...

I think I have seen an example where you have 2 seperate pieces of information in a single cell. I run a hockey team and use excell to track players and who...

Hi, I have a RMA form (sheet1),and I set up a customer dropdown list on column A on sheet 2; column B and C are corresponding phone number and address. I...

I would like to set up the formula based on three cells. I have data as follows: A B 10:34 Yes ...