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. ...

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....

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'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 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...

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...

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...

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...

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...

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 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....

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 been trying to calculate a column of Text in order to sum contents by certain criteria I have tried Count, CoutA and CountIF and cannot be able to get...