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 / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
from a cell which has numbers how to get it spelled13 Jul 2006 20:21 GMT2
please somebuddy help me with a formula from a cell which has 3564 in numbers
and in the other I want in words like three thousand five hundered and sixty
four
Dependent Lists in Excel13 Jul 2006 20:15 GMT14
I've created a dependent list in Excel using Data validation. The first
list is independent and the second list depends on the first list. I'm
facing one problem in this. After selecting a element in first list and
corresponding element in second list, if I want to change the first ...
calculating a 2-log drop13 Jul 2006 19:46 GMT2
Hey all, quick formula question:
For explanatory purposes, Ive got a number in Cell A1 that is a
patient's baseline viral load, and in Cell B1 I've got the patients
viral load at 12wks of treatment.  I am having trouble figuring out how
Use multiple criteria with COUNTIF:  between dates and not blank13 Jul 2006 19:21 GMT7
Using Excel 2003 I need to count rows where the date in column A is in a
particular month and year and column G is not blank.
Why can't Conditional Formatting do other formating such as number13 Jul 2006 19:03 GMT3
I want to set the number of decimal places for a cell based on a condition in
another cell.  You cna't do that in conditional formatting.  Is there another
way?
----------------
Sorting rows13 Jul 2006 18:51 GMT3
I have a spreadsheet that has alternating gray/white row colors. When I sort
the spreadsheet by rows, the colors sort as well. Is there a way too sort
without the colors in the rows sorting as well. I creates problems with the
format of the spreadsheet.
worksheets13 Jul 2006 18:36 GMT2
How do I change the "zoom" on all the excel sheets at one time?
How Do I add/sum the numbers in one cell...((More Info Below))13 Jul 2006 18:20 GMT1
Hello.  What I'm doing exactly is Let's Say A1 I have this:
1,5,8,9,10,12
And Now in A2 I want to put the sum of these numbers...
So I want to add the numbers even though they consist of commas.
Average Time Difference13 Jul 2006 17:58 GMT4
I have a deadline time entered as 10:11 in B7. In c7 through s7 I have
the actual times, i.e. 10:06. In most instances the deadline was met,
but in a few it was not. I'd like to have the average time variance
between the deadline and the actual. I'm not very sophisticated in
Macro to capture worksheet names13 Jul 2006 17:56 GMT2
I have a spreadsheet that gets clobbered from time to time by data entry
folks.  Part of the problem is a macro that can't find a specific worksheet
because the name may have been changed.
Is there a way, using a macro that can look at each worksheet and capture
macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting13 Jul 2006 17:48 GMT1
hey, for some reason this macro is taking 30+ seconds to perform a fon
change and autofit on the 2nd sheet in this workbook. sheets 1 and 3
are almost identical (in rows and columns) and those happen in about
second or less. i am not sure why the 2nd sheet (ReArranged - No
How do I get ONLY new info from 1 Worksheet to another automatical13 Jul 2006 17:45 GMT6
I am using Excel 2003, Windows XP Pro SP2
I have a Multiple Worksheet file
I do not know how to create or use Macros, but I am fairly good at using
functions.
cells visable and following. Not freeze13 Jul 2006 17:40 GMT2
Hi. How can I set a group of cells to follow my scrolling? You know the sort
of thing. An information box. When I scroll left or right the group of cells
would always be in view.
Here's a good one!13 Jul 2006 17:28 GMT4
I am trying to split loan payments between principal and interest amon
various sources, however due to rounding the total principal an
interest exceeds the total payment.  What is the easiest way to adjus
either the largest principal or interest field based on which type i
Search column for value and return TRUE or FALSE13 Jul 2006 17:07 GMT8
I function that would search through column of text values (range with 1
column) and return TRUE if column contains value given as criteria or FALSE
if there is no such value in given column
For example i have range A1:A10 and i want to find out whether this range
 
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.