Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can I run Excel LookUp on a single cell through multiple sheets21 Mar 2006 15:25 GMT2
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 GMT11
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 GMT4
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 GMT6
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 GMT2
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 spa21 Mar 2006 10:36 GMT1
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 SHEET21 Mar 2006 09:54 GMT1
Is there any excell Function to trace out the same figure in the other cell
or in other sheet
Reference21 Mar 2006 09:01 GMT17
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 Filterings21 Mar 2006 07:32 GMT5
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 GMT1
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 formula21 Mar 2006 04:31 GMT1
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 Filter21 Mar 2006 03:25 GMT1
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!!!
sumif21 Mar 2006 03:17 GMT3
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 cloumn21 Mar 2006 02:52 GMT8
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 GMT3
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.