| Thread | Last Post | Replies |
|
| time table | 12 Dec 2007 22:49 GMT | 3 |
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 formula | 12 Dec 2007 21:44 GMT | 1 |
(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 function | 12 Dec 2007 21:43 GMT | 4 |
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 1 | 12 Dec 2007 19:35 GMT | 2 |
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 Filtering | 12 Dec 2007 16:55 GMT | 4 |
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 Question | 12 Dec 2007 16:46 GMT | 1 |
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 Case | 12 Dec 2007 15:38 GMT | 7 |
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 GMT | 2 |
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 Numbers | 12 Dec 2007 15:00 GMT | 3 |
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 help | 12 Dec 2007 13:43 GMT | 1 |
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 GMT | 9 |
ROUND(((2226-123.36-39.34-303)-1600)*0.05, 2) == 8.01
|
| password protection | 12 Dec 2007 10:05 GMT | 12 |
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 GMT | 2 |
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 GMT | 3 |
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 Control | 12 Dec 2007 00:05 GMT | 3 |
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.
|