I was very happy when I found the INDEX/MATCH formula. However, as MATCH and VLOOKUP formulas seem to be able to udate themselves, even though the source...

I am currently using 07Excel. With 07Office, I got to click Office Button to view previously opened excel files. Is there other quick way to view those files?...

i have created a table which has in A2 Hand Towels B2 has the value 1 quantuty C2 has 1 D2 has 1 and E2 has the total 3 i wish to create a situation in F2...

I have a spreadsheet setup for a golf league with multiple sheets, sheet1 is for input. Sheet3 & 4 have formulas pulling the information from Sh1. Sh2 pulls...

Hello: Is there some important differences in the Visual Basic of Excel 2003 and Excel 2007? If I practice VBA in Excel 2003, could I have problems to do the...

Hi guys, If you are serious about your professional career and pass IT Certification exam in first attempt then visit http://www.beitcertified.com and get...

I need this answer very soon

i need a formula to display a date from a row of cells on a seperate page. it needs to ignor all other dates except the last one in the row id appreciate help

Dear sir,with best regards,in attached file i have two schedules ,one for details of the invoices contents and the second for ( summary) of these contents . i...

I need help with totaling a range of cells G12:G46. My problem is that not all cells contain values for the formula in these cells so it is not allowing me...

Hello, Thank you all very much for previous help. Have a line with an arrow head on it on a chart. The line should be perfectly horiz., but it appears that...

How to I move the borders with the cells when I sort the rows? Thanks for the help!

Hi: I need to create the ExcelTraining folder. How is this done? I am new to Excel, and need to learn it from the basics through VBA programming for my...

I'm new to Excel, so please explain things to this newbie in non-technical terms as much as possible! I have downloaded the array of previous week's winning...

How can I create a Behavior Modification template for children using Office 2007?

i am trying to create a model of genetics within a spreadsheet where the male and female genetic contribution to their offspring is displayed in a cell ...

Hi, Is there a way I can total up all the cells in a range which have any text in them what so ever?

I would like to create a formula that does the following: A2 - Time from B2 - Time to C2 - Break duration (mins, hours) D2 = A2 - B2 - C2 The problem is that...

Is this possible to change text colour(say to blue) after 10hrs automatically. so that next day when i open sheet & start working i can easily...

Hi, Using Excel 2007 Two questions, please: I added some text to a chart. Figured out how to do this ! Now I want to put a box around it, but have the text...