| Thread | Last Post | Replies |
|
| Left Lookup Custom function | 27 Dec 2006 18:51 GMT | 2 |
Hello all I am trying to write a custom function to do the work of my current function, so that all I have to do is type the custom function name in and select the cell. This is what I have so far, but is not working for me. As I am new to Custom Functions some help would be
|
| Parsing Names in Excel | 27 Dec 2006 16:16 GMT | 3 |
I have a list in Excel from A1:A100 with names like the ones mentioned below: Michelle Fooo (michelfoo@exchange.SASMOM.com) Myhaass Smith (mysmith@exchange.SASMOM.com)
|
| Web Query Help | 27 Dec 2006 14:56 GMT | 4 |
I'm having a difficult time with Web Queries. I have set up a web query that automatically updates every 10 minutes. I would like to save the data from each of the updates in a separate sheet. So far I have had no luck. Can anyone point me in the correct direction?
|
| HELP Please -urgent | 27 Dec 2006 14:49 GMT | 3 |
Hello every one, May be this is very simple question for every one, but i am stuck up and can not proceed because of this simple query. I have an Excel sheet with results. the following is final X
|
| Is there an array formula for text? | 27 Dec 2006 14:34 GMT | 4 |
By using the following array, I can call up the sum of corresponding numbers in column B as a result of conditions set in column A: {=SUM(IF(A1:A100=1,B1:B100))} However, I need to call up text instead of numbers in column B. For
|
| Caught out with cheating by using conditional formatting <g>. How to deal with via formula instead? | 27 Dec 2006 10:49 GMT | 5 |
Cell C5 is a value from another sheet in the workbook. However, I set conditional formatting to blank out B5 if B1, which is on the same sheet C5 is on, is blank. Now that I have added a formula that will use the value from cell C5, this workaround isn't working because C5 is ...
|
| How to add and remove spredsheets | 27 Dec 2006 06:34 GMT | 2 |
I need help how do i add or remove spredsheets from excel workbook with visualbasic 6. thanks
|
| A Drop down menu that eliminates selections | 27 Dec 2006 03:40 GMT | 3 |
I've been reading lots of posts and groups. And I can't find one describing how to do what i want. I have a list of options. Apple, orange, grapes. And i want to place one item in each cell in a column. I also want to eliminate the option as they are placed so that once
|
| Conditional formatting does not work with MATCH / VLOOKUP | 27 Dec 2006 02:08 GMT | 4 |
I do have two sheets and use conditional formatting. One sheet works fine. When I get a value on that sheet the other sheet with MATCH and VLOOKUP, and use the same conditional formatting on that sheet, CF does
|
| finding new template | 26 Dec 2006 21:19 GMT | 1 |
where can i find a gas station templates. templates that i can use for daily cash flows, register balance, end of day sales, and other templates that can help me better run my business better. i would appreciate it if anyone gives me a tips on how to approach this.
|
| automatic sorting in excel | 26 Dec 2006 20:35 GMT | 1 |
I would like to be able to have a column sorted alphabetically contiuously. In other words, whenever data is entered, the whole column gets arranged alphabetically without having to "click' on the sort function. I am not a power user of excel, but I now understand the basics of ...
|
| sumif vs sumproduct question | 26 Dec 2006 20:25 GMT | 4 |
I have a simple spreadsheet with column B containing all dates, and column D containing all numerical values. The dates range throughout a year. At the bottom of the sheet I've entered January through December in another column. To the immediate right of the month named, I have a ...
|
| Less points in graph | 26 Dec 2006 20:05 GMT | 1 |
Is there a way to lessen the number of data points on the graph? I would like to pick the entire column for the function, but to see in the plot only part of the point. Is it possible?
|
| Conditional Locking Of A cell | 26 Dec 2006 19:12 GMT | 2 |
Is there a method either within excel or or via a VBA macro to conditional lock cells in a excel spreadsheet The proble we are having is that we have a template spreadsheet and people are accidentally changing historical data. We would like to
|
| Data validation listbox still not working after troubleshooting | 26 Dec 2006 16:49 GMT | 1 |
The list box in each cell in ranges I've named are not working--only the top cell or record in the list box can be used for some reason. The list box, when clicked, does not even show the top value--just a blank field. Does anyone know why this would happen?
|