| Thread | Last Post | Replies |
|
| flag date within a cell after 15 days have past? | 19 Aug 2005 16:33 GMT | 2 |
I am looking for direction on how to write a formula to Flag a cell containing expiration dates, once the date has gone past 15 days. I have tried to perform this function in conditional formatting with no success. I'm having problems with formatting the formula. Any ...
|
| Maps of countries of the World. | 19 Aug 2005 16:22 GMT | 1 |
Is there any where I can access maps of countries of the world in Office 2003? Carl
|
| Insert rows to linked spreadsheets | 19 Aug 2005 16:21 GMT | 8 |
This is probably a question that has already been asked, but is it possible to link one worksheet to another so that when rows are inserted into the original sheet, they are automatically inserted in the linked sheet?
|
| Find duplicates then calculate..??? | 19 Aug 2005 16:19 GMT | 1 |
Right ok Say I have a worksheet with A1 - Contract No's, B1 - Serial No, C1 - Rental, D1 - Rebate. A Contract # B Serial C Rental D Rebate
|
| Check to see if a cell is populated | 19 Aug 2005 16:16 GMT | 1 |
I know this is very easy I just can't think right now. How do I check i a cell is populated and enter one specific string if it is. Ex:
|A ___________|B_______________| |____________|_________________| |
| aging formulas | 19 Aug 2005 16:09 GMT | 2 |
I am using Excel to track Accounts Payable for a small company. Column A is the $ amount of the invoice, Column B is the date of the invoice, Column C is the due date and columns D,E,F,G....are aging (i.e. 1-30, 31-60, 61-90, 91-120).
|
| Update a Date Quarterly | 19 Aug 2005 16:01 GMT | 1 |
I work for a financial institution, and we have reports that are updated quarterly. The reports are in PowerPoint 2003, though there are embedded Excel spreadsheets. After the reports are generated each quarter (March 31, June 30, September 30 and December 31) afterwards we are ...
|
| Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I | 19 Aug 2005 14:53 GMT | 10 |
My data has 3 columns that id a value. I have concatenated them to create a unique ID. In the lookup.xls I created a map for each unique ID to the desired output text. The uniqueID is in col 4, row2; the range that contains my mapping (unique ID in left column, sorted ...
|
| HELP HELP HELP HELP HELP | 19 Aug 2005 14:51 GMT | 2 |
I have two worksheets. Both worksheets have data in column A, B, C, D, E, F, and G. Column B has a list of with text and numbers(this is in both worksheets). There are multiple duplicates in each worksheet. I need to combine the two worksheets into one worksheet with no ...
|
| MERGING COLUMNS WITH DUPLICATE INFO. | 19 Aug 2005 14:39 GMT | 2 |
I really need help. I have two worksheets with data in columns A-G. Column B has content like "HDMU4524565". This is in column B of both worksheets. There are multiple duplicates in Column B on both worksheets. I need to combine the two
|
| Maximum If Help | 19 Aug 2005 14:37 GMT | 1 |
Thanks to the guys who helped on the 'Average If' post. Both worked <G> I now want to find maximum salaries and, unfortunately, I can't tweak the above solution. Essentially I have two columns
|
| Average if Help | 19 Aug 2005 13:41 GMT | 3 |
I'm trying to calculate average salaries by for a grade within a payroll I've got two named ranges - one is called 'grade' the other 'salary'. These contain the grades and salaries of all staff I'm trying to enter an array formula along the lines of
|
| Function to convert Time String to Time | 19 Aug 2005 13:20 GMT | 6 |
What excel formula would I use to convert a number string i.e. 143254 to a time string, i.e. 14:32:54 I need it to be as a formula so it is automated and not a manual process. Thanks in advance
|
| negative sumif | 19 Aug 2005 13:00 GMT | 1 |
How do I do the opposite of a sumif formula. I have two workbooks which I need to subtract the values from one to another, where there are multiple entries?
|
| Excel Formula help | 19 Aug 2005 12:42 GMT | 4 |
I am a 61 year old beginner !!! I need help to write a formula to get the following result. B1=5 then C1 should read 1 B1=5.5 then C1 should read 1.5
|