| Thread | Last Post | Replies |
|
| How? compare two worksheets and identify rows of data that appear on both. | 10 Jan 2008 21:16 GMT | 9 |
Ok, Suppose I have 2 worksheets. Sheet 1 has 1000 lines of data spanning xNumber of columns. Sheet 2 has 500 lines of data, also spanning the same number of columns.
|
| Tooltips with OptionButtons in worksheets | 10 Jan 2008 18:43 GMT | 1 |
Excel 2003, sp2 Hi, I have inserted several optionbuttons, grouped together in groupboxes, in a worksheet.
|
| Can I get Excel to automatically BOLD dates 30d before expiration? | 10 Jan 2008 17:35 GMT | 12 |
I am new to Excel (obviously), and I have created a simple worksheet that contains numerous dates. I wish to have the dates become bold when they are to expire within 30 days. Is there a formula for that purpose? Thanks...
|
| How do you password protect a single cell or column of cells | 10 Jan 2008 17:30 GMT | 2 |
I am trying to password protect a column of single cells but it keeps protecting the whole work sheet can ant one help?
|
| Automatic Adding | 10 Jan 2008 16:29 GMT | 1 |
Not sure if i used the right formula to begin with to calculate the sum of 7 different cell ( D5-J5 ) ...i just went to Math , sum, then typed in D5+E5+F5....and so on. But now i want to have the total amount figured out automatically as hours
|
| Combining worksheets | 10 Jan 2008 15:29 GMT | 1 |
I have a large number of worksheets, all with the exact same format. I would like to be able to have them all in one one worksheet, without having to spend a large amount of time using the copy and paste functions. Therefore, is there anyway of combining a number of worksheets ...
|
| Vlookup and min formula | 10 Jan 2008 15:02 GMT | 3 |
I have a worksheet that has dates in column B and file # in column A. In cell J12, i have this formula =min(B2:B100), in L12, I have a vlookup to return the information in column A that matches the date =vlookup(J12,A2:B100,1,0). I receive a #name error.
|
| VLOOKUP in a macro | 10 Jan 2008 14:57 GMT | 4 |
In Excel 2002 using and an InputBox I want to input an ID#, then find that ID# in a VLOOKUP table, then using the InputBox, enter a score (Points) in the cell next to (right of) the ID# in the table. I am trying this to no avail:
|
| Window 2 open automaticly | 10 Jan 2008 14:52 GMT | 3 |
When I open a normal workbook (without VBA) a second, same workbook opens automaticly. Named xls:2. How can I get rid off this?? Has it something to do with my settings? Usually it works fine.
|
| Need to convert the numbers with tolerances | 10 Jan 2008 12:37 GMT | 4 |
I have a column of numbers in teh format 0.45+_0.23 . +_ is a character plus or minus . How can I convert the number before and after +_ into mm automatically ? Any formula ?
|
| What is meant by "Standard Colors" in Excel 2007? | 10 Jan 2008 12:15 GMT | 1 |
What is really meant by "Standard Colors" when you use the shading paint bucket in Excel 2007? Are all of these colors supposed to be backward-compatible with Excel 2003? (They're actually not... the "light green" from Excel 2007's "Standard Colors" gets permanently converted ...
|
| Referencing cells | 10 Jan 2008 12:00 GMT | 4 |
I've got two workbooks linked together. Workbook A gets information from workbook B by referencing cells. This works well until someone enters a column into the middle of workbook B and workbook A picks up the wrong information from workbook B. Is there anyway to get workbook A ...
|
| change from dollars to pound sign on balance sheets | 10 Jan 2008 11:51 GMT | 1 |
trying to change dollar sign on balance sheets to pound signs,any help gratefully recieved
|
| Macro To Amend Data In A Column | 10 Jan 2008 09:40 GMT | 14 |
I hope that someone can help me with a problem I have inherited with an Excel 2003 file. When the file was created, a column was sized and then the data was made to fit the column by adding spaces and using word wrap to align the data on
|
| weibull distribution function - graph | 10 Jan 2008 04:31 GMT | 1 |
Hello, I need to make graph of Weibull distribution function with a = 10, b = 10 and count the modus of the function. I never did something like that. Can you give me detailed description how to do it? Thank you.
|