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 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to print everything in a cell26 Oct 2005 16:22 GMT2
I have a spreadsheet that has different sized cells filled with text. I have
2 larger cells and when I go to print these 2 cells cut off about the last 2
sentences. I have tried making the cells larger and removing the formatting
and redoing it but nothing seems to work... HeLP
pivot table created from another pivot table26 Oct 2005 16:16 GMT6
I was able to create a pivot table using an established pivot table; however,
the established pivot table has filters (created using the PAGE area of the
layout).  I was hoping that when the established pivot table is filtered on
(thus changing the data within the pivot), it ...
Advanced Date Functions26 Oct 2005 16:08 GMT1
You should have date functions that can return business days.
Example
01/FBD/2005 -> would return the first business day in January
12/LBD/2005 -> would return the last business day in December
Sumproduct #N/A! error issue26 Oct 2005 16:01 GMT2
I have not been able to find the answer after a while searching for it
so here is my question:
I am using the sumproduct function for calculating subtotals in 2
corporate worksheets dealing with production data and with the
How do I calculate IRR using monthly cash flows, not annual?26 Oct 2005 15:15 GMT2
As I understand it, Excel assumes that for purposes of calculating IRR, each
consecutive value is an annual value.  If I have a short lived project, say
16 months, Excel assumes that the cash flow in the 16th cell is the 16th
year, thus the IRR is dramatically understated.  How ...
Getting data from another worksheet26 Oct 2005 14:51 GMT1
I have an ever expanding excel sheet listing transactions. New ones are
added to the bottom of the list. In the row cells will show name, address,
value etc etc.
I want to have another worksheet that picks up the name, address, value etc
moving cells26 Oct 2005 14:50 GMT1
Hi guys I have a question or should I say i have a big fu*** problem
Sory about that word :) ok one of my employee is getting every week
excel document looking like the picture you can see it. Now here is th
problem. Each document has always at leas 1000 rows, so don't even thin
ISNUMBER and VLOOKUP Help Needed26 Oct 2005 14:38 GMT1
I have two separate spreadsheets: one that contains production jobs
scheduled for manufacturing (Job Order Reports and Press Capacity
Planning.xls) and another spreadsheet that contains all raw material in
inventory (Shipping and Receiving Data).  I want to write a formula on the ...
Excel Won't Calc?26 Oct 2005 14:19 GMT7
I sometimes find that when spreadsheets get to be a certain size they often
don't calc properly.  Any idea as to why?
Thanks,
Eric
Help!  How can I get data from one sheet to another26 Oct 2005 13:51 GMT2
I am trying to associate a cost with each item number and when I add an item
number in another sheet in one cell, I want the associated cost to be placed
in another cell.
Any help would be appreciated
Link To Drop Down Menu26 Oct 2005 13:35 GMT5
I have a cell with a drop down menu with Contract Types. I want cells to
populate with data elsewhere on a worksheet if this drop down cell = T&M.  
Please see example below to better explain.
Worksheet A
DATEDIF Simple request26 Oct 2005 13:30 GMT1
I want to enter regular entries in a spread sheet (of meter readings to
track utility cost) and in one column I want to determine the cost per
day.  I therefore enter the date in column A (set as "Date" field),
followed by such items as meter reading, unit rate, etc. In one column
How do I put in more than 7 validations in  IF FORMALA in EXCEL26 Oct 2005 12:31 GMT3
I have an excel sheet wherein I have a column in which I need to put in 30
validations . But the IF function is with 7 validations max. How can I do a
IF function with 30 validations
Validation26 Oct 2005 12:27 GMT4
I need a way to stop anything from being entered into a cell other than 2
letters and 2 numbers eg:
AA12    (Alpha Alpha Numeric Numeric)
Is there a way using validation to do this?
data validation using vlookup26 Oct 2005 12:25 GMT5
I have a spreadsheet with a list of serail numbers and their cooresponding
asset tags. I have named this range "AssetList".  I have another spreadsheet,
in the same workbook, with a list of employees. I need to enter the serial
number, then type in the asset tag.
 
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.