I see that when using the lookup function, if the lookup value entered does not match anything in the lookup vector, the result vector returns as the next...

Hi, I'll describe my problem using a simple example. I have two sheets. Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5 (in column K0) and...

Hi, I'll describe my problem using a simple example. I have two sheets. Sheet 1 contains records (rows) with identifiers X1,X2,X3,X4,X5 (in column K0) and...

How can I get microsoft exele to do math eqations and show the work?

I have two questions, which I will post separately. Both questions refer to Excel 2002. Firstly I have a Spreadsheet with entries in cells A1 up to and...

I have a very large Spreadsheet with entries in Column “A�. The cells also contain a comment to let the user know what kind of entries should be on a...

I am trying to utilize the IRR function in excel to calculate IRR for my string of cash flows for 30 years: Year Cash Flows 2008 - 2009 852 2010 2,163...

The sheet does not have blank lines. All of the columns data in them. It does at this time have 2280 lines with data. This will increase every week. "Franz...

I am having a hard time trying to do up a worksheet that will allow me to use the solver technique. Does anyone know how to do this?

Is there a way to format more than one field at a time in a pivot table?

I am trying to type the following in a cell and I want the format as general, but when I type it in, it automatically changes to date format 1/5233 can...

Hi - need help again... I have a large worksheet with a column for first name and a column for last name. Within the column for first name, some of the...

After making a cell entry, I have to hit enter key before using arrow key to move cursor to next cell. How do I move cursor to next cell with arrow key only;...

hi i have this Data with below 50% average is the passing grades and above 50% is failure average. my question is i need to have it converted in the normal...

Greetings, I have an Excel Sheet with lists of vehicles I need to sort or filter by Model Year. The only way to determine that in this list is by the Vehicle...

I did a "New Database Query" to bring in a cube and I'm trying to figure out if there is a way to only hide certain levels of the cube. For instance, the...

Here is what I would like a formula to do??? I have two workbooks- I will place the formula only in one and extract data/info. from the other. What I want...

I am trying to sort a spreadsheet where the values are percentages. I have the percentages set as a result of a formula from a different worksheet in the...

Hi, I have coulmns A through CJ and I want to add 27 coulmns before column O. What is the easiest way to do it? Thanks for your help. Nee

How do I code a Macro to insert new rows by criteria? I’m using an excel spreadsheet to keep track of Account names, Id numbers, date received, date...