Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Convert Google Business Search Results to Excel?02 Oct 2007 18:03 GMT2
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 XML02 Oct 2007 16:33 GMT1
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 text02 Oct 2007 16:17 GMT2
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 GMT2
Type in a column
0.05
-0.07
0.02
Writing macro to format multiple worksheets?02 Oct 2007 15:07 GMT1
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 window02 Oct 2007 13:30 GMT3
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 integer02 Oct 2007 08:48 GMT3
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 rate02 Oct 2007 08:36 GMT2
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 file02 Oct 2007 02:14 GMT2
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 Fields02 Oct 2007 01:27 GMT1
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 GMT4
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 GMT8
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
SUMPRODUCT01 Oct 2007 23:59 GMT16
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 responsive01 Oct 2007 23:49 GMT12
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 GMT2
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 ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.