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
COUNTIF criteria24 Sep 2006 20:11 GMT9
I have the following data:
70
80
71
Totaling pre-defined groups?24 Sep 2006 20:00 GMT5
I am not an excel wiz and I have a problem that is hard for me to solve.  I
would like to total the # of units for a defined height range.  For example:
how many units are within the height range of 38-44? or 46-51? I would like
to have a simple macro that references cell addresses ...
Sorting24 Sep 2006 19:58 GMT7
I have one column with data but some rows are blank. Is is possible to set up
function like "advanced sort" where the data from the column that isnt blank
is copied to another column then sorted, but so that if any items are altered
in the first column the second column ...
Excel 200 crashes24 Sep 2006 19:49 GMT1
I can open excel spreadsheets no problem. As soon as I try to change the
font, or the font size, it crashes. Anyone have any ideas?
Thanks
Chart or macro problem24 Sep 2006 18:55 GMT1
problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for
each student e.g.  i will end up with 300 seperate excel files prefably
Exam Marksheet - Grading24 Sep 2006 18:33 GMT1
Please help me with a formula for my marksheet.
The exam grading is A, B, C, D and E.  E is a failure
To pass the overall exam, a student must :-
Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
Help with conditional formatting24 Sep 2006 17:25 GMT2
How would you write this formula to show in red?
If F1 = 5 OR O1 = 5000 then conditional format these cells in red.
B3,B7,B8,B13,B14,B17,B19,B20,B21,B22,B23,B24,B28,B30
Thanks in advance!!
How to display month only for date format?24 Sep 2006 14:59 GMT2
Does anyone know how to display the month only for date format?
such as 26 Sep, 2006, it displays Sep only.
Thank you for any suggestion
Eric
self-sizing adv.filter criteria range24 Sep 2006 13:30 GMT3
I'd like to have an advanced filter which does not need to be told, manually,
how high the criteria range needs to be for a filter.  In other words, I want
a user to be able to enter either one line of data, or two lines, or maybe
more.  If I put an adv.filt on a range for three ...
Graphing problem. Please help.24 Sep 2006 11:54 GMT1
I have a graph with columns and lines on 2 axes.  I'm using the format
"Line-Column on 2 axes" but i want specific data sets presented on
lines and others on columns.
Can anyone tell me how you select whether a data source appears as a
Repeated shading of rows??24 Sep 2006 10:28 GMT8
I want to create simple planner/calendar:
(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.
Automated printing24 Sep 2006 09:27 GMT2
I have workbook with ten tabs, I would like to link check boxes on the first
page to printing. Is it possible to set a macro linked to a button to look at
the check boxes, then only print tabs for which the check boxes relate to.
Editing an excel spreadsheet with the new data in colored text?24 Sep 2006 07:52 GMT1
I would like to know how to edit data in a excel spreadsheet and have the new
data go in as colored text the same way that editing is documented on MS
Word.  
I have a very big spreadseet to edit and I don't want to have to bold the
duplicates with a twist24 Sep 2006 07:09 GMT3
I have two lists of e-mail addresses - I want to compare them (I've got them
on the same spreadsheet right now) if column "a" has an e-mail address that
is in column" b" I want to delete column "a's" cell.  Is this possible?
Thanks
Very confused....24 Sep 2006 06:44 GMT1
Can anyone help me with this?
Every time I start Microsoft Excel on my PC, a popup box starts saying
"Starting Windows Installer".  Then a short time after, another popus
box displays saying "Installing Microsoft Frontpage".
 
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.