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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Re: Weekly Date Function(s)12 Sep 2006 01:14 GMT2
Guys:
What I need, I'm sure some body out there knows the answer! If you do,
please, please chime in! I want to build a weekly task schedule based of the
days of the week (Mon - Fri).
Preserve negative numbers in following macro12 Sep 2006 00:57 GMT2
Ron gave me this Macro which does exactly what I want, except for one
small point I have just noticed.
////////////////////////////////////////////////////////////////////
Sub Progressive_Error()
Match Lookup question12 Sep 2006 00:45 GMT8
Hey everyone, I am not sure what the best way is to handle this so I thought
that maybe some of you could help point me in the right direction.  In my
worksheet (Sheet1)  I have the following data:
Sheet1:
Text format & number format11 Sep 2006 23:48 GMT9
I have a cell that is formatted with a macro to change the number 10 to
+10.0000
I would also like to add a text letter of g to this same cell so it
reads +10.0000g
I want to set up a cell where 1=3 so when I insert 2 it will = 611 Sep 2006 23:41 GMT8
I am setting up a Excel worksheet for accountibility and what to simplify it
by having one number in a column equal another number in the next cell. I am
using Excel 2003
Find part data in row range?11 Sep 2006 23:31 GMT1
Hi.  This seems so simple in my head, but I can't figure it out.  I have a
sheet of data brought in from an access memo field.  I've parsed the data
into rows, but it's mixed and I'm trying to get it into correct columns on a
separate sheet.
My formula's answer is calculated, but disappears11 Sep 2006 23:25 GMT4
I have an excel document here where I have the same formula in a column of
boxes.  2 of these boxes look blank, but when highlighted you can see the
answer - but only highlighted.  How do I fix this?
Formulas11 Sep 2006 23:23 GMT3
I regularly copy worksheets on from month to month then just change the data
not the formulas. This time, although the correct formula is in the cell, the
formula doesn't work. Any ideas please?
Inserting a space after a comma11 Sep 2006 23:20 GMT2
I have a string of text with commas and no spaces.  
Example:  Sales,Planning,Systems
What function do I use to insert a space after each comma?
How do you compare 2 different spreadsheets for duplication?11 Sep 2006 23:16 GMT1
If you have 2 different excel spreadsheets, they have the same column
headings and you want to compare the 2 (they are both lenghty 279 lines) to
make sure there is no duplication -- what would be the best and most
efficient way to do this?
Autosum and Manual Sum not working11 Sep 2006 23:06 GMT6
I want to simply add several rows in a column - all containing currency
formatted cells.  No matter what I do the total always appears as "0.00".  My
formula seems pretty straightforward:  =SUM(G7:G135).   I've researched this
for the past 2 hrs. and even had our IT people ...
formula for taxes11 Sep 2006 22:33 GMT7
In need a formula that will figure out someon'es federal taxwithholding on a
person weekly payroll:
Example:
B4 is total wages per week (with overtime included), C4 is % of what they
Change second digit from 4 to 611 Sep 2006 22:01 GMT6
Hello from Steved
I have 5401 to 5499 and need it to be 5601 to 5699 please
If there a formula I can use to acheive the above.
Thanks
sparklines for excel11 Sep 2006 21:53 GMT1
Hi NG,
Sparklines are tiny charts, a new invention of the info design guru Edward
Tufte. You might be interested to check out our sparkline implementation for
Excel:
how to i add the first six values of of a row when in various colu11 Sep 2006 21:51 GMT5
How do I add the first nonzero values of a row when they appear in various
columns?
I only need to add the first six values that are nonzero but these appear in
various columns throughout my table.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.