| Thread | Last Post | Replies |
|
| Vlookup Question - Reffering to a column other than the leftmost? | 29 May 2008 04:48 GMT | 6 |
I have a table full of stats for a basketball team. It's laid out something like so: Player Name - Posistion - Pts/Game - Rebounds/Game - Asst/Game - High Score Lower down on the same page I have a spot for the High games of the year.
|
| Earned Vacation time Formula | 29 May 2008 03:54 GMT | 2 |
I think i have the formula down, but i keep receiving error messages. i think it is a bracket problem, but no one here understands enough to help. I've been looking at it for hours now and think i've just lost perspective. =if((today()>=Date(2009,01,01)),"",if(today()<=date(2007 ...
|
| How do I protect an object in worksheets? | 29 May 2008 03:14 GMT | 2 |
How do I protect only a specific object in worksheet? I just want to protect an electronic seal.
|
| **URGENT** - Using If Or And But functions ????????? | 29 May 2008 02:53 GMT | 2 |
=IF(BE8<$BJ$1,IF(BG8=".", "Yes",(OR(IF(BE8>$BJ$1,IF(BG8=".","No", "PIF")))))) This formula is not working properly BE = Date Due BJ = Today
|
| Re:"compile error in hidden module": DISTMOD -- ideas to fix it?? | 29 May 2008 01:44 GMT | 3 |
I get this error message now (appear out of nowhere recently) when I open a blank Excel project. I have no idea how the error occured, and have no idea how to fix it; or whether it's just an annoyance, or is affecting the functionality of all my Excel projects and files.
|
| how !! | 29 May 2008 01:11 GMT | 6 |
hello help me plz : given : in sheet 1 : A B
|
| Wrong Teaching of Excel | 29 May 2008 00:40 GMT | 6 |
I was recently concerned about an online tutorial for Excel I viewed recently for a course I'm doing. I was fortunate when doing a business administration certificate level course to get the basic back ground information on a number of tools and
|
| identify list used in a cell | 28 May 2008 23:57 GMT | 2 |
I have a spreadsheet used by mult people and we have three sections. I have created lists for each section and did a Data / validate / list to give them the correct options. Turns out that some have copied from one section to another and now the lists are mixed in each section. ...
|
| START UP FORMS FOR DOG WALKING BUSINESS (HELP ) | 28 May 2008 22:23 GMT | 1 |
I NEED FREE FORMS FOR A START UP (DOG WALKING ) BUSINESS THANKS. FATHIYYAH
|
| Drop Down Box containing a symbol | 28 May 2008 22:12 GMT | 2 |
I'd like to create a drop down option with just the square root symbol, no other options. Is this possible?
|
| need a formula to look up values in two columns | 28 May 2008 22:10 GMT | 2 |
Hi, I need a formula that will look at the value in the column D and bring in column E but if the value is 0 in Column D than i want it to bring it from column C. I hope someone can help me with this. A B C D E
|
| Analyzing Access Report with Excel | 28 May 2008 22:09 GMT | 4 |
I have a report that I want to analyze with Excel, and it's doing something that's very interesting, but I'm not sure what it is, and I don't know what you call it. (Note: for confidentiality purposes, I've blacked out the names of the advisors).
|
| Fixed 'Find' or 'Look up'? cell - is it possible? | 28 May 2008 22:04 GMT | 4 |
I have a spreadsheet shared by several people for looking up project data. I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay.
|
| Is it possible to display a worksheet within a worksheet? | 28 May 2008 21:58 GMT | 5 |
I have a worksheet that has data in 20 columns of various widths. I would like to display a different set of data in only three columns (of much wider withs) directly below. Is this possible?
|
| Formatting/Formulas | 28 May 2008 21:57 GMT | 2 |
I want to be able to have my cells highlighted yellow until I place information into them. I have done it before but can't rember what function to use.
|