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 / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Comboboxes21 Nov 2006 10:05 GMT1
Hi. Hoping you can help me. I recently found out what a gret program Excel is
and how much you can with it; this is what I would like to do.
I would like to create a combobox with information. Depending on what the
user chooses in this combobox a different combobox will change it ...
Excel 2007 Table Styles21 Nov 2006 06:36 GMT2
If you create a new table style in Excel 2007 is it possible to save it
for use in future workbooks?
Thanks
Janet
Creating a new list with Last Order Date21 Nov 2006 04:10 GMT2
I do have a customer transaction history. I would like to get the
latest order date with amount in to another sheet instead of all the
orders under same account number and bring the rest of the
corresponding info to the other columns. Such as bill to information
lookup over multiple ranges21 Nov 2006 04:09 GMT1
I want something to the effect:
=if(iserror(vlookup(a1,range1,2,false)),vlookup(a1,range2,2,false),vlookup(a1,range1,2,false))
but I want to do this without using an if iserror function.  Is there a
way to do this?  An array formula perhaps?
Blank cells21 Nov 2006 01:54 GMT2
I have an exported file that looks something like this:
    A                                B
1   NAME                       AMOUNT
2   Indiana Finance          100.00
making frames in a spread sheet?21 Nov 2006 00:48 GMT4
Does any one know how to make a spreadsheet in to frames? i tried
freeze pane but what i really want is to separate the worksheet into
frames like a webpage, so if i scroll down the right side, the left
side and the top side won't mvoe...
RE: Excel data exported to custom Outlook form20 Nov 2006 23:32 GMT11
Greetings earthlings,
I have an issue that I have been trying to resolve for sometime, I think I
will provide the scenario and hope someone has an answer.  Here it is.
- I have Excel workbook called "users.xls"
Use of "--" in functions??20 Nov 2006 23:19 GMT3
I'm new to compiling and using functions of anything other than a
relatively simple basis.  I've been reading a lot of questions and
answers on this group and am amazed at some of the complex functions
that can be built up.
conditional formulas20 Nov 2006 23:01 GMT2
Please, I need help with these formulas . . .
1.) if worksheetC!C12 says "1" then I want worksheet D!E18 to say "1" , but
if C!C12 says "2" then I want D!F18 to say "2"
2.) if worksheet G!C12 says "G", thenD!I31 should say "G", but if G!C12 says
Sum a table of columns & rows20 Nov 2006 22:34 GMT4
I have a spreadsheet of 154 Rows (all unique project numbers in numerical
order) and 9 columns of account numbers (some are similiar and some are user
entered, therefore there could be 'blanks' with no data in them).  
I am trying to create a table that will only give me the ...
labels with excel20 Nov 2006 21:57 GMT3
How do I create labels from an excel spreadsheet?  I've followed how to get
it to mail merge in windows but when i get to the select recipient dialog
box, that's it, it won't put the info into the labels created in word
Missing OLE DB Providers in Excel 200320 Nov 2006 21:56 GMT1
I have a strange problem with Excel 2003. I've the full product
installed and I'm trying to connect to Analysis Services 2005. I've
installed the OLE DB Provider for SQL Server 9.0
When I try to connect to SSAS, I cannot select an OLE DB Provider as
Slow scrolling in Excel XP20 Nov 2006 21:53 GMT1
I work with Excel a lot.  I've come up against a few weird things in it
but this one I haven't been able to solve on my own and have not seen
it reported anywhere else so I thought I would post it up.
I have a problem with a large pricing model I have developed in Excel
Office2007 Laundry List of Gripes20 Nov 2006 21:52 GMT11
Some of these are admittedly nit-pickey... but they add up to what is a
truly horrendous User Interface and extremely disappointing version of
Office.
1) On my Silver themed WinXP, Word, Excel, and PowerPoint are BLUE, while
Business Objects and Excel20 Nov 2006 21:50 GMT1
I have a Business Object Report that outputs to an Excel spreadsheet. I
want to format the spreadsheet and save it before sending it out to
users.
The problem I have is that when I finish with the formatting, I cannot
 
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.