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 / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Return a list dependent upon the selection of a preceeding list11 Apr 2007 19:48 GMT4
I am creating a form defined by Category, Item, and sub-item.  I would like
to be able to select the category from a list.  Then dependent upon that
answer I would like to be able to select the appropriate item from that
specific Category list and so on.  How can I do this?
How do I link the header to something in the worksheet?11 Apr 2007 19:41 GMT1
I would like to have the header (in Excel) show the content of cell D1 in
sheet1. I would like to know how to do this.
Thanks.
end date11 Apr 2007 19:39 GMT3
If I input a start date in a cell, and give the number of days required to
complete the task in another cell.......How can I compute the end date
omitting the weekends (Saturday and Sunday)?
thanks
how to use the ceiling function11 Apr 2007 19:34 GMT2
What I am attempting to do is multiply each cell in D column by 6 and then
rounding up the answer to a multiple of either .25, .50, .75, or up to the
next whole dollar amount.  But I want it to do it on each row. I am using the
excel template for inventory.and so far I got the ...
Sorting latitudes and longitudes11 Apr 2007 19:18 GMT7
I have a large dataset (~5000 rows) that is tied to latitdue and longitude
(small portion below). For each latitude/longitude reading I have between 8
and 10 columns of other data (not shown). I would like to sort the data into
latitude/longitude bins and then analyze it. The bin ...
Excel question11 Apr 2007 18:24 GMT5
Simple help needed, I want to make a cell return a value when another cell
has a particular value.  for example
Part #    color   
11    red    This cell = red, blue, … depending on what Part # is entered.
Adding formulas11 Apr 2007 18:10 GMT4
Hello from Steved
I would like to please add the 2 below to a cell, What Do I need to do, They
are two Cities that I want to be added together to be put in Cell C5.
=IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE))
Can an Excel cell value be used in a Custom Footer?11 Apr 2007 18:00 GMT7
Attempting to print some reports from a Pivot Table and should like to use a
cell value as a footer.  Is it possible to quote a cell value in the Footers?
Excel decimal moving?11 Apr 2007 17:55 GMT4
I am trying to format a cell so that i can input a number and excel will
automatically place the decimal point for me. for eg.
i want to type  12  i want excel to put    0.0012 etc
i want to type   1   i want excel to put    0.0001
multiple variables in sumproduct or if/then formulas11 Apr 2007 17:28 GMT4
Help....I just can't figure out a correct formula.  I need a formula that
gives me:
if a specific date spreadsheet A = a date on spreadsheet B
and a specific dept # on spreadsheet A = the department# on spreadsheet B
Sort not working - very large file11 Apr 2007 15:58 GMT1
I am trying to sort a file with many columns, it is a 10 M file.   If I break
the file in half, I can sort half and then sort the other half, but I cannot
sort the entire file.  Is there a limit that messes up sorting that I haven't
found?
Difference in Weeks between 2 dates11 Apr 2007 15:56 GMT2
I am desperately trying to figure out the difference between 2 dates in
weeks. Could somebody help me out? I greatly appreciate your help.
Thanks
Susanne
Exporting data to Excel11 Apr 2007 15:52 GMT4
How come when I export data to excel and reformat a column to numbers, it
doesn't recognise them as numbers and I have to retype the numbers in a
separate column to calculate them.
HELP PLEASE.
How to forecast non-numerics?11 Apr 2007 15:31 GMT4
Here is a sample of what I'm trying to forecast...
Month    Visitors to Store
Jan         50,000
Feb        60,000
Lists From Different Tabs11 Apr 2007 15:30 GMT2
I'm trying to use Validation on Sheet 1 to create a list.  The data for the
list is on Sheet 2.
I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.
 
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.