General

IF
Column CZ in my spreadsheet calculates the difference between two dates in months. I would like to put a formula at the bottom of this column that tells it to total all of the cells from CZ5 to CZ999 that show a value lesser than or equal to 3. What kind of formula can i use? ... 8 Jan 2010 18:28

Problem opening up current Excel wksht to mail merge in Word
Hi, I have Microsoft 2007. I created a list in Excel with clients' name, address, city, state, zip. Then, in Word I go to Select Recipients, locate the Excel file and click open. Here's the problem: a Select Table box appears with Sheet1$, Sheet2$, and Sheet3$ as options. clicking on any of the three results in... 8 Jan 2010 16:12

how can I place a comma after each number in a column
... 8 Jan 2010 13:57

employee business chart
I want to create an employee business chart that shows from the top down department managers and each of their duties using Microsoft Home and School 2007 ... 7 Jan 2010 23:38

Sum
How do I sum a row of cells w/ numbers and letters (various) in each cell? -- mpima ... 7 Jan 2010 19:14

VBA moving and adding data
I have this appliaction that spits out a format that is not usable for me, but with some minor changes it would be good to go. I just don't know how the code would work. here is what part of my file looks like: ColumnA Coulmn B Column C Column D FAULT F02 ... 7 Jan 2010 18:06

Combining Letters and Numbers
I have 2 values that i convert into a specified letter and the other a number. I need to take those 2 cells and combine them into their respective letter combinations. For example. Data imput one produces A and 4 in 2 different cells. I need to have a new cell that combines these into A4 As another example... 7 Jan 2010 12:26

look up
I have 2 work books, one is vacation calender and the other one is weekly schedule. I need a formula to link both sheets. If I enter a name in the vacation calender I want that name says off in the weekly schedule. Eg. if vacation calender has these data column 1 jan 1 ganga I want weekly schedule sho... 7 Jan 2010 11:19

Change Preset Columns
My columns have 1,2,3, etc., how do I change them back to ABC,etc?? ... 7 Jan 2010 11:19

Removing Duplicate Values
Hello all I have a column of data made up of 100 cells. Some cells have a unique value and others the same value. Using a formula in another column, is there a way I can be left with just a list of unique values e.g. if X comes up 3 times in the original column how can I show it just once in another? I know... 7 Jan 2010 09:04