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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Converting ASCII Into Excel, any Ideas?27 Sep 2006 19:42 GMT3
I need to convert Data from Sprint that comes in either a PDF or ASCII. I
need to convert those to and put them onto an EXCEL spreadsheet. Anybody know
how to do that?
Automatic updating for text boxes used on Charts27 Sep 2006 19:40 GMT1
One of my supervisors has asked for me to design a new chart for an ongoing
project (that will be updated weekly), where a formula based on one only
column of data  (that is linked from another spreadsheet) is reflected on a
Chart (currently) by creating text boxes and typing in ...
Tab Function in Protected Worksheet27 Sep 2006 19:37 GMT1
I'm using Office 2003 and have a worksheet protected with the ability to
enter data in a selected table. How can I get the Tab function to work in the
data entry section of the worksheet?
Thanks
COMBINE COLUMNS27 Sep 2006 19:09 GMT6
How do I combine two columns (of items numbers) without having any
duplications on another worksheet?
I can't find the Assign Macro command27 Sep 2006 19:08 GMT3
I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?
Help with formula27 Sep 2006 18:59 GMT7
=OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in
cell F1 is being read as text (I think) and I need it to read as numerac.
Example: The cells that I need are selected and conditional formatted to
change to red if these criteria are met. If a 5 is in ...
conditional formatting27 Sep 2006 18:46 GMT5
i am trying to have a row of cells be a certain color if one particular cell
is >0, for example.  is there a way to do that?
thanks!
eric
Macro - can't find27 Sep 2006 18:43 GMT2
Upon opening a spreadsheet I get error messages about enable/disable macros
but I can't find any macros in the file.  Why is this happening.
What is the best way to set up a meal calendar for volunteers27 Sep 2006 18:28 GMT1
My office has an employee in the hospital . We have several different
organizations that are going to do meals for the family What is the best way
to set up a meal calendar?
Need another Formula Help for Copying Info Between 2 Pages27 Sep 2006 18:10 GMT4
I need to know what formula i would use for this following situation.
I have a Excel Sheet in Excel 2003
First Sheet says: Credit Card Setup
Second Sheet Says: Order Form
print excel with formulas and answers together27 Sep 2006 17:52 GMT1
can anyone help me if i want to print out my worksheet that will contain both
the answer and its formula together on a single page?
I have "page 1" across my spreadsheet. How do I get rid of it?27 Sep 2006 17:30 GMT1
I don't know how the statement "page 1" got here but I don't want it or need
it. ????
simplify this formula??27 Sep 2006 17:28 GMT6
=IF(ISBLANK(OFFSET(A8,0,MATCH($H$6,B$7:$G$7,0))),"",IF(OFFSET(A8,0,MATCH($H$6,B$7:$G$7,0))>=OFFSET(A8,0,MATCH($H$6,$B$7:$G$7,0)-1),"OK","Check"))
The boss says it's "too complicated"
The boss also doesn't like errors returned, so the boss wants errors
trapped.  Hence its being ...
List of all "Date Formats" from Excel27 Sep 2006 17:26 GMT4
How can I get the list of all "Date Formats" from Excel?
Something like this:
dd/mm/yyyy
mm/dd/yyyy
Index Match Match?27 Sep 2006 17:04 GMT4
This one just seems to stump me!
What I have in the cell is:
=INDEX(Sheet1!C2:C1000,MATCH(D104,Sheet1!A2:A1000,0),MATCH(Sheet3!E104,Sheet1!B2:B1000,0))
and it gives me the eternal #REF!
 
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.