| Thread | Last Post | Replies |
|
| Split Missing | 04 Mar 2008 21:08 GMT | 2 |
I previously only needed a horizontal split in my worksheet, now I need the vertical, but it is missing. How can I get it back?
|
| need help making a formula | 04 Mar 2008 19:25 GMT | 3 |
i need to make a formula that will show a commission rate of 5% sales over 15,000 with a 3% sales commission for lesser sales. Could someone please help me with this.
|
| Specific Cell | 04 Mar 2008 19:24 GMT | 1 |
I can not remember how to make a specific cell within a spreadsheet to make it very easily identifiable.
|
| I need to find specific a value across a row using IF(AND | 04 Mar 2008 19:01 GMT | 5 |
I have searched through the archives and threads and thought I found the solution but to no success. I want to find "DC Office" across cells AW2:BK2, if one of those cells contains that text I need it to populate BL2 with "Washington, DC"
|
| automatic formatting | 04 Mar 2008 18:59 GMT | 5 |
I created 3 spreadsheets with pricing info. I enter prices on a main spreadsheet and the other two are automattically changed by adding or subtracting certain amounts from that main sheet. How can I automatically bold or highlight the cells with changed value? All
|
| Formula to check against a list of valid values | 04 Mar 2008 18:51 GMT | 3 |
I am importing data into a spreadsheet. I want to check whether certain columns contain valid data. So if columns A and D, for instance, need to be "character", I would want to check that the value in any given field is A-Z or a-z. Is there a quicker way than using "OR" and ...
|
| Date conversion | 04 Mar 2008 18:50 GMT | 4 |
How can I convert dates from 20020113 to 1/13/02?
|
| enetering fed ex tracking # in cell | 04 Mar 2008 18:42 GMT | 2 |
I cannot find a way to enter the 13 digit tracking # in a cell, I have tried custom, general - it always replaces the last 6 #'s with zeros? Any advice?
|
| i have scanned a worksheet to excel but i can't figure how to use | 04 Mar 2008 18:38 GMT | 1 |
i'm new with excel, and just a novice computer person. i have scanned a work sheet to excel,saved it but i can't figure out how to enter any figures or words on it thanks for any help
|
| Month Conversion in SUMPRODUCT | 04 Mar 2008 18:37 GMT | 10 |
I'm trying to count the number of rows in a worksheet list that have two conditions. One of the rows is formated as a date and I need to convert that to a month number prior to the '=' sign in that condition. I tried this:
|
| Sum select cells based on date range | 04 Mar 2008 18:21 GMT | 2 |
Here's the table I have Date # Days Open 02/01/2008 3 02/01/2008 2
|
| Help with a formula | 04 Mar 2008 18:02 GMT | 10 |
In one section of my form there are 2 columns: A and B. Cell range B1:B7 contains a series of different numerical values associated with the corresponding cells in cell range A1:A7. Form users will choose the value they want from column B by typing an "x" in the corresponding ...
|
| Find and Match | 04 Mar 2008 18:01 GMT | 1 |
This is in a previous posting and what i am trying to do. Let's say you have these numbers in A1:A1300 1 3
|
| Email (LDAP) data download into a single Excel cell - data separat | 04 Mar 2008 17:14 GMT | 1 |
I hope someone could guide me. I have downloaded email names from outlook and imported in Excel. unfortunately all the names are pasted in a single cell e.g. smith, john(dept A); kohl, nancy(dept B);................,turner, ted(dept X);
|
| Value separation and then adding | 04 Mar 2008 16:59 GMT | 2 |
Here is what I would like to do: If any cell in this list k10,k36 = "R-C" the take the corresponding cell in e10,e36 and add as a total in e37
|