| Thread | Last Post | Replies |
|
| Lookup 2 values | 25 Sep 2006 08:49 GMT | 12 |
Can anybody help me with a formula to lookup 2 values simultaneously like Account No. and Sub Account No.? Thanks in advance. Jaleel
|
| formatting rupees | 25 Sep 2006 08:48 GMT | 8 |
I need to custom format a cell to read 00,00,000, instead of the usual comma after three spaces. This is for an application that uses Rupees, which have a comma break at 1,000, then the next 100, and then another 100. In other words, whereas 10M
|
| invalid references in formula | 25 Sep 2006 08:04 GMT | 2 |
I got the following message in excel: "A formula in this worksheet contains one or more invalid references. Verify that your formulas contain a valid path, workbook, range name and cell reference."
|
| WHY I CANT FIND THE FILL SERIES OPTIONS IN EXCEL? | 25 Sep 2006 07:52 GMT | 1 |
WHY I CANT FIND THE FILL SERIES OPTIONS IN EXCEL?
|
| Formula structure, maybe not parenthesis, CELL()? | 25 Sep 2006 07:29 GMT | 1 |
060925 Formula structure, maybe not parenthesis, CELL()? hi, have formula that is combo hyperlink to (this case) min value in column range. have start & stop rows selected in original formula that works.
|
| adding words | 25 Sep 2006 07:16 GMT | 1 |
this is my problem. In a excel sheet there are many different words in several cells. i want a way to add a spacific word and get the total number of times this word appears in the sheet.
|
| How to code it in excel? | 25 Sep 2006 06:46 GMT | 4 |
Could anyone please give me any suggestion on how to code following condition in excel? In colume A, it displays the date for activities. In colume B, it displays a list of activities for everyday, such as input
|
| Function Help | 25 Sep 2006 04:28 GMT | 7 |
I would like to design a function that will select a range of cells and assign an alternating color (light gray & no fill) to the rows within that selection after a copy, cut or paste operation occurs. Anyone have any ideas? Thanks,
|
| how to delete an old workbook from the right column in excel | 25 Sep 2006 04:05 GMT | 1 |
I'm trying to remove an old workbook from the display column in excel.I would like to know how to remove them when I don't need them anymore.
|
| comparing two excel documents | 25 Sep 2006 04:03 GMT | 1 |
How can I compare the data in two excel documents other than manually comparing or arranging the two files on the screen? Word has that option of comparing two documents but I can't seem to find it in Excel.
|
| Check Boxes | 25 Sep 2006 03:49 GMT | 2 |
I am trying to insert a whole column of check boxes into an excell spread sheet. I have figured out how to do one check box at a time. But if i try to just copy and paste into the column it only copies it to the first selected cell in the column.
|
| Importing a Value from many Excel Files | 25 Sep 2006 02:23 GMT | 2 |
I use a template to complete a weekly Expense Report. On every report the cell J30 is always the Total dollar amount What I would like to do is create another Excel worksheet that imports just cell J30 from all of my past Expense Reports to get a running tally. Other
|
| Checking balance template in MS excel | 25 Sep 2006 02:12 GMT | 1 |
What do I need to do to have a checking balance template in MS Excel? I have seen it work great but have not been sucessful. I am using, D as payments, G as deposits, and H for balance, just a simple quick reference.
|
| Excel makes an error | 24 Sep 2006 21:33 GMT | 3 |
I am currious to find an explanation for this. In excel I created a simple formula to calculate 12 to the 19th power written in full numerical form. At 12 to the 17th excel makes an error (note the zero's). Try it yourself. Anyone know why this happens?
|
| download existing spreadsheets into another existing spreadsheet | 24 Sep 2006 20:36 GMT | 2 |
I need to download several existing spreadsheets into one existing spreadsheet. Is this possible?
|