| Thread | Last Post | Replies |
|
| filter the rows which is having the colored text | 10 Mar 2008 13:43 GMT | 1 |
I have a set of 310,000 rows which I recieved from somebody and I want to delete the rows which is having colored text Can I filter the rows which is having colored text and then delete it completely??
|
| Filter / Drop Down Menu | 10 Mar 2008 13:21 GMT | 1 |
I'm hoping you can help; I'm trying to create a function I have seen on other worksheets; basically when a cell in clicked on, a small drop down menu will appear to the right hand side with pre-determined text of the aurthers choice. e.g. if I had a
|
| Help with averages revisited | 10 Mar 2008 13:20 GMT | 6 |
I had posted a question about averages earlier and received a helpful reply, but after trying it the suggested solution did not work. So after thinking for a bit this is what I came up with: I have a series of times in cells B3 through F3, some of which are values of
|
| SLOPE, (error in b if y= a+ bx) | 10 Mar 2008 13:13 GMT | 1 |
So I did my regression analysis using the SLOPE function, the number I'm interested in however is the error in the result of SLOPE (b if y = a + bx). What Excel function to use here ?
|
| Formula to calculate the difference in weeks between two dates | 10 Mar 2008 12:50 GMT | 3 |
I' am hoping you can help with what might seem a basic query. I have a row of dates in one column for which I want to find the difference between the earlist and latest date i.e. =max(A1:A10)-=Min(A1:A10); however I cant get the cell to calculate the number of weeks difference as ...
|
| Find Method problem in Excel VBA.... | 10 Mar 2008 04:49 GMT | 7 |
I have a problem about using find method in Excel VBA. Here is my program:- _________________________________________________________________ Private Sub CommandButton2_Click()
|
| Multiple Criteria for lookup array | 10 Mar 2008 04:19 GMT | 3 |
G'day there everyone, not sure if this is possible. I understand the row v column principal for a lookup array: Ideally what I need is this
|
| Text and defined name result in same cell | 10 Mar 2008 02:41 GMT | 2 |
I am trying to create a schedule for several teams. Each team has a defined name (Team1, Team2 etc). I want a spreadsheet something like this: A1: Week 1 Games A2: Team1 B2: at Team2
|
| how to use date in if fxn | 10 Mar 2008 01:42 GMT | 2 |
I would like to have my condition be a date in my true/false part of my IF function. Is this possible?
|
| How to use Excel for Kolmogorov-Smirnov test | 10 Mar 2008 00:19 GMT | 2 |
Has anybody used Excel for the Kolmogorov-Smirnov test?
|
| Bold font if statement | 09 Mar 2008 22:01 GMT | 3 |
A column of numbers is calculated in if statements based on other column numbers is same row. Want to bold the font if a number is greater than 4 in excel 2002. How can I do this?
|
| Count the number of appearance within a cell | 09 Mar 2008 21:56 GMT | 13 |
In cell A1, I put text "Apple" How can I count the number of appearance of letter "p" within one cell? I would like the answer come out as numeric "2" Thanks.
|
| Adding a calculated field to a pivot table | 09 Mar 2008 21:22 GMT | 4 |
I have a pivot table that includes these fields: 1. A count of "Traffic types" (which are text) 2. A count of "Sales Dollars" (which is in currency) I want to add a calculated field that will take #2 above and divide it by #1.
|
| Get multiple answers from a table | 09 Mar 2008 21:06 GMT | 4 |
I have two columns, one (Column A) that repeats and the other (column B) that has a none repeating number. I need to have a formula that will give me result in column C that will display all the results from column B when searching for a number is column A. Like when looking ...
|
| average of sumed data in pivot tabel | 09 Mar 2008 20:33 GMT | 3 |
In a pivot table, I would like to have the average of the sumed data, and make the average update automatically when the table size expends. Qtr Sum of Sales Amount Qtr1 28,441.99 |
|