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 / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Yet another array problem30 Sep 2007 19:47 GMT3
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 Championship30 Sep 2007 17:53 GMT1
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 objects30 Sep 2007 13:35 GMT1
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 GMT1
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 Range30 Sep 2007 12:42 GMT2
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&GT DATA").Cells(1, i),
Help with IF30 Sep 2007 09:28 GMT2
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
Bug30 Sep 2007 09:22 GMT1
Try:
=68.60-60.00 =8.60
The answer is FALSE.
varible calculation30 Sep 2007 08:50 GMT7
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 sheets30 Sep 2007 03:15 GMT2
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 GMT5
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 Time30 Sep 2007 00:26 GMT3
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 question30 Sep 2007 00:06 GMT2
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 uploaded29 Sep 2007 23:48 GMT1
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 GMT1
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 formula29 Sep 2007 17:01 GMT9
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
 
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.