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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Fuction that gives number of days of a given month21 Apr 2006 19:44 GMT3
I am just wondering if there is a function that gives you the number days of
the month for a given date.
Thanks
Drop down lists and vlookup? or Match?21 Apr 2006 18:56 GMT14
I have already have my lists created....  Problem... in Cells A17:A62 I need
the list of employees names to display down the column by selecting the
number value in Cell A13...(A13 being a four digit crew code)... Each
employee has a four digit crew number associated with them... ...
WEEKDAY Function?21 Apr 2006 18:54 GMT5
I have a running schedule with mutlile tasks scheduled for different day # or
the same and would like to have the dates auto fill in once I enter the start
date.
example:
How do I stop VLOOKUP from asking what spreadsheet to look in?21 Apr 2006 18:13 GMT3
Every time I use VLOOKUP on a certain PC it asks what path to take. The path
is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
cumbersome. My other PC works fine. Is there a setting to make it stop
asking? It is in Excel 2003 on Windows XP for both PC's.
Sumif between values21 Apr 2006 18:10 GMT1
I'm trying to add up the values in column C only if the the corresponding
values in Column A is Equal to and between 2000 and 3000, 3000 and 4000, 4000
and 5000.
  A       B      C
How do I convert a list of data into mailing labels?21 Apr 2006 18:03 GMT2
I have 450 adresses and I need to convert the excel sheet to print on labels.
Does anyone know how to do this? Thanks!!
conditional sum formula21 Apr 2006 17:51 GMT3
I have a list of numbers to add if they meet two criteria and I have been
trying to use the conditional sum feature in excel.  
Column A is a list from 1 to 5 and I want to sum all the numbers in column B
if Column A is either a 1 or a 5.
Working with dates21 Apr 2006 17:49 GMT3
In cell A1 I have the numeric value of a month for example 3.  In A2 I would
like the previous month formatted as MMM.  What formula would I use?
Thanks
If Sum Countif Function21 Apr 2006 17:38 GMT1
=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1),COUNTIF($A$11:$E$12,1),COUNTIF($A$16:$E$17,1),COUNTIF($A$21:$E$22,1),COUNTIF($A$26:$E$27,1),COUNTIF($A$31:$E$32,1),COUNTIF($A$36:$E$37,1),COUNTIF($A$41:$E$42,1)=1),1,"")
I am having trouble with the above formula.  It appears to be ...
Importing information from 2 workbooks into a 3rd one21 Apr 2006 17:27 GMT2
Hi, I need some help with importing information from 2 different workbooks
into a third one. The problem that I have is the following: the reference
points from where the information needs to be pulled from are not the same
cells every day but information in column A that point ...
Can someone help with this complex formula?21 Apr 2006 17:12 GMT4
I’m building a general ledger.  I’m about 80% complete and need to now
move into the final 2 pages (1. YTD Budget Summary which will pull from
the 2. roll-up page).
I built the following formula;
Need help find automate way to cross reference two GAINT excel databases!!21 Apr 2006 16:59 GMT1
Need help find automate way to cross reference two GAINT excel
databases!!
Hi,
I am trying to match/cross reference (check by ZIP CODE) two extremely
How would i setup a breakdown method for my business?21 Apr 2006 16:50 GMT2
I have a business,that needs me to seperate cash according to denominations.I
use excel for wage slips,eg. if i pay R330-00 to an employee,below all the
slips it must show that i need 1xR200-00 note; 1xR100-00 note; 1xR20-00 note
& 1xR10-00 note.I had this formula before,but an ...
Please help with a 3d formula.21 Apr 2006 16:45 GMT4
I have 30 worksheets in a workbook.  I must total cell U125 on each sheet to
a summary sheet.  When I do ths, the formula is exactly right, but for some
reason it is skipping the value on sheet 11.  Any suggestions on what is
happening?  I'm at my wit's end!!
List from a table21 Apr 2006 16:38 GMT2
Good morning to all of you.
Has anyone faced the following situation?
I have a list that contains the following columns
- Day of the month
 
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.