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 / New Users / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Differences between Excel 2003 & 2007?27 Apr 2007 20:31 GMT5
I'm taking a course in spreadsheets application.  The class uses a
textbook on Excel 2003 & all the college computers also use that
version.  So I ordered the software for Excel 2003 over the internet
but instead received the 2007, with the explanation that the 2003 is
Average27 Apr 2007 20:00 GMT10
In cells G21 and J21 are grades calculated from another sheet in the same
wrokbook.
The grades are NOT numbers but letters: E+, C, D+, ..... (letter system)
In cell K21 i want to have the average of the two cells G21 and J21.
Calendars27 Apr 2007 19:35 GMT2
Hello Folk's,
Is it possible to insert a calendar in a specific cell.
For example, if cell d4 requires a date, I would like to know if a calendar
could be activated when cell d4 is activated that allows the users to select
If condition27 Apr 2007 19:28 GMT3
I have 2 workbooks: wkbook1 and wkbook2
Each workbook has only one column (column A) with content.
There are 10 rows with numbers in them. Sometimes these rows will vary
depending on the updates. I.e. wkbook1 may have 5 rows of content, but
text list27 Apr 2007 18:26 GMT2
I have the following list:
AAA
AAA
AAA
solver cannot take "if "function?27 Apr 2007 17:45 GMT4
I use solver to calculate the minimum with the following equation
     x1+n1*y1+o1*z1+x2+n2*y2+o2*z2=Min!
shipping costs should only be included of the shop is used!, therefore a if-the function is used:
Cell x1(and x2) contain the function if(or(n1>0;o2>0;10;0) thats adds the ...
Conditional formatting macro27 Apr 2007 14:57 GMT1
Help.
I would like to know if it is possible to have a macro that changes
the colour of a cell dependant on the number or text within.
eg
Excel Worksheets collection27 Apr 2007 14:52 GMT1
Greetings, all:
I am in the midst of teaching some C# and I do not have Excel in front of
me, but a student posed a question about how to refer to a given worksheet
inside a workbook.
saving a workbook to disc27 Apr 2007 14:12 GMT4
I am trying to save a workbook to a disc so that I import it too my laptop at
home. Am using Excel 2003, and I cannot find options for saving to a disc,
just insstructions to 'save"
Calculating Week Numbers27 Apr 2007 13:25 GMT10
One of the fields in an Excel timesheet I use calculates the current week
number.
The formula is :
 =ROUNDUP(((Q9-DATE(YEAR(Q9),1,0))/7),0)
Excel: Remove characters from cells using wildcards27 Apr 2007 12:45 GMT8
Can you anyone help me with this problem please?
I have a column of data like the one below and I would like to remove
the the front part, (x) from the cell, but I don't want to remove the
parts in bracket that come later in the cell, for example
How to add values?27 Apr 2007 11:22 GMT1
I have a long list in excel where the Number can occur in several different
positions with diffrent Value.
I want the Number to only occur once and the Value of the different
positions added.
stoping duplication in drop down list27 Apr 2007 08:24 GMT3
Im using a simple loop to check part od a column an add thecontents of its
cells to a dropdown list. The code is below
rowno = 9
Do Until IsEmpty(ActiveSheet.Cells(rowno, 2).Value)
sumif with >or< condition27 Apr 2007 07:45 GMT8
I have 6 numbers in cells a1..a6.  Some are positive and some are negative.
I would like to total up only the numbers that are > 20000 or <-20000.
This formula works for >
=SUMIF(A1:A6,">"&20000,A1:A6)
CSV file into Excel....still need help please !27 Apr 2007 05:39 GMT1
Unfortunately I lost the info I had previously
gotten
which was to make a change somewhere IE, Excel or
? and then when you choose CSV as your file type
 
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.