| Thread | Last Post | Replies |
|
| Tracking Attendance | 30 Apr 2008 21:39 GMT | 1 |
Need your help, I have a spreadsheet to track both international and domestic attendees, I have 4 buttons in the left corner of the spreadsheet that I need to edit I can click on the button but nothing happens. The words are in German and I need to change them to English, can ...
|
| Colour to heperlink | 30 Apr 2008 21:21 GMT | 1 |
hey make a worbook and putt here 6 hyperlink like Home, Pre-Mission, Post Mission, now what i want that as curse move on it for open they will change the colour and underline
|
| Splitting Cells | 30 Apr 2008 20:45 GMT | 6 |
How do I split cells in Excel?
|
| Formuals | 30 Apr 2008 20:09 GMT | 2 |
Code Number Status Last Name Arrival DateDeparture Date ZAMY 1002 Placed Zulu 5/31/2008 XXXXXXX ZAMY 1038 Placed Silwamba 5/15/2008 8/10/2008 ZAMY 1063 Placed Musopelo 6/6/2008 8/19/2008
|
| Number Formatting | 30 Apr 2008 20:00 GMT | 1 |
Have created an speadsheet with a column for dollar amounts. Have formatted cells in that column for Currency with 2 decimils. Using this spreadsheet for Mail Merge in Word but each time I pull information from the cells in the column formatted for currency, the dollar amounts ...
|
| vlookup &match | 30 Apr 2008 19:58 GMT | 3 |
hello...need your help: is it possible to do the following: =vlookup(....,match(.....),match(...) ) . can you please give me an example ?
|
| Suppress dialog from regserver command | 30 Apr 2008 19:51 GMT | 3 |
We have Office 2003 and 2007 installed on our systems. Our users were not to use 2007 yet, but kept getting into it inadvertently (and unknowingly) by double-clicking files. As a work-around until we go to 2007, we put Excel and Word regserver command lines in our login to ensure ...
|
| help with linking information | 30 Apr 2008 19:28 GMT | 1 |
I have excel 2003 and I am trying to link prices with products using the list validation. is this possible or do I need to go in a whole other direction? thanks in advance chris
|
| Running all data through a set of formulas | 30 Apr 2008 19:20 GMT | 6 |
I have a formul that runs through four seperate steps and requires 4 seperate cells. I have 8 tables per page with 7 rows per table, 2 columns of data that are used to calculate the third column answer. Basically 7 rows per table that have Data column A, Data column B, and Result ...
|
| Sumproduct | 30 Apr 2008 18:56 GMT | 2 |
A few days ago I received help with the following formula and it works fine =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000>DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<>"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<>"WORK ORDER")
|
| Insert row | 30 Apr 2008 18:14 GMT | 2 |
Excel 2003 I want to move data from one "InputSheet" to another "Calculation" sheet that links to charts. I want to insert the data so that the chart ranges expand, instead of having to set up the chart ranges ahead of time. Here's
|
| Rank problem | 30 Apr 2008 18:12 GMT | 11 |
i have the following formula to rank a column of data =RANK(I15,$I$15:$I$314,0) but the problem i have is that if the data is duplicated then it returns a duplicate rank. ie.. DATA Rank
|
| .xlsx file opens as read-only | 30 Apr 2008 17:51 GMT | 1 |
Using an older verion of Excel with the compatiblity pack installed. File opens okay on one pc with older version of excel, but (you knew there was a but). On another pc Excel opens file as xl0000001.xls Read-Only file in the
|
| how do I stop showing "blanks" in a pivot table? | 30 Apr 2008 17:50 GMT | 2 |
I am working on a pivot table, and I want to avoid showing "blanks" and counting them, later on I need to do a graph and I do not want the blanks to appear
|
| Hide and password protect a worksheet | 30 Apr 2008 17:33 GMT | 4 |
I am using 2003 and xp sp3. I want to hide and password protect a worksheet in a workbook
|