| Thread | Last Post | Replies |
|
| Is there a formula to hide/ display row based on cell value in Exc | 14 Sep 2007 21:33 GMT | 2 |
Excel 2003. Is there a formula to hide or display a row/column based on the value of another cell?
|
| Find Function | 14 Sep 2007 20:26 GMT | 2 |
Is there any way to integrate the "Find" Dialogue box right into the Excel file such that it is always visible? I want users to be able to find a file based on a key word entry (much like they would do with ctrl + F).
|
| Formula | 14 Sep 2007 20:26 GMT | 1 |
I have a column that accepts dates (8/14/07). some of the cells don't have any dates cause there is no need. I am trying to use an if statement referring to this column to perform a mathematical function. what i have is =IF(C7=C6,SUM(Z7-Z6),""). If works fine but when both ...
|
| Excel memory not working | 14 Sep 2007 19:50 GMT | 2 |
My excel 2003 sheets are not automatically calculating formulas any more. I'm not sure what happened. For example: if I add: 200
|
| How do you use sumproduct to return specific cell data? | 14 Sep 2007 19:42 GMT | 2 |
I have the following scenario: A B C D E 1Hotel# 1Job# 2Hotel# 2Job# Staff# 101 6001 100 5002 231356
|
| Pulling info 2 cells and putting it in one | 14 Sep 2007 19:24 GMT | 3 |
I have two separate cells, one in worksheet 1 and another worksheet2. I would like to make it so when I enter info in either of them it will automatically populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull the info from either cell automatically in ...
|
| Refering to a named range in a chart: 2007 | 14 Sep 2007 18:52 GMT | 1 |
Excel 2007: Working on a dynamic chart with named ranges. Trying to use the following formula in my chart (in the 'Chart Data Range:' box): =SERIES('Tot Revenue'!$M$4,TotRevenueYTDlabels,TotRevenueYTDvalues,1) ...but I am getting an 'Reference is not valid' error. I have checked ...
|
| Expanded view of Validation List | 14 Sep 2007 18:38 GMT | 2 |
I have a problem viewing the entire content of a validation list I have created in one cell, is there a way to make the entire contentvisible when you click on a validation list? Thank you in advance.
|
| Lookup based on 1st non-blank cell | 14 Sep 2007 18:30 GMT | 3 |
This should be easy but I'm having problems. Data looks like this. Jan Feb Mar Apr.........Dec John 10 5 6 Mary 2 4
|
| Match function problem | 14 Sep 2007 18:02 GMT | 3 |
I have a workbook in which one worksheet contains data for several companies, and the second worksheet pulls the data into a report using data validation. I am using an index/match formula to pull the name of the company that shows up on the report, which worked fine for quite ...
|
| comparing two list and need to find exact in both lists | 14 Sep 2007 17:58 GMT | 1 |
I need to compare the data in todays list and see if it was in yesterdays list and if so bring back a true otherwsie false value
|
| How to make a Let statement in Excel? | 14 Sep 2007 17:42 GMT | 2 |
I have a list of dates in a column, that is sorted by name and then date. The dates vary, but in assending order for each person. I have also filtered the data by determining which dates would be sequential, using a break of two days - ie-weekend, as sequential periods. I ...
|
| Percentages | 14 Sep 2007 17:10 GMT | 2 |
I have a group of building that equal 911,815 Gross Square footage Each building has a set gross square footage, one is 115,325 GSF How do I figure what percentage of the total gsf each of the building come out to be.
|
| have cell in sheet 1 look up last row of column 'x' in sheet 2 | 14 Sep 2007 15:20 GMT | 4 |
I have a summary table in sheet 1 that needs the totals from other sheets in the workbook. the totals on the other sheets totals are on the last row of the sheets however these rows constantly change. Is there a way i can tell exceel to look at column b in sheet 2 and always
|
| Create a printable FORM | 14 Sep 2007 15:14 GMT | 2 |
I need to create a FORM that prints data rather than enters data - odd I know. The forms are certificates required by regulation. So, data is entered into a table and then merged into a FORM that is printed on the print command.
|