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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Problem with SMALL Function11 Jan 2007 16:17 GMT5
I am having a problem with the SMALL function in Excel.  I've written a
simplified example of the problem I'm having:
Example
     A
Excel 2003 - where is custom toolbars?11 Jan 2007 15:09 GMT4
I'm using Excel 2003.  I need to copy the customize toolbars from my pc
to my laptop.  I can't find the file *.xlb in my pc.  Where is custom
toolbars located?
Thanks.
Labeling 1st through 11th place11 Jan 2007 14:59 GMT1
I have an excel file that has 11 place standings and I want a column to
look at another column and label who has 1st, 2nd, 3rd, etc...  How
would I go about doing that?  I can get it to find the largest or
smallest number in the set but no the other ones.  I want it to update
Lookup row, dependant on cell value?11 Jan 2007 14:19 GMT2
I have a sheet,  as per the example. I need to insert into column A the
quantities, depending on the value a specfic cell.
I.e if week 2 is entered, the column A should read, 12,5,2,3,3,3 and if Week
1 is entered 5,3,2,3,2,2 etc
Counting (with filter) formula11 Jan 2007 13:39 GMT4
I'm wondering if there's any formula / another way to have a formula
that calculates number of rows in another sheet with specified filter
conditions. Eg. in sheet1 / cell A1 I want to have a number of rows in
sheet2 where Z column value is higher than 2, and cell A2 = number of
amending an EXCEL worksheet11 Jan 2007 08:08 GMT3
Firstly I have a worksheet with an array of single letters in each cell
(they are grades for subjects in a school). I need to create a parallel
worksheet where the letters are one grade higher than those in the original
worksheet, i.e. if in cell A1 of the original worksheet ...
Pivot Table Display Question11 Jan 2007 07:50 GMT3
Please excuse me if this is a very simple question, however I can't
seem to figure it out:
I have a pivot table whose data looks like the following
RELEASE #         JURISDICTION           REVENUE
How to create a TXF file in Excel or Export XLS to Money?11 Jan 2007 07:48 GMT1
Yes, tax time again.  Turbo Tax and other Tax software accepts .txf (tax
exchange files) from MS Money.   Excel does not have the option to save
as .TXF files.   Is there a way to convert .xlf files to .txf files or to import
an Excel file into money and convert to a .txf file so ...
Copy formula11 Jan 2007 02:47 GMT4
I need to copy a formula to the right and have the column in the formula
remain constant but the row increase by one for each column to the right I
go. For example if in cell A10 I enter =A1 then copy that to the cells to the
right, it makes cell B10 =B1 and I need it to =A2, C10 ...
MS Excel: Linking spreadsheet and Absolute and Relative Paths11 Jan 2007 01:33 GMT6
Our staff uses several spreadsheets, many of which are linked to
SEVERAL other spreadsheets.
Of course, all of these documents are stored on the network.
The problem we are having is the absolute path that the link uses.
Text in Pivot Tables10 Jan 2007 21:18 GMT4
When doing a Pivot Table is it possible to have text instead of numbers
in the table?  If so, how can this be done.
Greg
CHIINV10 Jan 2007 20:40 GMT1
I have some questions on CHIINV() computation on Excel.
According to the help files:
If degrees_freedom is not an integer, it is truncated.
If degrees_freedom < 1 or degrees_freedom = 10^10, CHIINV returns the #NUM!
Display number as negatiove always10 Jan 2007 20:28 GMT4
Easy one for you pros (I think).
Is there a way to set up a cell to always display a number typed into
it as a negative number? Thanks for any help.
Squirrely Cursor Arrow Keys10 Jan 2007 20:14 GMT3
Suddenly my cursor arrow keys are behaving strangely in Excel 2003
11.8117.8107.  Traditionally when I hit the down arrow key, the selected
cell drops down one row, etc.  Now if I hit the down arrow key, it drives
the window elevator on the right down a notch -- so the selected ...
separating the value10 Jan 2007 20:13 GMT1
In one cell I have name in this format XXX - XXX - PHOENIX, XX. My
requirement is that the out should show PHOENIX.
Please help.
Thanks
 
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.