| Thread | Last Post | Replies |
|
| copy cell difficulties | 19 Feb 2007 07:07 GMT | 1 |
Example .... Sheet 1, [cell]A1 = Snoopy I want "Snoopy" to be copied to Sheet 2, [cell]K7, so if I change "Snoopy" (on Sheet 1, A1) to "Woodstock", it will change Sheet2,K7 as well.
|
| challenge! javascript function into excel function | 19 Feb 2007 06:35 GMT | 2 |
Hello, I am sending again my question or problem to you. i am not able to do so. please help me. I have one columen witch contain Ids 11 sifer in excel. i have one formula
|
| Hyperlinks | 19 Feb 2007 05:48 GMT | 3 |
Hello from Steved I have a worksheet in excel that I use to link to Paragraphs in Word CitySchools.doc#027^t3.35 A question please Can I in Excel spreadsheet put the a list off links as I
|
| cell referencing | 18 Feb 2007 22:57 GMT | 2 |
I fill out missing information letters and often required material is missing from more than one field. I want to be able to fill in the explanation for missing information in field 1 and field two into the same cell, which content will be merged into a letter.
|
| count how many groups have been completed. | 18 Feb 2007 21:08 GMT | 1 |
I have my last answer, ty to the person who answered it. Here is my current answer. Again in groups of 6 rows in a column, numbered 1-6, i need to make a total of the number of groups that have an entry in adjoining cells.
|
| Average Daily Balance | 18 Feb 2007 20:02 GMT | 5 |
I have a spreadsheet that lists checks and deposits in chronological sequence and keeps a running balance of the account. Is there a function to calculate the average daily balance for a selected range of dates?
|
| adding rows depending on cell value | 18 Feb 2007 16:18 GMT | 1 |
i hope someone can help with my problem, im an excel dufus. i have 3 colums, first column numbered 1-6, secong column with various bits of data, third column i am using to help me add rows. if a "1" appears in any cell in the 3rd column, i need it to add a row, and the
|
| Count Unique Values with a Criteria | 18 Feb 2007 15:40 GMT | 2 |
I have 2 columns of data...as follows Col A Col B 0001 123 0001 123
|
| Conditional Formatting Cells/Shapes | 18 Feb 2007 14:58 GMT | 4 |
Hi Each and All, This is what i'm trying to achive, I'm trying to create a kind of traffic light type of status indicator, If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill Amber &
|
| linking a text with a date and can't remember the format | 18 Feb 2007 14:55 GMT | 5 |
I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3. When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs.
|
| Extract data in put in a new column | 18 Feb 2007 12:10 GMT | 5 |
I have a problem is which I would like to extract the data in Column A dependant on the value of column B. Column A3:A22 contains unique names column B3:B22 contains the numerical value. In this example I would extract the if the value of
|
| Sorting a range of worksheet tabs A-Z | 18 Feb 2007 09:47 GMT | 2 |
Greetings to all, My aim is to sort into A-Z order a range of worksheet tabs, I have a tab named 'A' and a tab named 'Z' and various tabs in between, that I would like to automatically sort A-Z, I also have some tabs prior to tab
|
| I created a Formula, OK, but can't get the results in the right ce | 18 Feb 2007 06:59 GMT | 8 |
Created Formula for G7 =SUM(G4:G6) and have copied it to other cells, i.e. G11
|
| SUMIF for an AVERAGE | 18 Feb 2007 05:09 GMT | 2 |
I have a rather complex (at least to me) question... My worksheet has column D with agent initials and column AE with a score. I'm trying to figure out the formula to calculate an average score for each agent in column D based on amount in AE?
|
| WEEKNUM and SUMPRODUCT | 18 Feb 2007 03:08 GMT | 4 |
Can they be used together? Excel 2003 is my version. I want to count the number of transactions per week for each of my offices. Basically, I am not trying to make this fancy at all. Offices are listed in rows and the weeks are in the columns.
|