| Thread | Last Post | Replies |
|
| Unable to remove objects pasted into Excel from HTML grid | 22 Jul 2006 19:59 GMT | 3 |
Copied & pasted an html page into Excel. Has little check boxes that will can be checked, but not removed. Can't grab them, deleting columns or rows just moves them over by one. Any idea how to get rid of them? Would like to keep the rest of the data.
|
| How do I re-calculalate the values for all cells in a column | 22 Jul 2006 19:47 GMT | 2 |
I'm a newbie to Excel worksheets however, I'm very familiar with Access. However, I need to change data in an Excel worksheet and I'm clueless where to start. For Example, I need to change the value of all cells in colum 3, for all rows with data by -5, what would the formula ...
|
| excel should allow me Indian number grouping ##,##,##,###.## | 22 Jul 2006 19:46 GMT | 3 |
Excel does not have grouping for numbers used in India. we need the described grouping for everyday use as we dont use millions grouping ----------------
|
| Conditional Formatting | 22 Jul 2006 19:42 GMT | 2 |
How do I highlight any cell in , say, A1:M1 that is equal to the maximum value in that range. Thanks Bertrand
|
| If and nested Sumif error | 22 Jul 2006 19:25 GMT | 4 |
I am trying to automate my bank reconcilliation programme, Column F = Receipts Column G = Payments Column I = Current Balance (book Balance)
|
| Calculating correct pecentages with negative values | 22 Jul 2006 19:12 GMT | 4 |
I need a formula that will return the correct percentage where there is 4 scenarios of comparing Actuals as a percentage of Plan. eg Actual Plan 110 100
|
| is there a function for this? | 22 Jul 2006 17:36 GMT | 1 |
Can someone help me with the following? My spreadsheet looks like this term ins whole ins variable life total points
|
| Syntax to "OR" 3 "ISERROR" conditions | 22 Jul 2006 16:18 GMT | 6 |
Oh Wise Ones, I would like to filter the conditions of 3 columns for errors and evaluate in a fourth. I need a null value not just a white font. I've played with the OR syntax and nothing works. Any ideas please?
|
| numbers to characters | 22 Jul 2006 15:37 GMT | 1 |
I have a spreadsheet that is externally linked to a query. In four colums are phone number information - area code, number, fax area code and fax number. When the data is imported, some of the fields are zero. I can format the column that if it's zero to show blank by
|
| Need Help with Formula | 22 Jul 2006 14:35 GMT | 2 |
I'm trying to create a formula that sums a number of cells (in column "L") IF the corresponding cells in column "A" are the same. For example: Company Product Value TOTAL 1 A Co. 1 100 100
|
| Drop Down selecting worksheet | 22 Jul 2006 13:25 GMT | 1 |
Hi, I'm, trying to create a drop down list that by choosing, say a country, will tell the workbook to send the data I type later to a specific sheet, called Denmark etc. DropDownList must be on the first sheet, called index which only is used to
|
| Updating a Date in a Graph Header Field | 22 Jul 2006 13:03 GMT | 1 |
I would like to have the header on a graph update the date when I update the spreadsheet. For example, The header reads: "Payments by Category - August 31, 2006" but the next month when I update the data, I want it to read: "Payments by Category - September 30, 2006". Can
|
| How to copy data to the next empty cell in a column | 22 Jul 2006 12:35 GMT | 2 |
I need a macro that does the following: copy the data from cell A1 in worksheet1 to the next empty cell in column A in worksheet2. Can anybody help me? Thanks...
|
| Return last cell that contains a particular value | 22 Jul 2006 11:39 GMT | 6 |
The scenario: I have a spreadsheet to track my stocks. Each stock has its own worksheet with the stock symbol as the worksheet name (ie IBM). I also have a worksheet that summarizes all the individual sheets. On the individual stock
|
| common numbers in 2 columns | 22 Jul 2006 10:11 GMT | 5 |
I have two columns of numbers. One is a large list with say 3,000 random serial numbers. The other is a smaller list of 800 serial numbers. I want to
|