What Excel 2007 fcn do I use to find the letter of the first column in the row C2:C13 that is empty? I appreciate your help, -John

above 200 excel files are corrupted i am not able to open or view that files please help me

I have two columns, A being dates and B being values. How can I display from those two columns the minimum amount and the maximum amounts in separate cells at...

I am trying to find a way to copy a short range each day with the TODAY() instruction. The real challenge I think is although the destination is always the...

i need to calculate the # of working days between 2 columns (I and J). i'm using formula =NETWORKDAYS(I2,J2). Is there any way to use a variable somehow so I...

I have a form in a worksheet - I want to print multiple copies with page 1 on the first, Page 2 on the second, etc, etc. How can I do that?

I need help with formula. I have my scheduling on excel and I have it set like this: A B C D E F G ID# Name RGY ...

formula for: if a1 is greater than 1 but less than 10 value is "a" and how to nest it for 7 iterations

I'm having problems finding the difference between to columns of time formatted into mm:ss. The difference shows up as ##### So, I converted each column of...

Hi. I need to find the multiplied sum of double, triple, quadruple... combinations in a row, both separately and combined. e.g. 1 2 3 4 2 5 4 6 doubles...

Hi, Is there a way or formula in the excel to get the ans indicate below Column G) Column A is the product. Column B to D is the month and Qty Column F is...

I am looking for a function to convert a amount (number) to text in indian ruppees. For example, 23456789.00 would display as "Two crore thirty four lacs...

trying to mail merge using database with letter & number in cell. The merge comes out with a 0 instead of T321

I have a large and complex workbook that uses workbook_open() to execute some simple code at startup (it requests the entry of the user's name). This code...

hi i m having a problem with excel sheet.recently when any formul is entered in a cell, the result doesnt change when the value of the cell is changed. for...

This was really helpful. Is there any way I can use the contents of the cell as part of a worksheet name,such that a hlookup of another sheet could select a...

Say I have 2 lists. One of which we'll call citizens, the other we'll call enemies. everyone on the citizens list should also be included in the Enemies...

I have to effectively do a lookup table on more than one variable group and product code. I have a lookup table this is an extract. Group Product code Long...

I have long texts in rows of column A and values in Column B. The sheet has 1000 rows. I want to add values in column B if the texts has "LCI" in it. I tried...

I would like to create a function that changes every month. For example in month 1 the formula would be SUM(A1:A1), in month 2 it would be SUM(A1:A2), in...