| Thread | Last Post | Replies |
|
| EXCEL: How do I format a cell if value < 12 then show "LOW STOCK" | 20 Mar 2007 02:46 GMT | 1 |
Trying to format cells with conditions to show values; LOW, VERY LOW, etc. Thanks. CNS
|
| Can a cell value be set equal to a spreadsheet name | 20 Mar 2007 01:30 GMT | 5 |
I am attempting to set a cell in a spreadsheet equal to a title of another worksheet. Is this possible to do?
|
| How do I sort an excel spreadsheet based off of subtotals? | 20 Mar 2007 01:18 GMT | 2 |
I am trying to sort my spreadsheet based off of the subtotal information that I have just created. Is it possible to do this?
|
| Conditional format | 20 Mar 2007 00:59 GMT | 1 |
How do I highlight specific word occurances with a formula ?
|
| If Conditions | 19 Mar 2007 23:58 GMT | 2 |
well i want to create a frmula to calculate the incentive of my employees. the formula shoud be like this if the [CellXX] is "XX" then calculate the incentive through this IF formaula or
|
| Formula result not appearing in Cell | 19 Mar 2007 23:48 GMT | 1 |
After I have entered a formula into a cell, the formula appears not the result. When I check the formula it shows the correct result but does not appear in the cell. I have tried it with different formulas, even very easy ones, with the same results. This also does not happen ...
|
| Conditional Count (Array Formula?) | 19 Mar 2007 22:45 GMT | 3 |
I am trying to create a weekly summary page on a monthly missed pickup report that counts the number of times a missed pickup appears (given codes 1-3) for a certain driver (name) within a date range. This is what I've figured out so far:
|
| How can I count the number of cells that have conditional formats? | 19 Mar 2007 22:17 GMT | 4 |
I have a spreadsheet with lots of conditional formatting. I want to be able to count (per row) the number of cells that have conditional formatting (e.g. 6 out of 20 cells have met the conditions and font/pattern has been formatted) -> can I use some sort of countif or
|
| Need help with cells | 19 Mar 2007 22:12 GMT | 2 |
Hello, I need someone to explain to me how to make a row(s) diagonal. Now, not just the font, I have seen where the row was angled. I need to make a sheet with descriptions at the top & can not take up alot of room.
|
| Return unique data from a list | 19 Mar 2007 21:58 GMT | 9 |
Is there a formula to return a unique data from a list? For example, from A2:A2000 there are names of States (i.e. CA, TX, NY, NJ, etc) that are repeated. The list does not contain all 50 States and I need to isolate which of the 50 states are included in the list. Thanks.
|
| Conditional Formating working when data is entered later | 19 Mar 2007 21:40 GMT | 1 |
I'm new at conditional formatting and would like to know how to get the following to change if a line is changed Item ID Long Description Status Date Changed New 50100050 Drill, Pivot A
|
| Need help with cells | 19 Mar 2007 21:35 GMT | 1 |
Hello, I need someone to explain to me how to make a row(s) diagonal. Now, not just the font, I have seen where the row was angled. I need to make a sheet with descriptions at the top & can not take up alot of room.
|
| Zero's are showing up as negative numbers | 19 Mar 2007 21:32 GMT | 1 |
How can I format a cell to not show the result of a formula as being a negative zero, ie (0.00)? This does not happen with all of the cells only some.
|
| Direction combine several excel worksheets, drop down lists and da | 19 Mar 2007 21:06 GMT | 1 |
I need to find the best way to collect data from several users and then combine all the responses without just cut and past. The data collected would be in an excel sheet with drop down fields. I found I had to removed all the functionality added to the sheet to get just the ...
|
| insert column | 19 Mar 2007 20:31 GMT | 2 |
I have the new Excel 2007 and I need to insert a column to the left side of a column of cells that I have selected. How do you do this?
|