I have a worksheet with about 2,000 records. I have a status field with 3 possible values - Open, Closed or Void. I have about 25 records in this worksheet...

I have a worksheet which has a bunch of formulas in rows (i.e. data entered in columns C through F result in formulas results in columns G through...

I forgot to mention that although I can get Aotofill to use the correct time increments, it inserts in every cell, not in every other. Thanks again.

Hi All, I have 3 seperate excle(Crystal.xls, AMETITSG.xls, ITSGAsia.xls). If any data added in Column A of Crystal.xls and any data added in column D of...

Hi I have created a geographical map with different provinces in Excel 2003. I have assigned a macro to each province and it works well. I have also created a...

I have a minor Excel formula problem. In my example has following data, cell A5 shows "apple", A6 shows "salt", A7 shows "sugar" and A8 shows "fish". On...

I'm trying to teach myself Excel XP (using "...for Dummies"). I used Autofill to create a daily time schedule column, but in alternating cells (e.g., 6:00...

Being a complete newbie here, my question is as follows. I have created a spreadsheet for our Little League baseball team by position and inning. In each cell...

I had no problems with MS Excel 2007 so far, and yesterdays my files saved OK, but today I found Excel can't open neither of my many spreadsheets created...

I need to set up a spreadsheet for a business and do not know how to go about it. Does anyone have any assistance they can offer?

I need help with this and hopefully someone can assist! I am working with a spreadsheet that has different start and finish dates during the fiscal year (Oct...

Hi there, I use this site quite a lot, but its more luck than judgement that I ever see any of the replies I am sent. I get sent an e-mail with a link to...

you are all hero !!! you see clike here www.familyutility.blogspot.com see soon

Hi, I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format type that retains these numbers as four digits (allows me to go to 2400)...

This is probably simple to you guys, but I can't seem to get it to work. I need a formula that will add together the sum of A1, A2, & A3 cells, then display...

How do I find a formula to get a year's salary

I have been tasked with putting together a pivot table for my group that will highlight if a persons vacation falls within blackout dates. Right now I have a...

I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I...

I would like to know the most frequently occurring number in a range on my spreadsheet, but =mode(c4:u4) is invalid. It looks like it wants...

I have downloaded a chart for my daughters diabetes. When i view the tab bar it shows there is only 1 "sheet". However if I scroll down the side bar it shows...