| Thread | Last Post | Replies |
|
| Use of offset and match functions with changing arrays, I think??? | 15 Mar 2006 18:17 GMT | 2 |
I would like excell to look for at the text value in column A and if that value exists else wear in the spread sheet in column A, I would like it to return the value that is in the same row in column B, exculding the value being test for, in column C. If the value occurs twice I ...
|
| How to calculate an age? | 15 Mar 2006 17:46 GMT | 4 |
I need to calculate ages as of 8/1/06. How can I do this if I enter the Birthdates for each participant?
|
| other workbook does not appear in the drop down box when I attemp. | 15 Mar 2006 17:42 GMT | 3 |
I attempted to move a worksheet from one workbook to another, but when I attempted to select the "To Book:" in the drop down box, the only workbooks I had to choose from were the current workbook and a new workbook. The workbook I desired to send the worksheet into was open. ...
|
| Sumif Cells Are Not Blank | 15 Mar 2006 17:40 GMT | 12 |
I'm looking to total a range of cells ONLY if they have a value of 0 or more entered in them. In plain english: Sumif A1 is >=0 Sumif A2 is >=0
|
| Count text cells based on two criteria | 15 Mar 2006 17:36 GMT | 2 |
I have a spreadsheet with many columns. I would like to count how many occurances there are of two criteria matching. Example, If column A contains names of girls (amy, betty, susie, karen, betty) and column B contains names of boys (michael, robert, andrew, james, joseph). ...
|
| How can I label a worksheet based on a cell in Excel? | 15 Mar 2006 17:31 GMT | 4 |
I have a workbook with multiple worksheets and would like to know if there is a way to label each worksheet based on info in cells on the first worksheet of the workbook. Don't know if this is even possible. The labels for the worksheets would be
|
| msgbox / inputbox etc | 15 Mar 2006 17:28 GMT | 2 |
I'm using a vlookup formule to translate names into codes in a really big excel sheet. The problem is that if there are two time the same name, the system will take the first code to translate the name without warning me. It can happens
|
| Conditional Format | 15 Mar 2006 17:24 GMT | 5 |
Can this be done with a conditional format? Data in columns A thru C. I would like the highlight the cells in column C where the same data exists in either columns A or B. For example, Cell C5 has the number 75. If any cell within columns A or B
|
| how to count unique values in excel based on multiple criteria | 15 Mar 2006 17:00 GMT | 3 |
I need to count and sum a worksheet of over 10,000 rows based on multiple criteria. 1st is by the employee name, second date range, they other is product type, but for this example i doubt three is much different than two criteria's.
|
| create macro - if cell is 0 delete row | 15 Mar 2006 16:55 GMT | 1 |
Is there a way to create a macro that will search a section of a worksheet and delete rows that have a zero in the leading cell? Thanks in advance!
|
| Need help with writing a formula | 15 Mar 2006 16:51 GMT | 1 |
Hi, I'd like some help in writing a formula in column C. The objective is to lookup or to match the city on column D and E, if it matches, enter the rate. Thank you for your help
|
| How do I repeatedly find text in an Excel sheet? | 15 Mar 2006 15:40 GMT | 1 |
Need to find text in an excel sheet. CTRL+F will only work once. When I try again for text that is cleary there it doesn't respond.
|
| Adding data from another sheet | 15 Mar 2006 15:31 GMT | 2 |
I have two sheets: - sheet 1 contains: name; first name; number;.... - sheet 2 contains: name; first name; number; birth date.... All persons that are in sheet 1 are also in sheet 2 (but not vice versa).
|
| Highest & lowest place value / decimal places of cell value | 15 Mar 2006 15:27 GMT | 2 |
Hi! Does anybody know of a function/series of functions that could determine the upper & lower place value of a cell value? E.g. the highest place value used in 123.4 is the hundreds column, and the lowest is the tenths column. Whereas the highest in 12.34 is the tens column
|
| Count function | 15 Mar 2006 15:21 GMT | 2 |
I currently have an array function to sum revenues from a list of customers. Is it possible to count the number of customer associated with these revenues? The formula I am using is: {=SUM(XXX!$BX$5:$CC$13390*(XXX!$CC$5:$CC$13390=0)*(XXX!$CB$5:$CB$13390=0)*(XXX!$CA$5 ...
|