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
Selecting Rows22 Aug 2005 16:08 GMT4
I want to select rows 3 to l_LastRow.  I can't say Rows("3:l_LastRow"),
so what are my alternatives?  Thanks!
This is what I have:
----------
Convert Text (letter) To Number Excel22 Aug 2005 15:49 GMT2
I really need someone to help me out with this basic function:
On microsoft excel, I need a LETTER (ALPHABET) in a cell to be
converted to a numerical value automatically.
EXAMPLE:
Large function22 Aug 2005 15:34 GMT4
Hi Group
I am trying to find the top 10 values in a range.  If  a value is repeated
then it may show up say as the largest and next largest.  How do I ignore
repeated values.  
this may be simple, sumif question22 Aug 2005 15:12 GMT3
i have a column that gets 2 values in it either a number which could be 0,
or a blank.
i would like to sum another column if the first one is empty(blank).
column A    column B
Workbook formulas22 Aug 2005 15:05 GMT1
I know this is probably a pretty simple question, but I need to ask it
because I can't figure out how to do it myself.  
I have a workbook that has three worksheets in it.  The third worksheet
is supposed to take totals from worksheets 1 and 2 and combine them.
Next Row22 Aug 2005 14:52 GMT2
I'm trying to find the code which automatically finds the next available row
in excel in order to paste some data from the clipboard. Please could you
help?
How can I convert Text into numbers?22 Aug 2005 14:04 GMT8
I have imported data from a survey tool into Excel. Unfortunately, instead of
importing the selected fields in a question with a number, it is imported and
shown as text (i.e. Question 1: Yes ( ), No (selected) instead of : Yes( ) No
(1))
countif criteria only one word of few doesn't work22 Aug 2005 13:46 GMT3
I am trying to use countif where the criteria in some cases will be on
word from a cell that has several words in it.  I'm getting a tota
count of 0 in these instances.  Is there a way to set the criteria t
work this way or perhaps a different counting function?
Help! Formula between the sheets22 Aug 2005 13:31 GMT2
Hi guys, how can I have formula on one sheet that refers to values on another
sheet within the same workbook?
Eg sheet one has formula b1/a1- but the values refer to the cells in sheet
two, but the answer is in sheet one.
Sum of comma seperated values in cell(Reposting)22 Aug 2005 13:17 GMT3
Can anyone help me in writting a formula to find the sum of comma
separated numbers in a cell
Thanks in advance
Help with VLookup function22 Aug 2005 12:47 GMT6
I'm struggling with a VLOOKUP function where I'm referencing a
particular postal code to a table and the VLOOKUP is returning
inconsistent results.
The syntax is: =VLOOKUP(C8,AZ1:BB1578,3)
what exactly are relational operators in Excel?  All math symbol?22 Aug 2005 12:31 GMT7
I am taking a test this week and one of the questions (which has been
supplied by the instructor) is a multiple choice with answers which do not
seem to be correct.  Are Valid relational operators: +   *  /  + or -,
or should they be:  "equal to, not equal to, less than, etc. as ...
#REF! help22 Aug 2005 11:14 GMT5
I copy and paste a web page into excel in sheet1
The page I import changes every day and is different
in size ,  I  delete all data in sheet 1 and copy and paste
the new web page in sheet 1.
Age with mont in decimal22 Aug 2005 10:31 GMT1
Please can someone help me.
I need formula to get age and month
I use the following, but get (example 53 0 instead of 53.0)
=DATEDIF(H22,(L22),"y")&"  "&DATEDIF(H22,(L22),"ym")&" "
#N/A! to be blank please.22 Aug 2005 10:02 GMT1
Hello from Steved
if no value it is returning a #N/A! please how to I have the cell blank
I know it is iserror but not to shore how to go about putingit in the below
formula.
 
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.