Cell A2 contains the text "a100". Cells A5 through F15 contain indirect and offset functions that use the text in A2 to cause cells A5 through F15 to refer...

I have a simple array formula that sums 3 criterias. After I've entered the formula and do Ctrl+Shift+Enter, an error pops up stating that "Array Formulas are...

I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. ...

Combining different worksheets into a single worksheet. Dear helpers, I am new to VBA and have the problem: To combine worksheets into a single worksheet we...

I have a table with A-G columns and 20 rows. If I do not select column A then the "Sort & Filter" is enable. The "Format as Table" also works. As soon as I...

I am just trying to add simple groups of radio buttons to a worksheet for yes-or-no questions to be filled out by the user. No funtions, no data being entered....

I'm using the below formula to determine the specific type of equipment from a list named:...

I am trying to set up a workbook in Excel 2007 with multiple tabs and two signature lines at the bottom of each sheet. The idea is that my boss can read, sign...

In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs....

What is DBRW as used in Excel cell formula ie =DBRW(

I have a variable sized data set in a work sheet. Simplified it's like this: A B 1 data1 =Today() 2 data2 =Today() ...

I need to copy certain data from a page and move it to another form, in the same book. The basics is that data will be entered each day then the user will hit...

I have VB code in Excel Spread sheet that uses Format function to convert date to yyyymmdd format, it works in Excel 2000 but not in Excel 2003. Any info on...

From a previous post. Thought this example might be easier to understand. I have an Evaluation Sheet that has four cells of different ratings each...

Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of...

I'm using Excel 2007, workbook there is several sheets, I want to select the particular sheet from the first sheet, any tips please... Expl:- I'm making...

Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?

I want to create a code that can run through the entire spreadsheet and delete the rows of all accounts that have $0 or less Outstanding balance. Example in...

I have moved a comment by dragging and dropping it. However, when I 'hover over' the cell with the comment, the comment box goes back to its original position....

Does anyone out there have the Delta E cmc formula for excel? I am trying to set up a spreadsheet that compares colors of test samples to a reference sample...