| Thread | Last Post | Replies |
|
| find a value in a table | 21 Sep 2007 17:58 GMT | 1 |
i have a table full of numbers. let's say it's 1000 by 1000. I want to see if this table has a set of specific values, say 100 i want to check for. rather than doing ctrl-f and find each of these 100 numbers, there
|
| Column styles doesn't appear on the worksheet | 21 Sep 2007 15:42 GMT | 1 |
one of my customers has changed the windows xp designs to its own. From this moment excel doesn't show the font color and the background color of a cell in the worksheet. Only in the print preview you can see the color settings of the cells.
|
| text and date concatenation | 21 Sep 2007 13:43 GMT | 1 |
I'm using the following formula to concatenate some text and a date into a single cell =Concatenate("End Date for the period is; ", Data!W2) where cell W2 on the data sheet is the date I want to use. Unfortunately the
|
| Next occuance | 21 Sep 2007 13:24 GMT | 4 |
I am trying to create a spreadsheet list of client birthdays. I need a col titled Date of Birth (this is obviously just data entry). The next col needs to be Next Birthday and then one for age. I have the calculation formula done for the age col. Is there an easy way to ...
|
| 2 excel programs | 21 Sep 2007 08:46 GMT | 4 |
I have Excel 2003 and lately installed Excel 2007. When clicking on an Excel file it opens it using Excel 2007. I need the files to be oppened in Excel 2003 when double clicking the file. How can this be done.
|
| Linking Option Buttons to Cells | 21 Sep 2007 08:22 GMT | 2 |
I am develping qa questionnaire with something like 120 rows in it. Each row has 7 possible responses in it. Each response has an options button/check box associated with it (In don't mind which), but only 1 button can be selected from each row. The questionnaire therfore has ...
|
| Update Graph Data Automatically | 21 Sep 2007 02:22 GMT | 2 |
I have a sheet with data and graphs - e.g. below shows one set of data - of the last 14 fortnights 14-Mar 28-Mar 11-Apr 25-Apr 9-May etc.............. 4 6 5 2 6
|
| Opening XLS with XL2003, not XL2007 | 21 Sep 2007 01:34 GMT | 2 |
I have both Excel 2003 and Excel 2007 installed on the same machine. Until today, I could doubleclick on any .XLS file and it would automatically open in the old Excel. Now, however, it opens in the new Excel in compatibility mode.
|
| delete row of same colors | 21 Sep 2007 00:50 GMT | 1 |
I have an excel file of 100 names and address, etc. I have color coded some of the row in red. I want to delete all of the colored rows. it is the entire row that is colored not the text.
|
| new to using pivot tables and excel | 21 Sep 2007 00:06 GMT | 6 |
I am new to using pivot tables in excel 2003. Right now I need to change some pivot tables.The person who setup the pivot tables at my company no longer works for the small company I am working at. Right now the pivot table I want to change, is intended to have a blank
|
| Counting only uppercase letters with wildcard in column/row | 20 Sep 2007 23:52 GMT | 6 |
I'm working with columns and/or rows containing both upper and lower case letters with wildcards. I only want to count upper case letters with wildcards. Any help to this problem will be greatly appreciated. BTW I'm using excel 2007. Thanks!
|
| Can I select multiple rows from a data range? | 20 Sep 2007 23:41 GMT | 3 |
I'm trying to add a feature to someone's Excel spreadsheet where they can print a list of owned items based on a user id. In "real life", I'd be looking at a database to do this, but it's a non-profit organization staffed by volunteers, so you take what you get as far as ...
|
| Forms | 20 Sep 2007 23:28 GMT | 6 |
How do I make a form where I can type on top of a line? I don't want to type the text and then underline it, I actually want to type on top of the line where the lines stay static. Can this be done? Thanks
|
| Cut and paste issue | 20 Sep 2007 22:20 GMT | 3 |
I've distilled a previous problem that I posted down to something very simple, however I still can't figure it out!!! Here's the deal... In any cell, type in this.... Line 1 <then hit alt-Enter to do a carriage return>
|
| Get rid of FALSE in cell? | 20 Sep 2007 20:42 GMT | 3 |
How do we get rid of the FALSE in a cell, pls? The cell in question, N2, has this formula in it: =IF(K3<>"",IF(M2=0,"OKAY","RE-CHECK")) When K3 is empty, I get a FALSE rather than just a blank cell.
|