| Thread | Last Post | Replies |
|
| Conditional formatting | 30 Dec 2005 13:39 GMT | 3 |
In a row of 6 numbers I want to highlight the 3 largest numbers. If the row contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers. If the row contains 9 or 10 numbers, I want to highlight the 5 largest of those numbers. Any suggestions on how to make this ...
|
| sql.request | 30 Dec 2005 13:34 GMT | 2 |
Does anyone have a comprehensible guide on how to use it that a dolt like me can follow? Every time I try I get a #N/A. The only guide I can find is at http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip but it's
|
| How do I email an Excel worksheet? Do I have to create a profile? | 30 Dec 2005 12:53 GMT | 1 |
How do I email an Excel worksheet? It asks me to create a profile? What do I do? I just want to send a copy of a worksheet to a colleague for review.
|
| How to Auto duplicate cell contents? | 30 Dec 2005 10:57 GMT | 1 |
Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells an I wish them to automatically show in certain cells in other worksheet (and also may be other workbooks. I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if
|
| Aurgh, need help | 30 Dec 2005 05:48 GMT | 5 |
I have 3 spreadsheets all which contain the similar data in this one single column. The three spreadsheets are being used by 3 different users. Each one is filling out different rows to that one column. What I need now is a formula to combine the information in that one
|
| write macro to input data | 30 Dec 2005 00:10 GMT | 4 |
I am new at Excel. I want to write a small macro, four or five columns where I can go to column 1 and input data, then go to column 2 and input date, etc., then when I get to the end of the fifth column have it return and go to add more data in column 1. Any help will be ...
|
| Fill series | 29 Dec 2005 23:58 GMT | 1 |
I want to set up a table. The instructions say to use Edit>Fill>eries, but my Series is grayed out.
 Signature Stephen G. Esrati
|
| Text version of formula | 29 Dec 2005 23:36 GMT | 2 |
I Have Been Asked To Enter The Text Version Of The Formulas Below. Usin No Equals Or $ Signs. Can Anyone Help??? =subtotal (9,b17:b29) =subtotal (1,d15:d25
|
| Is it possible to create a mailing list in excel, not importing d. | 29 Dec 2005 23:20 GMT | 3 |
I would like to create a mailing list in excel, entering each address in, not importing it from somewhere. Can excel do that? Or do I have to import the data, entering the addresses in a different software and doing some sort of mail merge with excel? Thank you in advance for ...
|
| In VB macro how do I select range from active cell | 29 Dec 2005 23:11 GMT | 5 |
Hey guys and gals, Thanks for lookin at this problemmmmm??? When I am writing a macro using visual basic, how do I select a range which includes 2 rows down and 8 rows across (selects the range not just the single cell) from the currently selected/active cell then
|
| Excel 2003 won't let me change Xlabels from scientific notation | 29 Dec 2005 22:53 GMT | 1 |
For some reason, when I type in bin bounderies for a histogram as: 0.0000 , 0.025, 0.050...... 0.175, 0.200 excel keeps changing them to exponential/scientific format, which not only takes up a lot of space, but just looks dumb. How can I
|
| templates for excel xp | 29 Dec 2005 22:23 GMT | 1 |
Where can I get additional templates for my excel program. Thanks Raymond
|
| Conditional Formatting...Please Advise | 29 Dec 2005 22:09 GMT | 10 |
If I have a row of cells B6:M6 A cell K6 which is "List" validated Yes, No I would like the full range of cells B6:M6 to become Yellow, when the cell is set to Yes from the list.
|
| Automatically Comparing Tables with Different Entries | 29 Dec 2005 22:04 GMT | 10 |
I am compiling a list every week with approxiamtely 7,000+ rows of data and 4or 5 columns of data. I want to able to make comparisons of the data but there is a problem. Each week the first column data will be slightly different which will prevent me from simply staking the new
|
| Display last row entered | 29 Dec 2005 21:57 GMT | 2 |
Hi, on a large Spreadsheet, with Data added daily, I would like the last row of Data added to display on Row 1 at A1, B1 etc. Please advise on the best option, is it by using the Vlookup formula?? Cheers
|