| Thread | Last Post | Replies |
|
| Data Clean Up | 28 Sep 2007 10:47 GMT | 1 |
I need to do some data clean up. I need to output unique data only. For example: Column A has 15 records, Column B has 10 records but I want column C
|
| Cursor | 28 Sep 2007 10:23 GMT | 1 |
I need to change the colour of the cursor or increase the outline to a heavier outline
|
| how to count 2 date columns conditions. | 28 Sep 2007 10:20 GMT | 5 |
Any one could help me pls. I have a spreadsheet that I want to count records like this. A B Start Retile
|
| Formula needed. | 28 Sep 2007 09:17 GMT | 8 |
A B 1 car 90 2 boat 20 3 airp 22
|
| vbYesNo, change carriage return | 28 Sep 2007 09:13 GMT | 4 |
Hie, can anyone help with the following: When you create a message box using vbYesNo function, when the box appears on screen, is it possible to change the set-up so that when you press return (carriage return) it will automatically select the "No" option. Standard
|
| Dateadd function | 28 Sep 2007 07:32 GMT | 2 |
can any one describe dateadd function in detail please?
|
| sorting using a second word in a cell | 28 Sep 2007 07:17 GMT | 3 |
I was just wondering if there is a way to sort columns by using the second word in a cell? and if so how would i go about it?
|
| countif >0, <8 | 28 Sep 2007 06:42 GMT | 5 |
I tried to post this message yesterday but I'm not sure if it posted, apologies if it comes up twice. My question relates to the countif function. I want to count the numbers that are greater than 0 and less than 8 in one column.
|
| Moving data from multiple rows into a single row | 28 Sep 2007 06:13 GMT | 3 |
I have a 50,000 row spreadsheet with 56 columns. The item in Col A Row 5 repeats in rows 6, 7, 8, 9 and 10 (all Col A). There is data in cells (Row/Col) 5/B, 5/D, 6/L. 6/Z, 7/AH, 8/AP, 9/AR, 9/AT and 10/AW. I want to move the data from cells 6/L, 6/Z, 7/AH, 8/AP, 9/AR, 9/AT and ...
|
| Rounding to thousands in excel | 28 Sep 2007 05:55 GMT | 4 |
Does anyone know of a way to round to thousands in excel with a custom format. I am trying to round as follows: If the number is 49,677,298.86 I want 49,600 to display If the number is 3,037,136.67 I want 3,000 to display
|
| IF | 28 Sep 2007 05:19 GMT | 3 |
I hve a formula in a cell. Is it possible that I format the cell in such a way that if the value comes to >5, the background color changes automatically? Thanks
|
| Easiest and quickiest way to delete blank pages in a worksheet | 28 Sep 2007 04:46 GMT | 1 |
See, I am working on a workbook that is only two pages. Yet it prints out as 100 pages. I don't know how to delete the unwanted pages without going through so nonsense blank pages. What is the easiest way to do this.
|
| Viewing Two Sheets within One Workbook | 28 Sep 2007 03:46 GMT | 2 |
Is it possible to view two different sheets side by side within one workbook? I know I can view two differnt workbooks side by side within Excel. Thanks!
|
| Unable to copy / paste acress workbooks | 28 Sep 2007 03:24 GMT | 2 |
Using Excell 2003. I am unable to use the copy / paste feature across workbooks. I will highlight the data then select copy. I then go to the other workbook to paste the data, but the paste feature is not an available option. Any help will be appreciated.
|
| Auto fill-in text and importing information | 28 Sep 2007 03:20 GMT | 1 |
I have a large list of people in excel (about 200 people) and a large word list that is in label format (again, about 200 other people). What I want to do is send a form letter to all of these people (alumni of my organization). I want to know if I can set a certain selection ...
|