General

AVERAGEIF FORMULA EXCEL 2007
I thought I posted this Friday, but could not find it. I have 46 columns, 3 colums per week of data (14 Weeks). Week End 02/06/10 Total Jobs Completed Total Hours Worked Total Hours Per Unit 0 0.00 0.00 0 0.00 ... 12 Apr 2010 15:55

Data Validation
Hello, Im using data validation to enter information from a list of company addresses. Can someone associate a name for example for a certain address and copy it to the next cell, everytime someone selects that specific company address??? ... 12 Apr 2010 18:09

Are there any Excel macros for a simple countdown timer?
Are there any macros for a simple countdown timer in Excel? I'd like a small countdown window in an upper corner to show a timed countdown from 10 minutes. Thanks. ... 12 Apr 2010 15:55

How do I copy color text & paste keeping color
How do you copy text from a cell and paste it to another cell and Keep its origianl color? ... 12 Apr 2010 18:09

recently viewed items in Excel
I am trying to, show recently viewed excel spread sheets under excel in the start menu. I have this option in Word 2007, and One Note 2007 but not under Excel 2007. I checked Excel options, advanced, and there is a number of recently viewed doc. in box. But still nothing under Excel on start menu. Am I missing ... 12 Apr 2010 14:47

Auto-Close
I need to have my workbook on our network to automatically save then close from whichever workstation that it is opened at whenever a request to open the workbook is made from a different workstation... Computer #1 -- Viewing the workbook Computer #2 -- Requests to open the same workbook Computer #1 -- Workbook ... 12 Apr 2010 17:03

Combine rows and Qty
Please Help!!!! My need is to sort, combine similar values of rows in column 1 (having 1 value in cell at the end), then combine refdes in column 2, separated by a comma, (ex C4,C8), then adding quanities (scroll down to see desired end result) PartType RefDes PartDecal QTY CAP_330PF_0805 C... 12 Apr 2010 14:48

keyboard with excel
The arrow buttons on my keyboard do move the cursor to adjoining ... 12 Apr 2010 13:41

To find the same price in another sheet
I have a column with name 'Item' which contain the code of the product. Another sheet ( same file) contain code and profit. Sheet1 item A1 200 300 400 500 600 Sheet2 Item preofit A1 B1 200 60 500 10 600 20 400 10 I have to fi... 12 Apr 2010 14:47

command button colour
hi i have 3 form button at the moment that when u click run there code and they also change the colour of the text from green to red and the next buton from red to green that way if u get pulled away u now were u are but would like to use command buttons as u can change the face colour not just the text is ther... 12 Apr 2010 14:47