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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I get Excel to tell me the angle of a line22 Oct 2005 01:02 GMT4
I am trying to determine the angle of a line drawn in Excel;  I need to acess
angles from digital photos...so I import the photo and draw a line on it....I
need to know the angle of the line.
Resize Range - Macro22 Oct 2005 00:38 GMT11
Please write a macro to CHANGE number of rows “3” to a variable range
(end.xlDown) on the macro below.
Sub GotToRangeResizeCopyPaste()
Application.Goto Reference:="MyRange"
Countif22 Oct 2005 00:05 GMT3
what formula can I use to do a count with more than one criteria?
How do I subtract block N19 from L19.21 Oct 2005 23:34 GMT2
Running a monthly expenditures worksheet.  Would like to subtract what has
been
paid this month ,which is on same sheet with what is normally paid each month.
example is  (L19)-N19). All I get is block contains a constant. What do I do.
need help again please21 Oct 2005 23:03 GMT2
I need to create a formula to add the dollar values in the cells of one
column based on the date values in a second column being in a certain month
ie October. This is the formula I came up with but it doesn't return the
correct answer:=SUMIF(AU8:AU55,"=>10/01/2005=<10/31/2005" ...
LOOKUP function -help!21 Oct 2005 22:22 GMT4
:confused:   I have been trying to help my mom with something (she's
taking an online class, but can't figure this out)  , I can't even
figure this out!  I know it has to be something simple.  She's done
everthing herself up till this point, but is totally stuck on this .
VLOOKUP21 Oct 2005 21:22 GMT8
How can I get VLOOKUP to continue searching a column after it finds the
value it is looking for? For example..we have the following in A1 (NEW YORK)
and in A2 (NEW YORK).  I am able to pull up the values in b1 (# of employees)
and c1 (total # of phones), but it does not seem to ...
percentage formula21 Oct 2005 21:05 GMT2
Please help with writing a formula. I have a list of numbers and need to
write a formula to show how many of them are over a certain value. Then I
need to know what percentage is over this value. Example: 13, 45, 25, 12,
56, 32, 08. how many of these are over 25 and what ...
Problem organizing text data into new excel page21 Oct 2005 20:20 GMT3
Ok... I am going to try to explain this as best I can.  I have a HUGE amount
of text data that was cut from a web page and pasted as text into an excel
sheet.  There are 9 entrys for each data set... so the first set goes from A2
to A10... second set goes from A13 to A21 and so ...
Making a button to sort21 Oct 2005 20:19 GMT2
Very simple I'm sure, but I just can't figure it out. I have data in rows 1
and 2 on my spreadsheet. I'd like to create a button on the spreadsheet that
when clicked, will sort rows 1 and 2 by the data in row 2. Any help or
pointers is appreciated.
How do I copy only cells with formulas in another row?21 Oct 2005 20:02 GMT2
I have a table with multiple formulas on each row.  I need to be able to copy
on the formulas when I insert a new row.  I've tried the paste special
formulas and that copied the whole row, data included.  I only want the
formulas to be copied.
Need help with TRIM function21 Oct 2005 20:02 GMT9
I have a table with these values, some of which are INVALID.
0120120001   VALID
0000212462   INVALID
0150214785   VALID
I wish to make a formula that adds dollars in 1 column if a date .21 Oct 2005 19:57 GMT2
I wish to make a formula that adds dollars in 1 column if a date range is
satisfied in a second column. This is the formula I came up with but it
doesn't return the correct answer. Can any one help me with a correction?
Conditional reference on average interest calculation21 Oct 2005 19:29 GMT1
One of the typical problems of modeling in finance is that when
interest is calculated on average outstandings a circular reference is
created. A possible solution is to have Excel calculating the interest
expense/income through iterations. Does anyone know, if other solutions
List Box with dynamic list - Help21 Oct 2005 19:07 GMT4
hi, i have a problem...
i have a list box and 5 dynamic named ranges. i also have a series of 5
option buttons that control which of the 5 named ranges is the one i
want.
 
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.