| Thread | Last Post | Replies |
|
| Yet another array problem | 30 Sep 2007 19:47 GMT | 3 |
Could use some help with this matrix problem. I'm continuing to try, too. Just looking for a leg up. I'd like to have a spreadsheet with 6 worksheets worksheet 1 is Focus
|
| F1 World Championship | 30 Sep 2007 17:53 GMT | 1 |
I am interrested in the permutations of the world champinship with only 2 races to go. Other than listing out each combination that is possible ie (10, 8, 6.....down to 0,0,0) is there another way I can see what needs to happen for Raikonnen or ALonso to win the championship ...
|
| Spreadsheets as OLE objects | 30 Sep 2007 13:35 GMT | 1 |
Hello, I have a table in Access and in each record of that table is an Excel worksheet embedded as an OLE object. Copy and paste works in the selected worksheet, but when I try to copy and paste a range of cells from one embedded worksheet to one in another record the information ...
|
| How to change decimal separators when importing text (csv) files? | 30 Sep 2007 13:14 GMT | 1 |
I have a problem importing text files into Excel 2007. I'm currently working on a German version of Excel 2007 running on a German version of Windows XP Pro. Whenever I try to import data from a text file (csv), every number with a decimal separator is recognized
|
| Named Range | 30 Sep 2007 12:42 GMT | 2 |
I've named few ranges through VBA by using this code For i = 1 To 15 ' Define the name for the variables ActiveWorkbook.Names.Add Name:=Worksheets("ST> DATA").Cells(1, i),
|
| Help with IF | 30 Sep 2007 09:28 GMT | 2 |
I've used the following to calculate a multiplied unit cost per kilo with a minimum charge of 194. =IF(B2<100,194,B2*1.94) Now I want to allow a lower charge of 1.84 for multiples over 999
|
| Bug | 30 Sep 2007 09:22 GMT | 1 |
Try: =68.60-60.00 =8.60 The answer is FALSE.
|
| varible calculation | 30 Sep 2007 08:50 GMT | 7 |
I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40
|
| Compare 2 sheets | 30 Sep 2007 03:15 GMT | 2 |
I've got 2 sheets, both of which have a column of 1500+ names, followed by some columns of other info. The list of names in the two sheets are mostly the same, but not every name will be in each list. Sheet 1 also contains a 'Flag' column which will have either an "X" in
|
| Vlookup found what it was looking for, but what cell was in in? | 30 Sep 2007 02:57 GMT | 5 |
I need to do an OFFSET(???, 3,2) The ??? would be the cell that a VLOOKUP found the Lookup_Value in the Table_Array. or
|
| Adding and Subtracting Time | 30 Sep 2007 00:26 GMT | 3 |
I G22 and H22 I have the following: 8:00 am 9:05 am In cell I 22 I have the following formulal: =IF(H22="","",(H22-G22)*24)
|
| Basic Formatting question | 30 Sep 2007 00:06 GMT | 2 |
I am trying to do a school assignment and am struggling with angled headings. I am having a hard time explaining exactly what I want to do, so I attached a picture at this location: http://www.quickeq.com/images/excel.JPG
|
| loan website has been uploaded | 29 Sep 2007 23:48 GMT | 1 |
Hi, the website url is www.loans-website.com thanks 441 google adsense websites only at www.louisneill.com
|
| Restricting more than x number of characters in a cell.... | 29 Sep 2007 21:32 GMT | 1 |
I have a macro that refreshes a web query. The data that it pulls changes format quite often. Is there any way to limit the number of characters pulled or shown in a cell/column?
|
| help with currency formula | 29 Sep 2007 17:01 GMT | 9 |
IF(D18<>"",D18*K18,"") D18 is time expressed as hours in decimal fractions - i.e., 5.5 equals 5 hours and 30 minutes. K18 is a dollar amount expressed as an exact currency value, i.e., $17.50
|