| Thread | Last Post | Replies |
|
| SUMPRODUCT PROBLEM | 11 Sep 2006 05:00 GMT | 3 |
Assistance much appreciated My worksheet as follows col A col B col C col D col E Name Club Age Group Place Points
|
| Need help with this | 11 Sep 2006 04:35 GMT | 1 |
Prepare a plot that shows the distribution of noise in the raw DMA data set. To do this, you will need to establish a set of bins to accumulate the number of observations for a range of intensity values. For the intensities in DMA.txt, use bins that range from 2.7815 -
|
| sumproduct to count two arguments | 11 Sep 2006 03:18 GMT | 7 |
I have an excel test so please bear with me that what I am asking for may not be the best way to do this. Here is what I have been asked to do. I have daily dates from the beginning of this year to now and
|
| Multiple Find and Replace in one function | 11 Sep 2006 03:16 GMT | 4 |
I'm wondering how I can clean one column of text using multiple find arguments. This is what I have so far: =MID(B3,1,FIND(" Corp.",B3,1)-1) In addition to " Corp." I want to remove " Inc.", " Co." and a couple
|
| data sort/filter | 11 Sep 2006 02:53 GMT | 3 |
I have rows of numbers from which I would like to extract the five lowest values from each row, compute the average and display the answer in a different column. How can I do this? Any help will be greatly appreciated.
|
| How to chose bold text in a sentence in Excel? | 11 Sep 2006 00:46 GMT | 1 |
I have a text in a cell Barcelona vs Osasuna ("Barcelona" is bold) Now I want to chose the text "Barcelona" How to do this ?
|
| How do I calculate an average by a certain percentage? | 11 Sep 2006 00:33 GMT | 1 |
My husband is a junior college teacher and needed to know how to calculate an average by a certain percent. Say if homework was 20% of their total grade, how would he write the formula for that?
|
| AVERAGE function | 11 Sep 2006 00:31 GMT | 8 |
Can anyone tell me whether there is a way to average a whole column of numbers but ignoring blank cells or cells with errors in e.g. Column A
|
| Avoiding counting the same cell twice | 10 Sep 2006 22:35 GMT | 2 |
Please help, I'm stuck. How can I count the number of cells containing certain words but avoid counting the same cell twice. E.g.
|
| inserted a comment | 10 Sep 2006 22:24 GMT | 1 |
When I click to insert a comment my name doesn't come up in the box anymore. Therefore no one knows who put in the comment.
|
| Searching and matching in sheet (urgent) | 10 Sep 2006 21:54 GMT | 1 |
I have the following problem .. and I can't find the way to solve it. this is my screencapture of excel table: http://www.fuchka.info/tmp/excelproblem.jpg What I need is function that will:
|
| Need help wiht a macro for autofill rows | 10 Sep 2006 19:47 GMT | 9 |
I have a spreadsheet that has 10915 lines. I am copying the same formula from row 2 - columns H2..L2 to the next 21 rows then there will be one blank row and I will copy the same columns for the next 21 rows - blank row again and so on.
|
| Re: Sum every other 5th cell | 10 Sep 2006 19:39 GMT | 4 |
Is it possible to Sum every 5th cell in a range of cells (i.e. L8+L13+L18+L24....in a range of L1: L45) without entering every cell manually? From cell L8 and every 5th cell until cell L45.
|
| #N/A in calculations | 10 Sep 2006 19:33 GMT | 6 |
I'm trying to work around some #N/A values in calculations. Columns A and B are populated with a conditional formula, and I'm trying to sum them in column C; so data could look like: A1 = 3, B1 = 4 C1= sum(A1:B1)
|
| why don't my functions in paste special work? | 10 Sep 2006 17:33 GMT | 2 |
I am trying to copy from one workbook to another workbook and keep the column widths, print settings, etc the same but when I copy using different functions in paste special nothing changes in the new workbook except the visual data is present.
|