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 / General Excel Questions / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Countif & Offsets15 Feb 2008 21:16 GMT1
My formula is like that as followed:
=COUNTIF(OFFSET(AF:AF, 11,0,128,1),"TRUE")
And I got a result as "0". Then I evaluate the formula, it showed
"Countif($AF$12:$AF$139, "TRUE") ". This is exactly what I want.
Sort by color "NAME?" error15 Feb 2008 20:54 GMT5
I have tried to sort by color using a VBA. It was successful on one
spreadsheet I am working on, but not on another. I keep getting the error
message "NAME?", and I don't know why. Any help would be appreciated.
Thank you
Add strikethrough button to ribbon15 Feb 2008 20:53 GMT1
In previous version of Excel, I could add a button for "strikethrough" to the
toolbar (next to the bold etc buttons). How do I do the same thing in Excel
2007 with the ribbons.
Formula Problem15 Feb 2008 20:44 GMT2
I want to add a group of numbers.  If that sum is greater than 0, I want the
sum to be multiplied by a number.
I need help if anyone can tell me how.
Thanks.
Trendline Equations15 Feb 2008 20:20 GMT4
Does anyone know how to extract the trendline formula from a chart
object so that the formula is viewable in a cell?
Lookup returning value from antoher column in same row (Text!)15 Feb 2008 20:19 GMT3
I am dealing with two worksheets in a large workbook. For the purposes of
public discussion, let's say:
Sheet One has a column listing all the characters on The Wire, and a column
that is blank or has a description of any beef that the row's character has
formulas & functions15 Feb 2008 20:16 GMT1
I have product items I would like to list in column B rows 3-33, as I add the
product name or number I would like the price to be generated in another
column. How can I do this
Cell value15 Feb 2008 20:08 GMT1
I have a value in cell A1 of 1
now i want to run various macroes
then i want the value to A1 to increase by 1 to 2
then run the same macros
Drop down List w/ Values Pop Automacailly when choose entry from l15 Feb 2008 20:04 GMT8
I want to make a drop down list.
I want to make a list w/ a drop down by in a closed different workbook not
open workbook. I do not want to create this drop down menu in the same
worksheet but in a different workbook.  
Program Security15 Feb 2008 19:59 GMT2
I have an EXCEL file which I use for my own use, but I want to 'loan' to a
few colleagues at work. I want to keep some control over it - my main worry
is that people will copy it, move jobs, take it with them etc., and before
long it will have spread. The program has some ...
print spreadsheets only if date has been typed onto it.15 Feb 2008 19:47 GMT1
I have a workbook with mulitple identical worksheets for evaluations. 24 to
be exact. Trying to make it easier for the evaluator to use a macro to print
only the worksheets that have been typed on. For example, on one day you
might do 12 evals then on the next day after opening a ...
NETWORKDAYS formula15 Feb 2008 19:43 GMT5
I have a spreadsheet with the NETWORKDAYS formula on it.  It does work
perfectly on my computer, but when I use the  exactly same file in other
computer it does not work.  The answer I get is #NAME?.  If I do the
deduction of the same 2 dates just with the simple formula C2-A2 I ...
coverting h:mm to decimal15 Feb 2008 19:42 GMT2
I have a spreadsheet with several "time" columns.  I then bring this data to
a pivot table.  Before doing that, I have another column set up that converts
h:mm to a decimal format (i.e:  3:30 convert to 3.5).
I do this conversion with the following formula:  
Converting Standard Time into Military Time15 Feb 2008 19:34 GMT3
I have a column of standard times (example 6:50pm) that need to be converted
to military times (example 18:50); is there a formula or formatting feature
that can convert the entire column?
Converting Standard Time to Military Time in Excel15 Feb 2008 19:30 GMT2
What function can be used to convert a column of Standard Time to a column of
Military Time in Excel?
Is it a formula or formatting?
 
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.