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
IF text statements01 Nov 2005 00:44 GMT6
Please help!
I have a Pulldown menu in H8 with these choices: "Click Here to Rate",
"Requirements not met", "Requirements Met"
I need a formula or function statement that for this:
Excel worksheets01 Nov 2005 00:01 GMT2
I would like to know how big a worksheet is please
12 digit code sorting31 Oct 2005 23:21 GMT5
I have a list of 90,000 12 digit records.  I need to count the number of time
the fourth and fifth digit are 1, 8 (or 18) and, if possible, filter my
spreadsheet to hide to rows not meeting this criteria.
Mark
Sum YTD Budget31 Oct 2005 22:16 GMT4
I have a worksheet where columns alternate between budgeted and actual income
by month (e.g. Col A = January Budget, Col B = January Actual, Col C = Feb
Budget...).  
I need to add a year to date sum, for both budget and actual, which will
Radio Buttons31 Oct 2005 22:08 GMT6
I am using radio buttons (from the control toolbox) for a survey.  
How do I hide the text "true" and "false" from the properties of the radio
button so they do not show up when I print the survey?
Bethie at CLG
Function or VBA Help Needed31 Oct 2005 22:08 GMT4
I am trying to do some automation of cells and have an IF Function
started.  As I continue to build this automation, I am wondering if a
VBA solution is better?  Any help/suggestions would be appreciated.
Current function in all ColB cells starting at row B2 (B1 is empty on
Can I apply Cond. Formatting to a Formula result?31 Oct 2005 21:31 GMT2
Let's say $M3 contains a formula J3/I3 which returns a percentage. I want the
row to color if the resulting percentage is over 100%.
Signature

Thank you,

Sum box at bottom toolbar of Excel31 Oct 2005 20:59 GMT4
I used to have a box in the bottom toolbar of my Excel spreadsheets that
automatically summed any cells selected on the worksheet.  How do I turn that
feature on/off?
Text to columns delimited by carriage return31 Oct 2005 20:35 GMT2
I have a column where each cell has values that are separated by a carriage
return, and I want to do a Text to Column action delimited by the carriage
returns.  What is the best way to do this?
DIAS.LAB function poblem31 Oct 2005 19:23 GMT1
I have to calculate the days between two date. But between monday to
saturday. The DIAS.LAB function calculate the total days between monday and
friday and that is my problem, I have to include saturday.
I really want to know is there another function or how can resolve this
GO TO31 Oct 2005 19:16 GMT2
Is it possible to create a Macro which when activated will move the active
cell to the equivalent cell in the same row in a different columns.
E.g. If the user is in cell A25 if the macro is run the user will be moved
to cell AA25
Address and Vlookup31 Oct 2005 19:06 GMT5
I have a workbook which contains depreciation schedules for various assets.  
I need to create a summary schedule that looksup the monthly depreciation
expense for each asset.
Each individual asset's worksheet is layed out identically, with the
Begins with as criteria in function31 Oct 2005 18:33 GMT8
All,
I'm trying to do a sumif.  For the criteria I want to sum anything that
begins with a value in cell A7.  So my formula looks like
=sumif('Worksheet2,!$I$3:$I$586,A7*,'Worksheet2,!J7:J590)
Monthly Totals31 Oct 2005 18:22 GMT2
I have the following formula on my worksheet
=SUMPRODUCT(--(Closed!$B$1:$B$5000="Maxwell
R"),--(MONTH(Closed!$W$1:$W$5000)=10)). It works great for cells that have a
date in them, but some of the cells are blank. This is causing a #VALUE
I Need a formula to evaluate a cell with + or - values31 Oct 2005 15:41 GMT6
The formula in Cell A1 evaluates the values in B1, C1, and D1.  B1 can be
blank or have numerical values either positive or negative.  C1 always has
numerical values but can be positive or negative.  D1 is either blank or has
a text value of "Final".  The value of A1 changes ...
 
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.