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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Find max date25 Nov 2005 10:32 GMT6
i have a number of dates in one cell separated by carriage returns
(alt-enter). how can i find the max of these dates?
Help with formula25 Nov 2005 09:59 GMT2
Is there any way to do this.
I have a column of dates. The dates are at regular weekly intervals starting
from 1990 until now and they are always a Friday. In a separate worksheet I
would like a formula in a cell to return the row number of the first date
In Excel: select the last 20 rows of data in a column25 Nov 2005 09:36 GMT3
How do I create a formula that will select the last 20 entries in a column of
a database?
Problems with setting up a billing budjet25 Nov 2005 09:17 GMT1
Wow, talk about a useful program.  Where have I been all these years?
Oh, yeah!  Happy Turkey Day!
This is a basic question for a basic form.  I can't seem to navigate
through excel (actually using Open Office but it's nearly the same) to
vlookup using two lookup values?25 Nov 2005 05:22 GMT10
Is there a way to perform a vlookup with two lookup values?  For instance,
I'd like to look up the value of A1 and B1 in a table with A1 and B1 values
included to return cell C2 from the table.  Any ideas?  I've had limited
succcess using concatenate and then using vlookup on ...
Find last non-blank row with a worksheet function25 Nov 2005 05:10 GMT2
Find the last row with a value.
Say I have a worksheet with a data entery range of A1 to A100. The user is
required to enter data from row 1 downwards and cannot leave blanks between
rows.
complex amortization25 Nov 2005 04:56 GMT1
Problem:  5 loan amounts, each different, with varying interest rates,
payments, and loan periods.  The loan periods are epressed in decimals of a
year, not full years.  I need to determine the total amortization if, as the
highest interest loan is paid off, the payment for that ...
Rounding25 Nov 2005 02:33 GMT3
I would really like some help,
round(3348.86*.1,2) = 334.89
round(3348.86*.03,2) = 100.47
when added together 334.89+100.47 = 435.36
How easy is it to loop in VBA based on cell contents?25 Nov 2005 01:22 GMT3
I have a function in code that I added via the built in form designer
Option Explicit
Private Sub CommandButton1_Click()
   Application.Calculate
Count cell25 Nov 2005 01:22 GMT3
I have a cell "Exams" who contains  Exam Description.
For example;
Exam
8086L ANKLE - LEFT
best formula to use25 Nov 2005 00:50 GMT2
Hi*
What would be the best formula to use if i want to find out how much a
number would go into a number then the left over part
Eg
How to summarize the first 4 numbers greater than 0 from a list.24 Nov 2005 23:34 GMT7
I've a list of numbers, I need to summarize the first 4 greater than zero
cronologically eventhough they were in different places, and it could happen
only three or less were in the whole list.
Ex.
Selecting a range of values for another function24 Nov 2005 22:45 GMT4
I cannot seem to figure this one out...
I have a table that contains e.g.:
        Company1 Company2 Company3
Date1   Value11   Value21
How do  I extract data from graph (i.e. interpolaton)24 Nov 2005 22:31 GMT1
If we have a table of data values, can we build a graph and extract values
from it not found in the table?
Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear)
graph is created. Is there any simple way to find the value that goes with
Error in "IF" formula24 Nov 2005 22:00 GMT4
Please help me to see the error in the following formula:
"=IF(G6>=0.9<=1,E6*G6,IF(G6>=0.75<0.9,(E6*G6)*1.05,IF(G6>=0.6<0.75,(E6*G6)*1.1,IF(G6>=0.45<0.6,(E6*G6)*1.15,IF(G6>=0.3<0.45,(E6*G6)*1.2,IF(G6>=0.15<0.3,(E6*G6)*1.25,IF(G6>=0.1<0.15,(E6*G6)*1.3,0)))))))"
The worksheet is ...
 
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.