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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
time table12 Dec 2007 22:49 GMT3
hi my name is Muhammad Habib.i wana make a time table in excel.but i am
confused.i make in this way that when i change the one entry of timming of
coledge the other entries are changed regardingly.can any person help me?
regards,
calculating a special formula12 Dec 2007 21:44 GMT1
(D2) holds the customer's target price, (F2) holds the price at which
the company will sell to the customer, the formula in (F2) is based on
the lowest price from 5 different vendors: (I2, K2, M2, O2, Q2), after
this calculation, if (D2) is higher than (F2) then I want (F2) to
cell function12 Dec 2007 21:43 GMT4
I am not sure what I am doing here but my question is: I want a cell that
will receive a variable number from its formula to show the number in red if
it exceeds a certain value. If that is to difficult than I need the cell to
display inop or something like that
Auto fill cell addresses by not 112 Dec 2007 19:35 GMT2
Is there a way to auto-increment the cell address in a formula by an
increment other than 1. For example by 15:
=Fubar(A1,A2)
=Fubar(A16,A17)
Protection and Filtering12 Dec 2007 16:55 GMT4
Have formulas in an Excel sheet. Protected the sheet to avoid changing
formulas by mistake or deleting them.
The problem now is that Auto Filter doesn't work!!
Any solution??
VBA Script Question12 Dec 2007 16:46 GMT1
Below I pasted part of some script.  On the last line of the script I
have
"WEDNESDAY PICK-PUT-VAS.xls'!Sheet4.hide_unhide_rows".  The script
only works if the file name of the worksheet is the same as it is
Enhanced Proper Case12 Dec 2007 15:38 GMT7
Enhanced Proper Case
I am looking for a macro to enhance the "Proper" case function or
code.
What I would like to do is take a cell entry and change it to proper
How to make a heatmap in Excel?12 Dec 2007 15:10 GMT2
I would like to construct a heatmap in Excel. In other words, a figure with
two axes and each cell has a certain color based on the value for that cell
(e.g., the higher the score, the darker the color). In example of such a
figure can be found at:
Creative Sorting with Letters and Numbers12 Dec 2007 15:00 GMT3
We use Excel 2003 and sometimes have a need to sort data that includes
figure references with the section and figure indicators in one column
(Section B, Figure 1 would be "B-1" in that cell).
When we sort, however, we find that figure B-10 will come before B-2. We
Multi-row conditional formatting help12 Dec 2007 13:43 GMT1
I want to format a row based on whether column E is greater than column
D. I want this conditional formatting to apply to 7000 rows.
I can make the row change colour for the first row, which is fine, but
when I highlight all the rows and then select CF, and then click on OK,
Is it a bug?12 Dec 2007 12:59 GMT9
ROUND(((2226-123.36-39.34-303)-1600)*0.05, 2)  == 8.01
password protection12 Dec 2007 10:05 GMT12
is there any software/ technique i can use that will password protect excel
2003 files that cannot be hacked.
we have software for forgotten passwords recovery (which is great for the
right reasons and very bad for others.)
How do I set up a normal graph?12 Dec 2007 06:39 GMT2
I want to set up a simple demand and supply graph in Excel.
All the points are given and i need not to fix any formulae for my data
sets. All I want is to get a graph with x-axis (being quantity) and y-axis
(being price in pounds).
how do I change the lerrers in the header of each cell to a name?12 Dec 2007 00:18 GMT3
I am trying to create a spreadsheet that names  or at least name the
firstcell so that it will be present even when I scroll down . is this
possible?
Inventory/Stock Control12 Dec 2007 00:05 GMT3
Does anyone know of a free, simple inventory control spreadsheet/template.
All it needs to do is have a list of items (up to 100) with a stock on hand,
transfer in and issue out option. Obviously, the transfer in and issue out
out must update the stock on hand and then self zero.
 
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.