| Thread | Last Post | Replies |
|
| linked workbook | 28 Jan 2004 21:37 GMT | 1 |
Can you link a workbook off of a linked workbook? Source>linked book >linked book Thanks
|
| Making one cell display multiple things | 28 Jan 2004 21:24 GMT | 1 |
If I knew anything about coding checkboxes in excel, then this problem probably wouldn't exist, but unfortunately i don't, so here goes: Ok, if cell B1 isn't blank, then I need Cell A1 to display "damaged". If cell C1 isn't blank then I need Cell A1 to display "defective"
|
| Sort by month, ignore year | 28 Jan 2004 21:23 GMT | 7 |
I have a big spreadsheet that has dates ranging from 01/01/95 all the way to 12/31/06. What I need it to do is sort by month only, and ignore the year. So I would have a list of all in January, etc, not including the
|
| formula needed | 28 Jan 2004 21:22 GMT | 5 |
I have a spreadsheet that calculates our attendance, time off, overtime etc. and I need to count the following: If ST1 OR ST2 OR ST3 (this stands for 'straight time' and the number of hours worked) is typed in a cell, I need a
|
| Named Range in 3-D Formula | 28 Jan 2004 21:22 GMT | 3 |
I have need to insert a named range into a 3-D formula such as this ='C:\Work\[DataFile.xls]Sheet1'!$A$ replacing the column reference "A" with a named range (let's call it "NewColumn") that has a value for a new column reference, i.e. "B" Logically, the new formula should look ...
|
| Pivot Table Formatting | 28 Jan 2004 21:13 GMT | 1 |
Is it possible to custom format a pivot table output? It would be like using the auto format but only with customized fonts and color scheme.
|
| Duplicate Records | 28 Jan 2004 21:01 GMT | 4 |
I think I described my scenario wrong...excuse me, English is not my first language. I'll try this again. Every member has a unique seven digit number but some members have two. For example:
|
| Compare worksheets? | 28 Jan 2004 20:57 GMT | 1 |
Is there any way to compare one worksheet with another worksheet to determine which cells have different values between the two worksheets? I have a worksheet full of names and addresses which I've
|
| IF(AND(OR | 28 Jan 2004 20:56 GMT | 6 |
HOW DO I FIX THIS FORMULA SO I DO NOT GET A FALSE ANSWER. =IF(AND(D4=25),IF(OR(E4=100,F4=75),1,0)) D E F G 20 100 75 FALSE
|
| Excel inter-relating Worksheet IF functions.... | 28 Jan 2004 20:28 GMT | 5 |
I have a workbook with a Orders sheet, products sheet (for referenc on the orders page) I need a formula to give the price of a product automatically on th order page by using the Product number.
|
| Formula Displayed Rather Than Result | 28 Jan 2004 20:04 GMT | 4 |
I am trying to do a simple formula to concatenate the text string in column A with the same from column B, separated by a space. The formula is correct. =concatenate(a2," ",b2)
|
| Formula's in text | 28 Jan 2004 20:00 GMT | 1 |
I have a gift certificate template in excel. I have a cell that has a string of text that says "to redeem $xx off your next purchase" I would like to have the dollar amount reflect a cell inside the workbook so that I only have to change one cell and it changes the value in ...
|
| F-Test without population | 28 Jan 2004 19:51 GMT | 6 |
Can I run an F-Test if I know just the population count, average and population standard deviation? There are a lot of numbers in my Access database, and I'd like to leave them there. ion
|
| Sorting the contents of a cell | 28 Jan 2004 19:38 GMT | 3 |
I would like to sort the contents of a cell. For example, let us assume that cell A1 contains the text "SORTS". In cell B1 I would like to get the result as "ORSST" i.e. the contents of cell A1 but sorted.
|
| Locating duplicate entries using specific criteria | 28 Jan 2004 19:23 GMT | 3 |
I have a spreadsheet with multiple columns. I want to write a formula that will identify a duplicate entry based on the satisfaction of specific criteria (i.e., same payment amount, same adjuster name & same invoice
|