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
finding end of document17 Aug 2005 03:58 GMT1
Control end takes you to the end of the spreadsheet.  My problem is if I have
eliminated rows in the spreadsheet and then do control end it takes you to
the end of the document that was originally there.  I only want it to go to
the new end of document.  I work with large files ...
colors17 Aug 2005 03:41 GMT3
Can anyone help me with colors using IF statement.
Column A and Column B has numbers and Column C is a logical field to display
thumps up or thumps down with colr green or red.
I have Thumps Up symbol and Thumps Down Symbol from wingdings font. If
when editing a comment box17 Aug 2005 01:08 GMT1
in excel row the box jumps over 1000 cells up or down. why is it doing this?
this worksheet is autofiltered. does that have anything to do with it?
Adding Column in an Excel Sheet by Command17 Aug 2005 01:08 GMT1
I need to add Column in an already existing sheet automatically i.e either
programatically or with the help of a Macro
count and limit radio button selections17 Aug 2005 01:06 GMT1
I want to take a poll with 4 answer options displayed as radio buttons. I
want to tally the number of each option chosen for a specific question and I
also want one of the options to be limited to  the number of times it can be
chosen . i.e. Options are Definately, Sounds Good, ...
watermark17 Aug 2005 00:09 GMT2
how do i put a watermark such as draft and bkgrnd color on wksht
text has numerical values16 Aug 2005 23:34 GMT5
I have a row of 15 cells.  In some of these cells there is text.  The text
has numerical values such as V=1, M=0.5, and H=0.25.   There are usually
multiple combination of these text values and I would like to have a seperate
cell show the SUM total within a range.  I tried ...
How do I calculate total hours by rate of pay?16 Aug 2005 23:18 GMT1
I am using a "start" time and "End" time field then calculating total hours
by using the following formula =C2-B2+(C2<B2) which brings me the result for
total hours spent on any given project. How can I apply these result to a
rate of pay per hour to receive a total amount due ...
Running filters using a macro16 Aug 2005 23:09 GMT1
I have 50 worksheets in a single workbook which all pull data from the same
source document.  Being that I need to perform this function monthly, is
there any way to automate the filtering process using a macro?
Sumif with a twist?16 Aug 2005 22:58 GMT1
43975000    50
43865000    100
43828000    5
43828001    21
lookup and sum16 Aug 2005 22:48 GMT3
I have a worksheet on which I need a sum of data for accounts using info from
another worksheet if the data on the second worksheet is associated with a
given account on the first worksheet.
Example:
filter 15 worksheets so i can print all on one page16 Aug 2005 22:23 GMT1
i have about 15 worksheets that are pretty much set up with the same columns,
I need to be able to print a worksheet with just the info I need. Like Filter
it by number and then print. I am not worried about the headings. Can you
please let me know if this is possible. Thanks.
IF on the cell that contains it ?16 Aug 2005 21:35 GMT3
I actually don't know a lot about excel possibilities
I'm trying to make a "x" go through a line
something like
for A10 : =IF(A1=0,"x","")&IF(A10="x","","")
all worksheets have 2 descimals16 Aug 2005 21:14 GMT1
I can't clear my cells to general
Grouping16 Aug 2005 21:07 GMT1
I need a spreadsheet "grouping" command to expand and collapse differently
than the normal process seems to allow.
For example: A list of: Year, Quarter, Month, Day (for multiple years).  How
can I group this data to collapse to Years only, Year/Quarter only,
 
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.