| Thread | Last Post | Replies |
|
| duplicate name help please | 20 Feb 2008 15:52 GMT | 9 |
Hello group I have a spreadsheet that calculates the players Position, Total score, Played games, and Number of wins, from a MAIN sheet. Positions Names Total Scores Played Wins
|
| Restricted Cells | 20 Feb 2008 15:44 GMT | 1 |
I have a spreadsheet with the following characters - some columns are inaccessible for input, some cells are protected, there is a section of the spreadsheet that I can't even click the mouse it jumps to the next available cell. Some columns have a weired color - Pink!. Basically it
|
| Disallow cell data entry which autopopulates | 20 Feb 2008 15:34 GMT | 4 |
I have a macro which autopopulates a date/time stamp (lets say,cell B1) when a selection is chosen in (A1). This time stamp can be changed and I don't want anyone to be able to change it. I want to make the cell where the user can click the cell, but when they try to type, nothing
|
| excel formulas | 20 Feb 2008 15:01 GMT | 19 |
How would I do the following: A+B = C, if C = 10 then D = 1 if C = 11 then D = 2
|
| If statements | 20 Feb 2008 13:18 GMT | 1 |
I am trying to insert a result of an if statement into a column that has some blank spaces but also has some correct values the same column. I want to build a Macro that would include this statement. How do keep from overwriting the cells that have the appropriate values when I ...
|
| Lookup a criteria from another sheet | 20 Feb 2008 11:48 GMT | 1 |
Good Day I what to lookup a crieria in col A and it gives me what is in col B. Col A Col B Repair & Maintenance 13,500.00
|
| copy of certain rows | 20 Feb 2008 04:53 GMT | 2 |
I have a matrix (16071 * 40), and i want copy or cut rows 3 to 43 and 367 to 408 and to the end to another worksheet. Any help will be greatly appreciated. regards.
|
| Logical Test | 20 Feb 2008 03:26 GMT | 5 |
If cell B40 contains a formula to AVERAGE the adjacent cells (B1:B38), however, this range of cells are empty, then my result in cell B40 equals #DIV/0! Now, on the next worksheet, I would like cell C50 to reference B40, however,
|
| How do I combine If and AND Formula | 20 Feb 2008 03:06 GMT | 5 |
I want to use a IF Formula but need to combine it with an AND Formula as I am trying to check if the value of a cell is between two values...in my case If cell is between 12 and 24 show "X". I came so far as =If(A1>=12;"X";"") so now I need to get it also to check if
|
| automatic sorting | 20 Feb 2008 00:59 GMT | 4 |
I have many columns of corresponding data, i was wondering if there was a way to not only sort one column but have the coresponding data in other columns sort with it. I need an automatic sort beacause the data is to be refreshed frequently and the actual sort a list comand is ...
|
| finding multiple non-zero values in a column | 19 Feb 2008 23:21 GMT | 2 |
I have a sales list for a customer and I need to find all of the items they are getting via the column that shows "amount of units". Then I need to put that number as well as the item name that corresponds to each amount in a new sheet for project managers. The array looks like this ...
|
| Text to Date function | 19 Feb 2008 22:44 GMT | 3 |
I have a row of Text 20071020 20070814 could anyone help me, these are supposed to be dates but have been put in as
|
| Lookup discontinued Lines | 19 Feb 2008 22:27 GMT | 1 |
Hope you can help I have a spreadsheet with data that i want to lookup the discontinued lines i have and have a text string say Delete The discontinued lines are set up in an Array.
|
| Formula Assistance | 19 Feb 2008 22:25 GMT | 1 |
We have two large spreadsheets and both contain a common SS field. I need to combine both sheets by the ss field. They don't have uniform formatting or columns throughout. I have tried a Pivot Table and vlookup to no avail. HELP!
|
| Return Last 10 rows in reverse row order. | 19 Feb 2008 21:23 GMT | 9 |
I have an 8 column by many rows, dynamic named range called "Data". The named range starts in row 2, column "C". The oldest data is at the top, row 2 and the most recent data is at the bottom of the named range. "Data" holds numeric values.
|