| Thread | Last Post | Replies |
|
| How do I do conditional formatting? | 30 Jun 2006 18:47 GMT | 1 |
I work in television and have a long report that pulls ratings for a number of shows on a number of different stations. I want to be able to change the color of an entire show depending on the station. For example, if program airs on station A change the font color of the ...
|
| Compare 2 columns and choose one and enter answer in third column | 30 Jun 2006 18:17 GMT | 1 |
New here and so far you all are absolutely wonderful!! I have one problem here that I can't seem to find a solution to.... 2 part problem: PART 1
|
| Multiplying ounces for PO | 30 Jun 2006 18:13 GMT | 2 |
When doing bulk mail, I have to weigh a single piece and then multiply it by the $ of peices. Weight of each piece is in ounces(obviously not liquid). The weight of a single piece is 1.8 ounces and say I have 400 of them...what is the total weight? Using a simple
|
| How to set a back ground picture in an exel file | 30 Jun 2006 18:03 GMT | 2 |
Please clarify how to set a back ground picture in an exel work sheet
|
| Determinig Population membership percentages | 30 Jun 2006 17:57 GMT | 1 |
A1 is town population B1 is our membership in town C1 I want what percentage of the town population we captured I DID look at posts but nothing I tried worked out.
|
| Where are Bitwise Operators | 30 Jun 2006 17:51 GMT | 1 |
How does one do bitwise manipulations such as exclusive-or (XOR), AND, etc.?
|
| A #DIV/0! With IRR Function | 30 Jun 2006 17:51 GMT | 2 |
I have been asked for an explaination from our Finance guys as to why the IRR function works on one set of data but not on a second set almost identical:- I personaly have never used the IRR function so am unsure of how it
|
| How do I obtain the Average Values between 2 dates? | 30 Jun 2006 17:50 GMT | 5 |
I have 2 worksheets. One named Daily, one named weekly. The A columns o both sheets have dates. Daily has every business day (includin holidays) and weekly has every Friday(including holidays). The columns contain volume that coorelates with the dates. What I woul
|
| If, then question | 30 Jun 2006 17:06 GMT | 3 |
I have a column that may have hundreds of different entries. The entries are not values; they may appear to be a value, e.g., 01252534 but it is actually a label, or they may, and often do, appear more like this: SD000362. Each entry is tied to a specific code, e.g., UU5C.
|
| How do I concatenate two currency cells to show a price range? | 30 Jun 2006 17:03 GMT | 5 |
I have one median price, which I would like to change to a range (from 90% to 110% of original value). Example: Cell A1 is formatted for currency and has a value of 3.50 (symbol set to none)
|
| VLOOKUP Problem | 30 Jun 2006 16:52 GMT | 6 |
I am trying to have one Excel file pull up a price from another Excel file. In cell B3 I type in my part number, B4 is going to be the price. I want B4 to look through column A in another workbook to find the part number (from B3) and then look in column B of the same row to find ...
|
| Creating a formula to populate information from multiple cells in another workbook | 30 Jun 2006 16:17 GMT | 8 |
I'm trying to create a spreadsheet for work to track employee check in times for safety reasons. What I am looking to do is have an employee open the safety spreadsheet, and by inputting a tech's employee ID, to have it
|
| How can I do SUMIF AND OR | 30 Jun 2006 16:05 GMT | 3 |
Can anyone help me put the below into a formula? What I want to do is: If ColA = "LN" and Col B = "75" OR "76" OR "712" then SUM ColC Thanks all.
|
| can I put units in MS excel like 200 mm in formulae ? | 30 Jun 2006 15:21 GMT | 1 |
I am working on a MS excel sheet that involves lots of calculation ... my units are mm and m , I have lots of formulae that need to be put with these units ... can you please help me
|
| How do I enter a formula that counts the duration spent | 30 Jun 2006 15:13 GMT | 1 |
I am creating a statics sheet in excell and need to calculated the total time spent on several different clients/projects in a day to show the total time spent. Does anyone have a formula for this please.
|