| Thread | Last Post | Replies |
|
| Convert Google Business Search Results to Excel? | 02 Oct 2007 18:03 GMT | 2 |
Is there a tool or a method for converting the results of a google business search to excel format? so that you could have separate cells for business name, address, and phone number? thanks!
|
| Exporting denormalized data to XML | 02 Oct 2007 16:33 GMT | 1 |
I have some data in Excel that is denormalized. Looks like this: RowID RowName RowSegID StartX EndX StartY EndY NumSeats 2 1 2.1 0 7.92 0.2 0.2 16 2 1 2.2 9.1593 17.0798 0.2 0.2 16
|
| Conditional format for duplicate text | 02 Oct 2007 16:17 GMT | 2 |
I have been given a spreadsheet with about 16,000 rows of data, each line including an alpha-numeric reference number. I have been asked to easily flag up duplicates and have tried to do this with conditional formatting using
|
| Excel is calculating strange since a long time ... (0.05+(-0.07)+0.02+0) =? | 02 Oct 2007 16:08 GMT | 2 |
Type in a column 0.05 -0.07 0.02
|
| Writing macro to format multiple worksheets? | 02 Oct 2007 15:07 GMT | 1 |
Beginner in Macros, willing to learn a lot in short amount of time. I am in need of information on how to write a macro that will format the spreadsheets across multiple worksheets? [vs only working cell specific]
|
| canceling new window | 02 Oct 2007 13:30 GMT | 3 |
Using Win XP and Excel 2003 I have a workbook with 3 worksheets. At one point I opened a new window and arranged them vertically so that I could do some data comparisons between sheet 1 and sheet 2. When I was done, I did not close the extra window; I
|
| converting time to integer | 02 Oct 2007 08:48 GMT | 3 |
I'm need a difference in time as minutes for a pivot table. Here's the problem. I've set a column (difference) as time1 - time2 and formated difference as [mm] which shows me the correct number of minutes. I need to convert this column to an integer so that I can group it in a ...
|
| entering VAT rate | 02 Oct 2007 08:36 GMT | 2 |
Setting out a spreadsheet with VAT calculations. VAT rate is entered in a single cell as a reference and formulas refer to this cell to make various calculations. However when I use the copy function to copy the formula down the page to
|
| Excel2007 Replace formulas with {=#Value!} when saving file | 02 Oct 2007 02:14 GMT | 2 |
The file is in Excel 2003 (created in Excell 2003) format. "FileName [Compatibility Mode] ..." displayed on title bar when loaded in Excell 2007. There are several worksheets in the workbook with array formulas referring to other worksheet. When saving the file a message pops up ...
|
| Renaming Page Fields | 02 Oct 2007 01:27 GMT | 1 |
I have a macro that cycles through a pivot table page field, then extracting data from the pivot generated by each page field. Recently, the code entered a page field value that didn't exist in the underlying data, and I now have several items in this field that have been ...
|
| How do I create a formula repeated on the adjacentt columns? | 02 Oct 2007 00:55 GMT | 4 |
I am trying to make the same operation for each column - the only difference is in the rows, e.g. C3=A3*B* C4=A4*B4, etc.
|
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | 02 Oct 2007 00:15 GMT | 8 |
Hello Excel Experts, I write you again on this issue, sadly still unsolved. I've received some replies, but none that are fully workable (or ones that I could get working.) I've decided to give this another shot, as I've received
|
| SUMPRODUCT | 01 Oct 2007 23:59 GMT | 16 |
Can anyone help me making use of the Formula "SUMPRODUCT" within the below file? http://www.flypicture.com/download/MzcyMjA= Thank you very much
|
| Excel 2007 - non responsive | 01 Oct 2007 23:49 GMT | 12 |
Background: The issue is on a Vista system running Office 2007. The user is creating an excel workbook with 5-7 worksheets. The 1st 2 worksheets have 1000 - 6000 records, the rest of the sheets are graphs and charts that are created from those records. In one of the charts she is ...
|
| Is it is possible to merge data from 2 cells into one? | 01 Oct 2007 22:28 GMT | 2 |
I am trying to merge to colums of data into one. I've tried the =A&B formala but I'm having to type each row individually. Is there a faster way to combine them, or am I just not doing it right? I'm not very computer smart so the lingo etc. escapes me. Please help. It's like 300 ...
|