| Thread | Last Post | Replies |
|
| Can I run Excel LookUp on a single cell through multiple sheets | 21 Mar 2006 15:25 GMT | 2 |
I am using Excel 2003 SP2 and am trying to find a way to run a look up function on a single cell, through multiple sheets, as opposed to a normal V or H Look Up. Does anyone out there know if this is possible and if so, how to do it?
|
| Please help, I've been struggling for weeks! | 21 Mar 2006 15:24 GMT | 11 |
I'm having a bit of a problem with a spreadsheet I'm working on. Th setup is I have two columns of strings and I need to put a differen string in a third column depending on the contents of the first two All this is on 1000+ rows.
|
| Vlookup gives wrong answers when used in large data. Pls advise? | 21 Mar 2006 15:14 GMT | 4 |
I've been using vlookups for a couple of years now and my colleague and I have noticed that when we use them in large speadsheets (50k lines+) the vlookup comes out with the wrong answer. As anyone else ever come across this? It happens especially when I use VBA to calculate ...
|
| Moving Average projection? | 21 Mar 2006 14:55 GMT | 6 |
I have a column of numbers in which I created 2 different Moving Averag time frames. Now I want to know: How to write the formula:
|
| How do I tie the computer clock with formula execution? | 21 Mar 2006 14:23 GMT | 2 |
I am trying to have excel execute an "IF" formula based on the computer clock. For example, if there is no entry in a cell on a given day the a certain result should be displayed (such as $0.00 or "No Run"). I cant seem to find help on this function. Thanks.
|
| how to use English excelbook in a computer with excel vers. in spa | 21 Mar 2006 10:36 GMT | 1 |
A work sheet with add in functions in english, does not seem to work in a computer with an excel version in spanish. WHAT TO DO?
|
| FUNCTIONS FOR TO TRACE THE SAME VALUE IN OTHER CELL OR SHEET | 21 Mar 2006 09:54 GMT | 1 |
Is there any excell Function to trace out the same figure in the other cell or in other sheet
|
| Reference | 21 Mar 2006 09:01 GMT | 17 |
How do I write a reference from a drop down list to another sheet and have the formula do the if function so that it can do several arguments and return "direct" if true and "indirect" if false. I had posted this before but then realized I hadn't been very clear about it. I hope ...
|
| Need a number count of items on list after Filterings | 21 Mar 2006 07:32 GMT | 5 |
I am using Excel 2003 to manage a Club list and would like an automatic number count of the names on my list both before and after using various Filter functions. ----------------
|
| A book for statistical functions? | 21 Mar 2006 07:21 GMT | 1 |
I am looking for a courseware manual or short book that would teach statistical functions. Does anyone know of any? Thanks Vicky
|
| Cell reference in formula | 21 Mar 2006 04:31 GMT | 1 |
I am trying to put in a cell reference into a a countif formula. As referenced below, I would like to insert the formula from D37 into the formula in E37. As the formula in D37 equals 37, I am trying to paste this formula over the number "37" in cell E37. However, this isn't ...
|
| Auto Filter | 21 Mar 2006 03:25 GMT | 1 |
How do I capture the value that is shown on the bottom left corner after I perform a filter function. I need to use that number within a macro. Thanks for the Help!!!
|
| sumif | 21 Mar 2006 03:17 GMT | 3 |
I'm trying to use one sumif formula to capture YTD personel info from several tabs (Jan-Dec) within a workbook with no success. The criteria is the personel name. Because people come and go from the company the data can't simply be pulled from the same cell from the different ...
|
| copying data from matching cloumn | 21 Mar 2006 02:52 GMT | 8 |
I have in column K through W, column of data . The column heading is in row K3:W3. In cell Y3 is the heading of a new column that the user will enter. What i need to do is to find the matching cloumn heading from K3:W3 and copy all the data from that column to the new column. Anyone
|
| Copy to another sheet and??? | 21 Mar 2006 01:17 GMT | 3 |
Hi, I tried searching for an answer to this but couldnt find the one I needed. Apologies if I missed it. I have data in cells B2 thru E2 on sheet 2 of my book. (eg, truck, red, 100Ton, petrol) that is all selected from drop down lists.
|