I'm sure many of you have seen the performance numbers published by most mutual fund companies for their different funds. They usually show MTD (month to...

I don't know about the rest of you, but everytime I try to open a message without a anything in the body I get an error message. Is this a universal problem,...

I need a formula that will lok up what is in a cell an another worksheet, and return "y" if it finds it and "n" if it doesn't I've tried using an if...

I have a column of numbers that range from 1 - 10 and I need to write a formula that says if B1:B5 = 5 then I need to divide the number of cells that are =...

I need to do different things at once in my worksheet. 1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the...

I wish to know how to have Excel discern different rows by the date. Sheet1 (Columns) -Date -Part # -Cost Sheet2(Columns -Part# -2006

Hi, I've had this oddity in both Beta and release versions of 2007 Excel. On a sheet for recording sports results for a team of players, certain cells turn...

I have 2 columns labeled "Code" and "Name". I want to create a link based on the following criteria: If cell B9 contains the code R, display the name in...

Hi, Since this is not a new topic, I tried altering some of the formulas already posted to this forum for vlookups w/multiple criteria but with no...

I have a column that contains many values in text. I am searching this column to see if it contains the partial text "Clinic". For example, three cells...

I have a large column of numbers that needs the decimal inserted. Please help

Hi, Is there any way of being able to maintain (edit) the Worksheets inside an Excel Add-in without converting the add-in back to .xls? Is there any other...

i need to show that column c is or = column a or or = column b to be true and displays acceptable then false if column a or column b and displays...

I have a worksheet where I type in lists of names on a daily basis. I have formatted the worksheet with the column headings and row numbers plus the...

I have a column with dates like 01/01/07 , 02/15/07 etc. Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I...

I am selling something to a friend and would like to make up a coupon book, like the bank does. So he will have a record of the transaction and a reminder of...

Please help!!! I have been trying to get the answer for this, a time too many. I know its possible. I have about 20,000 rows of data in Cell A2:A20001 to...

Referring to the post in General Question In cell a1, it contains text "2024--01-2007", and I would like to convert into 24-01-2007 for date format. Through...

I have numerous worksheets in the workbook that I want to merge. I only want to merge columns A thru F in each worksheet. They have the same headings. Is there...

I have a worksheet containing 4,000 rows containing customer names in column A & product detail in Row B. I have tried to use V look up but get the same...