| Thread | Last Post | Replies |
|
| Fuction that gives number of days of a given month | 21 Apr 2006 19:44 GMT | 3 |
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 GMT | 14 |
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 GMT | 5 |
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 GMT | 3 |
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 values | 21 Apr 2006 18:10 GMT | 1 |
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 GMT | 2 |
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 formula | 21 Apr 2006 17:51 GMT | 3 |
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 dates | 21 Apr 2006 17:49 GMT | 3 |
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 Function | 21 Apr 2006 17:38 GMT | 1 |
=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 one | 21 Apr 2006 17:27 GMT | 2 |
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 GMT | 4 |
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 GMT | 1 |
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 GMT | 2 |
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 GMT | 4 |
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 table | 21 Apr 2006 16:38 GMT | 2 |
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
|