| Thread | Last Post | Replies |
|
| Pivot table has bloted file size - how do I bring it down | 18 May 2007 13:20 GMT | 2 |
I have created an Excel 2007 which has 5 pivot tables with a common data source in another sheet within the same file. The data source is of only 500 rows or so with about 15 columns (i.e. not particularly large). However while specifying the data source at the time of pivot ...
|
| how to convert nos into word format say 500 to Five Hundred | 18 May 2007 13:02 GMT | 3 |
how to convert nos into word format say 500 to Five Hundred We have huge data containing no's, would like convert the same into word format Example to convert
|
| How do I synchronise Excel files ? | 18 May 2007 13:01 GMT | 1 |
I'm trying to syncronise Excel files with my PPC. Is there a way to set it up so that I can append the information for both files with each sync such that it doesn't matter which copy (PC or PPC) I update ?
|
| Change Date Created | 18 May 2007 13:01 GMT | 2 |
Is It possible to change the date created on an excel file. Someone's renamed a file and the date as refreshed to when they did it, but I would like it to be the date the original was created. Is this possible?
|
| Formula to seek and find duplicates | 18 May 2007 12:54 GMT | 2 |
Need to know how to find name and address duplicates in a rather large Excel file. Are there any ready made formulas etc.....
|
| spreadsheet stuck | 18 May 2007 12:50 GMT | 7 |
this is hard to explain but I have Excel 2003. When I open a spreadsheet and then click on a cell with my mouse, the "+" appears, highlights anywhere I go on the page and I cannot get it turned off. can someone tell me how to get it turned off?
|
| change 04/02/07 to 040207 | 18 May 2007 12:30 GMT | 2 |
How do I can the cell to display change 04/02/07 as 040207
|
| Format of postcodes | 18 May 2007 11:40 GMT | 3 |
I have a column in a worksheet populated with postcodes. These postcodes are either 6-character or 7-character strings. Eg: AB19PQ
|
| another IF query ...... | 18 May 2007 11:03 GMT | 23 |
How do I work this one out please? IF 'A20' is not null AND 'A16' is null OR 'A17' is null then COUNT result in 'A14' on a different spreadsheet!!!!! help me please ...........
|
| active cell bold | 18 May 2007 10:53 GMT | 7 |
Im trying to make the active cell either bolded or highlighted. Is that possible?
|
| 'If' Query | 18 May 2007 10:32 GMT | 3 |
Im developing a Time tracker spreasheet for my team. In this i have some fields - 'Status', a list that contains {Office, Holiday, On Leave} and Hours field. At the bottom of the sheet i have columns - Total Utilized Hours, Total
|
| vlookup to obtain pictures | 18 May 2007 08:38 GMT | 1 |
My problem is this: Based on an employee number, I want to extract the job title and name from two columns and their picture from another column. I can extract the text but I do not know if I can use Excel to store the pictures and use vlookup
|
| check a row ignore blank cells print only those with text | 18 May 2007 08:32 GMT | 4 |
I want to check down a column of cells, some of which may be blank, I want to gnore the blank ones and print only the contents (in another cell) those with a number in them. eg
|
| rename worksheet based on contents of a cell in different workshee | 18 May 2007 06:02 GMT | 1 |
I have three worksheets within a workbook. The three worksheets are named "Account Info" "sep 27,2006" "lists"
|
| Inserting? | 18 May 2007 05:16 GMT | 1 |
I'm a reasonably knowledgeable Excel user having had it since my old DOS days when I ran it with a run time Windows environment. I also know I'm not as good as some power users I know that really amaze me with what they can do with Excel.
|