| Thread | Last Post | Replies |
|
| PivotTable Question | 01 Jun 2006 00:25 GMT | 3 |
I have a large database that looks like this: Date Time New Price 20060314 95511 -0.4 20060314 95513 1
|
| search for and return more than one row in a sheet | 01 Jun 2006 00:14 GMT | 1 |
Ok, here's what I need, I need to be able to enter a school number into a cell, hit enter or click a button or something and have all the rows with the matching school number from a different sheet show up in this sheet. here's an
|
| Need excel formula help | 31 May 2006 23:56 GMT | 1 |
How do I find the larger amount of 2 cols, then get difference between that amount and 3rd col? Thanks
|
| How to convert Euro's to Canadian dollars? | 31 May 2006 23:15 GMT | 1 |
I have a budget in Euro's which needs to be transposed to Canadian dollars - the Euro conversion table does not give me the 'to' option of selecting Canadian dollars.
|
| HIGHLIGHTING | 31 May 2006 23:08 GMT | 1 |
I CAN ONLY SEE MY HIGHLIGHTING IN PRINT PREVIEW BUT I CAN'T SEE IT WHEN I AM EDITING THE WORKSHEET.
|
| Another SUMIF question | 31 May 2006 23:04 GMT | 9 |
My book is telling me that I can't use multiple conditions with a SUMIF statement but other sources are telling me I can. Either way, it's not working! My situation:
|
| Help With A Tricky SUMPRODUCT Function | 31 May 2006 22:47 GMT | 2 |
Hello All, What I currently have is: =SUMPRODUCT(('Daily Tracker'!C4:C115="Aircard - Connectivit Issue")*('Daily Tracker'!B4:B115={"Ait-Hamou, Achour","Antoine
|
| Upcoming Date alerts | 31 May 2006 21:50 GMT | 9 |
Is there a way I can have an Excel 2003 worksheet notify me of upcoming dates? Ex: I have a spreadsheet tracking safety course expirey dates, and would like to have the cells highlight prior to that date, say 1 month in advance. Will conditional formatting do this, and if so, ...
|
| fromatting formulae with text & dates | 31 May 2006 21:40 GMT | 2 |
I am trying to format a formula ="yesterdays date"&DATE(YEAR(A1),MONTH(A1),1) I want to format the date to equal MMM-YY how would i go about this?
|
| numbers automatically format | 31 May 2006 21:38 GMT | 1 |
When I input a # into a cell, even though the cell is not formatted, it automatically removes two decimal places. For example if I input the number 2, when I press enter it shows .02, it is not formatted for percentage or for currency but general number.
|
| How do I repeat an item in multiple formulas w/out retyping each | 31 May 2006 21:28 GMT | 1 |
Several formulas across a row in each cell with the same base item. Is it possible to auto fill item without having to type it over and over again to add it to the formulas?
|
| Program "Enter" Key | 31 May 2006 20:48 GMT | 4 |
How can you program the "ENTER" key to enter a new line in an Excel Cell?
|
| need help with drop box please!! | 31 May 2006 20:34 GMT | 3 |
ok, I was asked to make a value, lets say AA have a drop box that means mislocation of part. So that when you type AA you will have the drop box come down telling you what it means. I have no idea how to do this though. can someone plesae help me!
|
| Adding and Deleting rows - update formulas help needed. | 31 May 2006 20:30 GMT | 1 |
I have built an evaluation scorecard and want to be able to allow others to use it without always having to do it for them as they know nothing about formulas. I have multiple rows that have a seperate weight factor
|
| Inconsistent results with =LOOKUP? | 31 May 2006 20:21 GMT | 2 |
I am using Lookup across 2 worksheets. Where lookup finds a match, the result vector seems to work fine (too many rows to check them all). However, when no match is found, the result vector either returns a '1' or (in one instance only) a #N/A error.
|