| Thread | Last Post | Replies |
|
| Highlighting cells in one column from a formula valuein another co | 29 May 2008 19:25 GMT | 4 |
I want to highlight any cells in column A (Cutomer Name) when the If formula (=IF(EM26>EN26,"Short DataPac's","Config is OK") in the cells from column EO return a formula value of "Short DataPac's"
|
| Worksheet autocalc with min function in error | 29 May 2008 19:24 GMT | 2 |
My worksheet has begun autocalculating cells I highlight with the min function results instead of the normal sum total, in the status bar area. I don't know how this happend (was on vacation) and now need to fix. Any suggestions.
|
| IF formula results not displaying | 29 May 2008 19:09 GMT | 1 |
I have an IF formula which will display the proper result in the functional arguments pop-up but not within the cell itself. I thought this was a simple format error on the cell but I verified it is set as a number but still displays "0" as the result. Formula is:
|
| calculate total number of items that meet 2 over multiple sheets | 29 May 2008 19:04 GMT | 5 |
I have several sheets setup from which I need to caluculate: how many of the cells in a range meet both criteria. It's setup something like the below: A B C D E F.... 1 y y n n y y
|
| unique records in specified range | 29 May 2008 18:59 GMT | 5 |
I have a very large table of non-unique items shipped; the table contains “item id” and “ship date” columns. I need to find the number of unique “item id-s” shipped in a given timeframe, ex. 01/01/08 - 03/31/08
|
| Return the filtered value into a specific cell | 29 May 2008 18:28 GMT | 4 |
I haven't figured out how to return the filtered value into a specific cell. I have a large spreadsheet where I filter 3 specific columns and I need those 3 specific filtered values (which are text) to be display in a different area of the same spreadsheet in a specific cell. ...
|
| what function/formula do I use? | 29 May 2008 18:11 GMT | 2 |
I have one sheet in my workbook with raw data entered daily. This information includes employee number, and scores. I want to pull scores from that sheet to a different sheet based on the employee number in order to calculate an average score. This should be easy, but I'm ...
|
| Hyperlink varaible substitution - How To | 29 May 2008 18:03 GMT | 10 |
My dilema is that I have a cumulative 3 month rolling report that takes input from 3 seperate workbooks that contain 12 worksheets each. The cumulative report cells have multiple hyperlinks (up to 9) back to the individual workbooks. eg.
|
| countif & subtotal functions | 29 May 2008 17:49 GMT | 3 |
I need the ability of both of these functions but combined. I would like to be able to count if All or Tops appears in my filtered list without having to filter on the column that contains these values.
|
| Removing Spaces In Cells | 29 May 2008 17:45 GMT | 9 |
Just wondering if it is possible to remove any SPACES/GAPS after text in cells? As I recieve data daily somtimes has gaps at the end of the text. This text gets copyed and pasted into another spredsheet where a script is
|
| is there a way to show what each cell links to? | 29 May 2008 17:44 GMT | 1 |
i have created a massive document containing 15 spreadsheets, some cells are linked on multiple sheets and i wanted to know if there was a way to click on the cell and it would show what other cells have it linked in their formula
|
| Request for formula to refer some letters from Cell | 29 May 2008 17:42 GMT | 8 |
COL-A COL-B 00XA10010253 5 00XXXA10012267 1 00XA20045682 2
|
| Adding new data to tables and charts in excel sheets from 97/2003 | 29 May 2008 17:42 GMT | 1 |
I would like to be able to add my new data for 2008 to existing tables and charts started in 2004. I can add the tables but then can't get into the charts to change the heading . Also, I am unable to use the redo/undo button. Appreciate any help you can offer.
|
| Excel-how to link source workbook to copy of destination workbook | 29 May 2008 17:36 GMT | 1 |
I have two source workbooks that are linked to a destination workbook. I want to make a copy of the destination workbook and retain the links to the two source workbooks. Then I want to change the name of the new destination workbook and retain the links to the two source ...
|
| Advanced Probability. | 29 May 2008 17:36 GMT | 10 |
I have a set of data that is 14 cells. I want to find the probability that the average of 5 randomly selected cells out of these 14 is over a certain point. HOW?!
|