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 / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Advanced Custom filter Help!21 Nov 2007 21:48 GMT1
Can someone help me resolving this Custom filter issue that I m having on my
excel report? For some unknown reason I am unable to use the advance Custom
filter on the Contract end date column  of my reports that I download from a
Business warehouse. All that I am trying to ...
Count Font Colour21 Nov 2007 21:44 GMT1
I want a formula that will count the cell if a certain font colour exists.  I
have 3 fonts -  black, red and green font - and only want to count if black
or green exist.  
Helpless.
Rounding to the nearest 521 Nov 2007 20:51 GMT5
I need to round a group of numbers to the nearest 5...like 63 would be 65, 68
would be 70, 51 would be 50, etc.  Is there a formula for this?
mixed formatting in same cell with VBA21 Nov 2007 20:47 GMT4
Is it possible to have two different text formats in the same cell when using
VBA?
For example, I am using the textboxes from a userform to fill a cell:
WS.Cells(1, 1).Value = Me.txtFirst.Value & Me.txtMiddle.Value &
MsgBox text on several lines21 Nov 2007 20:17 GMT1
How can I start a new line in a MsgBox?
All the text I enter is written behind each other. It would be more
clear to have it in serveral lines.
like this:
can a mark be set that can be returned to?21 Nov 2007 20:10 GMT3
In a large worksheet (lots of rows and/or columns), can a mark be set in a
cell so you can return to that cell from another location in the worksheet?
Thanks
Auto Correct21 Nov 2007 19:52 GMT3
I am trying to label a column as 12/33 or 12 over 33 and excel keeps changing
the tag to Dec - 33 as in a date.  How do I remove auto fix for this cell so
I can depict my divisor problem?
Calculate percent of a total within a cell21 Nov 2007 19:35 GMT4
I have several columns of data created from a pivot table. I want the percent
of total for each row, and have been inserting a column next to each number
to perform my calculation, and it seems like there should be an easier way.
Is it possble to have excel do the calculation ...
Need help! How to give a drop down cell a math value?21 Nov 2007 19:31 GMT1
I'm trying to create this chart to be able to automatically calculate total
income using a drop down cell.
        COL C                                 COL F                     COL G
Choose from Drop Down    Stated Income    =  Total
Help!! How do you give a drop  down a Math Value21 Nov 2007 19:29 GMT2
I'm trying to create this chart to be able to automatically calculate total
income using a drop down cell.
        COL C                                 COL F                     COL G
Choose from Drop Down    Stated Income    =  Total
Formula to select every third cell in a very long column of data?21 Nov 2007 19:17 GMT2
Is there a formula or an easy way to select/highlight every third cell in a
very long column of data?
Signature

Thanks,

letters for numbers21 Nov 2007 19:10 GMT2
all i am trying to reference worksheets using the INDIRECT function.
e.g. Sheet1, Sheet2, Sheet3
i am using formula = indirect("sheet"&a1&"BJ102") to refer to one of the
sheets. A1 will have either 1, 2, or 3 representing the sheet.
How do I copy a combobox to many cells with relative reference?21 Nov 2007 18:58 GMT1
I have made a combobox form control and want to copy it to multiple cells,
the problem being the cell link reference is absolute by default and not
relative. Is there a quick way to copy comboboxes and make them relative
references instead of absolute?
Formulaed cell response varies from computer to computer21 Nov 2007 18:37 GMT3
I am using an excel file that I've placed on a shared server folder. I
created the original file, Three other people have access to the file. When
information is enter into the cells from two of the three they get an error
message "$names" in the formualted cells. But, if I open ...
Use dual monitors in Excel and also have multiple worksheet panes?21 Nov 2007 18:32 GMT1
Not sure if this is possible in Excel 2003.
I'd like to set up my screen to have multiple quadrants for seeing and
working on multiple worksheets.  Is this possible, and how?  Can Excel be
automatically configured to always launch in this mode, as opposed to a
 
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.