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 / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
flag date within a cell after 15 days have past?19 Aug 2005 16:33 GMT2
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 GMT1
Is there any where I can access maps of countries of the world in Office
2003? Carl
Insert rows to linked spreadsheets19 Aug 2005 16:21 GMT8
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 GMT1
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 populated19 Aug 2005 16:16 GMT1
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 formulas19 Aug 2005 16:09 GMT2
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 Quarterly19 Aug 2005 16:01 GMT1
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 I19 Aug 2005 14:53 GMT10
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 HELP19 Aug 2005 14:51 GMT2
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 GMT2
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 Help19 Aug 2005 14:37 GMT1
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 Help19 Aug 2005 13:41 GMT3
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 Time19 Aug 2005 13:20 GMT6
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 sumif19 Aug 2005 13:00 GMT1
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 help19 Aug 2005 12:42 GMT4
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
 
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.