| Thread | Last Post | Replies |
|
| Is there such a formula/rule? | 09 Jun 2004 12:33 GMT | 4 |
I have a spreadsheet with over 2,000 records (only two columns are used). Column one has a unique number. Column two has a range of numbers. For example, Column One might have the number 12345; and Column Two would have typed in it: 2004685-2004921. What this means is that in ...
|
| Weight loss calculation: how to use stones and lbs | 09 Jun 2004 06:35 GMT | 2 |
I have made a chart showing weight loss over specified time. As an Excel novice I convert stones and lbs, to lbs only, before entering the data. How can I directly enter stones and lbs in the cells so that the chart will show stones and lbs on the axis?
|
| Reading CSV into variables | 09 Jun 2004 05:28 GMT | 2 |
I am trying to get data from a csv file and store it directly int variables rather than first importing the csv file into excel. for example consider that my CSV file has 2 rows: "Input 1", "Input 2"
|
| Help with grid lines please | 09 Jun 2004 02:32 GMT | 3 |
I use several excel spread sheets. On one of them, I inadvertantly laid a book against the space bar and wiped out several rows of data. Not a big deal and I recreated it. (After I figured out the book on the space bar was the problem). However, for those rows that were "wiped ...
|
| Combining 2 cells to be put into 1 cell with Vlookup | 09 Jun 2004 00:28 GMT | 7 |
Hi Basically, what I want to do is combine firstname and surname which ar located in different columns - side by side though - the function I'm using is -
|
| Copying Row | 08 Jun 2004 23:46 GMT | 3 |
The code below does almost what I want - identifying words within a sheet. I would like however to copy the entire row to Sheet2 when found - can someone help with the coding? Thanks in advance
|
| Searching for a string in all the formula cells in a workbook | 08 Jun 2004 23:45 GMT | 2 |
I want to do a search on a string in all the formuals in my workbook. Say the string is "ABC_DEF". However there is also a "New ABC_DEF scattered across the formulas as well. How do I do a search o "ABC_DEF", without getting results that include "New ABC_DEF"?
|
| embarrassing problem | 08 Jun 2004 23:31 GMT | 3 |
This is one of those stupid little things I feel embarrassed to ask about. I am trying to link a cell from one worksheet to another cell in a different worksheet within the same workbook. (ex. the formula in Sheet2!A1 is =Sheet1!A1). Something I have done a million times. For some ...
|
| HELP - Schedules.xls (0/1) | 08 Jun 2004 23:20 GMT | 2 |
HI to all who reads this! I have created a schedule for my employees at work. It is attached for anyone to see. There are no scripts in the file or anything like that.
|
| Enter Multiple units and return conversion value for either | 08 Jun 2004 22:25 GMT | 3 |
I am putting together calculator for glass, in which I would like the user to be able to enter a Square Foot quantity or a Square Meter quantity (Whichever they have readily availible) I have One Column for each
|
| Return info from database based on column of data in excel | 08 Jun 2004 22:11 GMT | 1 |
If I have a column of index numbers in excel, is it possible to query a database for each index number and return the related data from a database? Example: I have the following column data in excel
|
| Is it Possible to Stop a Macro? | 08 Jun 2004 21:54 GMT | 6 |
Is it possible to stop a very large macro during execution? Thanks
|
| Default number format | 08 Jun 2004 21:16 GMT | 3 |
Is there a way to change the default NUMBER format for new workbooks? I found the default FONT, but not default NUMBER format. Dave French
|
| need a cell to highlight | 08 Jun 2004 21:11 GMT | 5 |
can this be done? when i put somthing in "D3" say a letter "Y" i would like for "F3" to highlight say a color say " blue" can that be done??
|
| Excel Search Problem | 08 Jun 2004 21:09 GMT | 3 |
I have five columns (A,B,C,D,E) of which I have a varying number of row per time. Column A will contain numbers from 1+ and Column E wil contain numbers and text strings. What I want to do is have a colum E that has a formula that for each row use its corrisponding value in
|