Hi see your response in Excel.misc (for on possible solution). Please don't multipost as this create additional efforts for all who responds two your...

I have the following worksheet setup: Column A = Origin Column C = Destination Column E = Airline Cell A2: DTW Cell C2: IAH Cell E2: CO Cell...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

when I try to print a blank worksheet I have customized in order to input by hand (pencil), it will only print the headings I have typed in and not the...

I am trying to write a formula by which I could be able to handle 10 conditions in total. Please help me out as Ms Excel can not handle more than 7 nested ifs....

MIN value question: I have a spread sheet for grades. I have set up two cells one to give me the MIN value and the other to give me the MAX value. That way I...

To mark specific records for merging, you could add a column to your table in Excel, and use an IF formula. For example, =IF(A2="","X","") would return an if...

Does anyone have an elegant way of concatenating a series of cells? I think the answer will be a user defined function which will be equivalent to...

Have a golf card on a 2002 Excel sheet wanting to print many cards after reading names and handicap from an 2002 Excel sheet. Can not find a way of getting...

I want to do a SUMIF that will add amounts from either column C, D or E based on the following criteria: For each cell in the range F2:F200, if there is a "y"...

Hi, I want to use CUMPRINC and CUMIPMT in an amortization for a loan that includes a balloon payment. CUMPRINC handles this perfectly when I subtract the...

Hi all, Say I have a spreadsheet listed as follows: A1 = 03/31/05 A2 = $5.00 B1 = 03/31/05 B2 = $10.00

I have a large spreadhsheet with data I've manually copied/pasted from various sources including web pages. As I am trying to do things like import to Mysql...

Does anyone know if there is a way to change the number formatting from General to Number in one shot? I have an entire column that is in general formatting,...

Is it possible to have a note attached to a phrase rather than a cell? So where ever that phrase may be duplicated within a worksheet, it will carry the same...

Hi: Cell designations are H8:H51. I used your entire formula. But didn't understand where you got the "hhmm" designation. My military-time cell examples a...

how do I convert grams to pounds? is there a function for this? I use Excel 97. Thanks

Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...

I have 3 cells I need to merge into one. One of the cells is a number anywhere from 1-16 or more. What I need is for the number in this cells to always be...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed....