| Thread | Last Post | Replies |
|
| Nested SUMIF function | 02 Mar 2005 08:55 GMT | 1 |
Is it possible for me to use SUMIF function in nested form? Sumif(Sumif(Sumif))) Me
|
| I need help with this formula | 02 Mar 2005 07:04 GMT | 7 |
If B2 is exactly 0.250 then C2*D2*.098*E2, and If B2 is exactly 0.375 then C2*D2*.123*E2, and If B2 is exactly 0.500 then C2*D2*.168*E2, ect. This fomula would be in F2. Basicaly it's for calculating weight. B2 is thickness, C2 is width, D2 is
|
| VLOOKUP from different sheets | 02 Mar 2005 04:22 GMT | 1 |
I am trying to VLOOUP from other sheets. Exemple: I have 3 diffrent recipec in 3 different sheets in column A the weight value and in B the description of ingredient. In sheet 4 I want to have a list in
|
| Inserting custom worksheets | 02 Mar 2005 03:19 GMT | 2 |
I have an application that uses customized VBA Worksheets. I originally stored the templates for those in the default location for such, but due to need to make it compatible with different versions of Office will put in the application's folder.
|
| link to a hyperlink cell | 02 Mar 2005 02:42 GMT | 5 |
A1 = hyperlink ("http://www.google.com/","link") A2 = A1 Then A2 doesn't have the hyperlink, how can i get it? Many thanks
|
| need a template for a service biz proposal form | 02 Mar 2005 01:43 GMT | 1 |
looking for something that is not just a standard text template, like the one that is at the MS office update site. I want a form that I can print out and write construction job proposals on. I'd hate to have to buy a program and pay the 150 bucks for 1000 forms,
|
| Combine the contents of two cells. | 02 Mar 2005 00:33 GMT | 3 |
I want to copy the contents of a cell and insert it at the beginning of the text of another cell: ie I want to combine the text contained in two cells into one cell. I can do it manually but would like to use a macro as I have a lot of cutting and inserting to do!!
|
| converting text to formulas | 02 Mar 2005 00:12 GMT | 1 |
Is there a way to convert text to a formula? I have a pattern of data that I am trying to convert to formulas. In one column I have a pattern of A,A,A,A,B,B,B,B,C,C.... In the next column I have numbers 1,2,3,4,1,2,3,4,...
|
| Conditional Formatting and Borders | 01 Mar 2005 23:14 GMT | 4 |
I'm trying to add thick borderlines on my spreadsheet using conditional formatting. But the "thick" option is not available. I observed the code using the macro recorder which produced Sub ConditionalFormat1()
|
| saludo | 01 Mar 2005 22:36 GMT | 1 |
|
| Copy and paste last row | 01 Mar 2005 22:26 GMT | 6 |
Hello to all. ?how can I copy the last row (with data, obviously) in sheet1 in a workbook named "first" in the first blank row of the sheet1 in another workbook named "second"?
|
| CONTROLING A PAGE IN MULTIPAGE | 01 Mar 2005 22:22 GMT | 2 |
hello my friends, I have a multipage with 5 pages. I have make button to change page forward or backward. How i can disable the events of mouse click who change page in a
|
| analysis toolpak for mac excel v.x | 01 Mar 2005 22:04 GMT | 1 |
Excel v.x for Mac doesn't have the Analysis ToolPak installed, or even available in the Add-Ins option under the Tools menu (at least, my copy doesn't). Does anyone know where I can download it? I've tried looking thru microsoft.com and mactopia.com, but I haven't found it.
|
| Faxing from Excel 2003 | 01 Mar 2005 22:02 GMT | 4 |
When I FAX using Microsoft FAX in Windows XP, only one sheet of the spreadsheet goes to FAX. There are 3 sheets in the workbook but only the first one goes to the FAX. What can I do to FAX all 3 sheets at once? There are exceptions, but we cannot find the difference between those ...
|
| full cell text | 01 Mar 2005 22:01 GMT | 2 |
i am wondering what the proper "format cell" alignment values should be used to see all of the text in a cell. When you want the cell to grow vertical when more text is added to the cell. i click wrap text, for horizontal i use justify, or fill.
|