|
|
Convert a Cell Reference to Text by
Chuck Buker
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...
|
|
6 |
10,370 |
|
|
Array formula in merged cells by
vtisix
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...
|
|
8 |
8,485 |
|
|
Movie Times Calculation? by
CAMooV
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. ...
|
September 18th, 2003 05:08 PM
by Charlie
|
3 |
7,601 |
|
|
Combining different worksheets using VBA by
jimmy2016
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...
|
|
0 |
4,146 |
|
|
Sort & Filter grayed out by
ljCharlie
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...
|
|
0 |
4,050 |
|
|
Radio Buttons on Worksheet by
Jeff Monroe
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....
|
|
0 |
3,972 |
|
|
Select a worksheet by
Phil
I'm using the below formula to determine the specific type of equipment from
a list named:...
|
|
4 |
3,161 |
|
|
Signature question by
ElaineT1
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...
|
|
1 |
3,044 |
|
|
Conditional Drop Down by
sunil.kini
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....
|
|
2 |
3,023 |
|
|
|
|
1 |
2,939 |
|
|
|
|
2 |
2,918 |
|
|
copy paste via macro by
Azrael
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...
|
|
1 |
2,872 |
|
|
|
|
1 |
2,835 |
|
|
Scoring or Rating by
JamesZ
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...
|
|
1 |
2,734 |
|
|
maintaining constant percentage by
SF123
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...
|
February 5th, 2011 12:01 AM
by Azrael
|
2 |
2,694 |
|
|
Selecting a Particular sheet by
shajizz
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...
|
|
3 |
2,693 |
|
|
|
June 3rd, 2010 09:42 AM
by steve
|
21 |
2,560 |
|
|
Conditional Delete Statement by
chrisjack001
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...
|
|
1 |
2,438 |
|
|
Moving comments in Excel by
sollc
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....
|
April 13th, 2011 01:18 PM
by sollc
|
0 |
2,437 |
|
|
Delta E(cmc) formula by
Michelle7890
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...
( 1 2)
|
|
10 |
2,387 |