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 / October 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
VB in Excel21 Oct 2006 02:25 GMT10
What I have is a list of names, and a value beside it.  Each name has it's
own sheet within the workbook.  I'm trying to call a macro/VB script in order
for it to go to the worksheet I need, pull the info and put it into the value
beside the name in the list.  If I hard code the ...
how do i link up 2 sets of data into 1 set of data in excel21 Oct 2006 01:52 GMT2
i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
the basic dat sort doesnt work as not all of the data are the same in the 2
sets. i know you use concatenate somehow. the example is data set 1 is name
and phone numbers , data set 2 is names and ...
Using the current row in a formula21 Oct 2006 01:33 GMT3
This is probably a simple question :)
I have a formula where I would like to reference a different column in
whatever row the formula is in.
Something along the lines of
conditional formula21 Oct 2006 00:40 GMT2
I need to sum cells based on color coding.  I am unable to determine how to
do this in the conditional format.
Thanks for your help
Rose
Date Range displayed in header21 Oct 2006 00:24 GMT6
I am attempting to put the range of MIN and MAX dates pulled from a column. I
would like it to look like:
Date Range: 9/6/2006 - 10/26/2006
from a column like this:
CAN'T INSERT SYMBOL?21 Oct 2006 00:23 GMT4
       In Excel 2000, under XP SP2.
I lose the insert symbol function at odd times.  Some times if I shut the
file down and
re-open it comes back other times not.
Wireless Network Use20 Oct 2006 23:56 GMT2
Can an Excel worksheet be SHARED to wireless networked laptop
256 ways to make hamburger20 Oct 2006 23:50 GMT2
how to I input into excel to do a spreadsheet on 256 ways to make a hamburger
average low 10 of last 20 entries20 Oct 2006 23:36 GMT9
I have a continuing list of numeric entries.  At any one time I want to be
able to cvalculate the average of the lowest 10 of the most recent 20
entries.  I'm using Excel 2002.
how to split  abc123 into abc 123?20 Oct 2006 23:32 GMT3
i need to sort by 4th char. or split the data into two different colm.
Return Numeric Values Matching EXACT Date for Criteria20 Oct 2006 23:20 GMT4
I would like a Formula that returns numeric values ONLY if they  MATCH the
EXACT date.  
The Formula below does work in part. But when the actual date does not exist
or a value for that date does not exist, the Formula returns a value nearest
Function is displayed as text rather than giving a value20 Oct 2006 23:19 GMT2
Ever since our company switched to Office 2003 (about a year ago), I've been
having a problem when entering functions. They show as text in the cell  
rather than giving me the answer/value [ex: =IF(BF2=S2," ","XXX")]. I then
end up having to do a text-to-column in order to fix ...
Solver whole numbers20 Oct 2006 21:38 GMT2
In Solver, if my changing cells are percentages does solver have a way to
only use whole numbers with no decimal places?
Why isn't Excel dragging the right value?20 Oct 2006 20:41 GMT6
I am using SUMIF and have been able to drag the formula down the column and
the right values pop up.  Now, when I drag, the column is filled with the
value in the first cell in the column.
After dragging, I can double click the cells or hit F2 (to edit) then hit
vlook20 Oct 2006 19:54 GMT6
Hello     I have a formula  in a cell and the response is #NA.  Here is the
formula
=VLOOKUP($J33,'2006 Discount Grid'!$A$1:$O$386,12,FALSE)  the reason I'm
getting the #NA response is that $J33 is also a Vlookup.  but I don't know
 
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.