| Thread | Last Post | Replies |
|
| Query from within Excel | 31 Jan 2006 06:37 GMT | 1 |
I have a need for some query help and I will try to explain my situation. Thanks in advance for any help. I have an Excel spreadsheet that has two different sheets. One one sheet called "Data" I have created a query that pulls AP Invoices from from a SQL
|
| somehow I shrunk my page, going to 8x11/2 wont correct it ! | 31 Jan 2006 05:51 GMT | 5 |
in excel somehow I shrunk the page. Going to 8x11 1/2 letter size wont change it. how can I correct it?
|
| HELP MEEE | 31 Jan 2006 05:47 GMT | 4 |
I have aproblem I have .csv from my p900 and another .csv from my out look...I want to merge these two file and get one consolidated contact details!!. My Problem is in p900.csv it's lists on first name basis and in
|
| doing my accpounts on excel | 31 Jan 2006 05:19 GMT | 5 |
when I try to enter a number in acolumn, the date comes up! how do I just go about numbering each row 1,2,3,4 etc. for future reference?
|
| Seniors Need Help! Help Retrieve Deleted Excel Document | 31 Jan 2006 04:44 GMT | 8 |
My wifeand I are seniors and we unfortunately deleted a very important Excel document, a spreadsheet. We have found software programs that will restore the document, but cannot afford the $50 for just the one document.
|
| How do I count based on two conditions? | 31 Jan 2006 03:57 GMT | 2 |
Hi there. I have a long lists of data to sort though and I am trying to write a formula that counts that number of entries for a company with a certain condition entered in another column. For instance Company name Condition
|
| Relative reference to another file | 31 Jan 2006 03:09 GMT | 2 |
I am trying to create a formula with a relative reference to a cel that is in another workbook. I can only find information on relativ referencing within a workbook. I am trying to use the ..\ concept to go up one level to find the fil
|
| Round 2 of VLOOKUP command - can the output result in a list? | 31 Jan 2006 02:57 GMT | 6 |
I have worksheet1 that references worksheet2. (Worksheet2 is a data link to a table on SQL server0 On Field B5 of Worksheet1 when a user enters in a project number, I want the VLOOKUP command to go to Worksheet 2 that has a small table (column 1 -
|
| entering new data in a saved spreadsheet without losing formulas? | 31 Jan 2006 01:00 GMT | 1 |
|
| Hyperlinks open as Read-only?? | 31 Jan 2006 00:01 GMT | 3 |
I am building an excel sheet which contains a number of hyperlinks to other documents (powerpoint presentations, PDF-files, etc), but as I click the hyperlinks they open as read-only files, and I would much prefer that they open within their original program (e.g MS Powerpoint)
|
| Starting Excel | 30 Jan 2006 23:53 GMT | 3 |
I am new to Excel and have no clue what I am doing. I have an Excel Workbook and it tells me to open the Student files,EE1_0101...I can't locate that file. Can anyone offer me any help? PLEASE!
|
| Count using Multiple Criteria | 30 Jan 2006 23:50 GMT | 4 |
I have a spered sheet I am using to keep track of leaks of different types and it covers several years. I would like a tally sheet by year. This requires that I use the year column and the leak type column in my search criteria.
|
| Locating | 30 Jan 2006 23:45 GMT | 2 |
I am a bit frustrated....In my spreadsheet, I would like to verify if particular name and a particular city are located on the same row. Ho can I check a spreadsheet that has 100 rows to verify if the sam name/city are on the same row
|
| Insert "0" where null | 30 Jan 2006 23:40 GMT | 3 |
I want to do something that is probably simple. I have a worksheet with a lot of empty cells. I want a "0" inserted into every cell that is empty or null. How do I do that?
|
| Unable to start up my Excel files | 30 Jan 2006 22:20 GMT | 3 |
One of my users have this odd issue with his Excel 2003. He's unable to start the files directly but instead he must start a blank excel sheet then open his files from there. Is there a solution to this issue? Please advise.
|