| Thread | Last Post | Replies |
|
| VLOOKUP and repeating results | 28 Aug 2007 13:58 GMT | 4 |
Thanks for reading this post. I have data in sheet 1 with about 1000 Rows and 3 columns. The columns contain the following. - Old Account number (with leading zero) - not arranged
|
| Group & Sort | 28 Aug 2007 13:58 GMT | 1 |
Can you group cells, then sort them without losing the orginal grouping?
|
| Grouping and outline | 28 Aug 2007 13:40 GMT | 2 |
Hi could you please help I have worked out grouping and outlining, I whant to know how do you minimise the gray area to the side and get rid of the 1 & 2 at the top or evan hide it REgards Joel
|
| What is autofilter, nested function and pivot table? please help | 28 Aug 2007 13:36 GMT | 3 |
Hi Can someone please help me I know very little about excel and have to do a whole uni assignment on it. I need to know what auto filter is, what a pivot table is and a nested
|
| dates max & min | 28 Aug 2007 13:32 GMT | 11 |
hi all, please help A B --------- ---------- date item
|
| csv to excel | 28 Aug 2007 13:30 GMT | 1 |
There is a csv file, which contains data like- Policy,Claim,ProductCode AA123,BB234,AL I view this csv file in Excel. Everything is file, except heading
|
| Create monthly spreadsheets with the days of the month | 28 Aug 2007 13:28 GMT | 2 |
I'm using Excel 2003 on windows XP to create monthly schedules for my co-workers. Is there a simple way to create sheets that have one or two rows be the days/dates of the month? Right now I'm doing it manually: Su Mo Tu We Th etc
|
| csv to excel | 28 Aug 2007 13:26 GMT | 2 |
There is a csv file, which contains data like- Policy,Claim,ProductCode AA123,BB234,AL I view this csv file in Excel. Everything is fine, except heading
|
| limiting data entry cells | 28 Aug 2007 13:14 GMT | 2 |
How do I limit where the data entry fields are in exce
|
| how do I copy a graph from excel 2003? | 28 Aug 2007 13:10 GMT | 2 |
I need to copy my chart into PowerPoint. The data that I used to create the chart has an autofilter on. Does the autofilter need to be removed first?
|
| change excel document into word document | 28 Aug 2007 12:58 GMT | 6 |
How can I change an excel spreadsheet into a word doc
|
| VB Macro for cell colour default | 28 Aug 2007 12:53 GMT | 2 |
I have used up all conditional formatting. Please help me with developing a Macro for further cell formatting as follows: I have this range of numbers in the row A10:G10 12 5 26 3 17 38 9 23
|
| Average Formula | 28 Aug 2007 12:31 GMT | 2 |
I have a table with 56 Names in Column #1. After each name, there are various numbers in each row. What I am looking for, is the formula to give the average of each row, for each of the names in column 1. Any help would be greatly appreciated.
|
| Export Contacts to excel. | 28 Aug 2007 12:26 GMT | 2 |
after exporting contacts to the excel worksheet, why is it that in the address field, there are marks separating the street from the city, the city from the state, and the state from the zip code? It's almost like a "comma separated file. in field mapping
|
| How do I decrypt an encrypted sheet? | 28 Aug 2007 12:06 GMT | 3 |
I have encyrpted my Excel file, but I now want to turn the encryption off (so it stops asking for a password everytime I open it). How do I do this? Thanks, Alex
|