| Thread | Last Post | Replies |
|
| Compare 2 columns in a spreadsheet | 02 Apr 2005 02:59 GMT | 1 |
I have a spreadsheet with 2 columns and i want to compare the data in the two columns I have been using the following formula, but it is not working... any help is appreciated
|
| Go Back | 02 Apr 2005 01:32 GMT | 3 |
Does any one know a command or macro that will let to navigate back to the previous cell you ay. to ctrl-g function does not give you that as an option
|
| I want to type the letter Y in a cell and have the word Yes appea. | 02 Apr 2005 00:25 GMT | 3 |
I want to type the letter Y or N and the word yes or no to appear in the cell.
|
| spreadsheet for splitting a utility bill | 01 Apr 2005 23:50 GMT | 8 |
How would I find or make a spreadsheet for splitting an electric utility bill among three tenants? The knowns are the total kwh used, the total bill and the number of KWH used by two of the three tenants. Thanks!
|
| Autofilter | 01 Apr 2005 23:46 GMT | 2 |
I have a spreadsheet I have been using for a while and now I cannot use Filter "Autofilter" it appears grayed out. Filter "Show All" is also grayed out. Filter "Advanced Filter" is available.
|
| How to switch worksheets with vba ? | 01 Apr 2005 23:45 GMT | 4 |
I have a vba macro with a lot of references like... Range("A" & 1).Select strData = ActiveCell.Value This has defaulted to WorkSheet 1
|
| Removing a space after a comma | 01 Apr 2005 22:09 GMT | 3 |
I need to create a formula that removes a space after a comma, that separates two names, in a cell?
|
| How do I 'Print Preview an excel worksheet in color? | 01 Apr 2005 19:41 GMT | 2 |
I'm using XP and need to 'print preview' in color. Mine is black and white. How do I change this setting?
|
| COUNTIF function for 'all others' | 01 Apr 2005 19:14 GMT | 3 |
I have a column to count the number of occurrences of certain statuses. And have set up the COUNTIF function for three of the status lables, and I want to have the fourth to count the number of items with any other status.
|
| INDIRECT and multiple cells at once | 01 Apr 2005 18:59 GMT | 3 |
Anybody know is it possible to write string which contain multiple cells and then evaluate that. For example with INDIRECT you can do: If Sheet1 contain in A1 value 10 and Sheet2 contain in A2 value 20
|
| Multiple lines in a single cell | 01 Apr 2005 18:53 GMT | 1 |
How do I enter multiple lines in a single Excel cell? --thx, Joseph
|
| vlookup | 01 Apr 2005 16:45 GMT | 7 |
I have a workbook with 3 pages. One is a form, one is a job list, and the last one is a vendor list. On the form, I have two cells I fill with vendor # & job # information, which I want to fill in below in other cells of the form. I can get one of the vlookup formulas to work, ...
|
| how read data downloaded on cd-rw, now show only code? | 01 Apr 2005 15:23 GMT | 2 |
I downloaded written data from computer (e-mails) to cd-rw. Want to know how when put it in computer can get it so I can read it. It now looks like code
|
| graphs | 01 Apr 2005 14:44 GMT | 6 |
Hello everybody, I have a question concerning graphs. I need a graph to be behind a picture. All I need to see are the dots. In Word it is possible to insert a picture and then set it "behind text". Is it possible to do something like that in Excel?
|
| Pasting text with double quotes | 01 Apr 2005 13:16 GMT | 6 |
I'm trying to paste text that contains double quotes into Excel. Example: "Bob Anderson" 36475tmmn8766 Excel is stripping out the double-quotes upon pasting. I've look
|