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 / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
eomonth15 Mar 2007 13:51 GMT3
eomonth formula returns #NAME? despite Analysis Tools Pak having been added
Creating a formula calculates time impact on achieveing sales quota15 Mar 2007 13:35 GMT1
Please I need a help on the following!
I am a salesman (for instance) and I have a target of 1,000 USD to be
achieved on Jan. 15th with a weight of 30% - I did achieve the target
but on Feb. 1st.
I want to delete duplicate in one time15 Mar 2007 13:28 GMT2
Dear Sir,
Here I am working in a excel sheet and I am making item code detail. but
some item codes are showing dulicate I want to delete all duplicate code in a
one times can u pls.give me short command.
GROWTH too aggressive, TREND too conservative - what to do?15 Mar 2007 12:30 GMT2
I am working on projecting some data that is non-linear. the TREND function
gives me a line that is too conservative in its estimates, but GROWTH gives
me an exponential line that is way too aggressive.
Is there another function I can use?
How do I automatically copy data from one sheet to another?15 Mar 2007 12:08 GMT1
I have a workbook which consists of a summary sheet, a master sheet, and a
number of sheets which have been copied from the master.  The individual
'event' sheets consist of headings and variable data in the next cells which
cover a few columns and rows.  The following rows ...
How do I import external data and create two formats?15 Mar 2007 12:07 GMT1
I want to import external data with two types of rows.  On the top should be
a title
with different widths, and on the bottom will be the data.  Both of these
types of data are coming from the same external source.  I am using excel
entering 1 cell fills the worksheet15 Mar 2007 10:53 GMT1
I am trying to create an fool proof seris of worksheets where if you enter
the name of the dealership only the rest of the information will appear. I
have seen it doen once before. we have 7 dealerships. Can anyone help me
Problems with HLOOKUP and VLOOKUP15 Mar 2007 09:32 GMT1
The letters A, B and C [also word starting with letters A, B, and C] do not
lookup and give an N/A message BUT all the other letters from D to Z works
fine. Any word works fine and lookup fine, exept those starting with the
first three letter of the alphabet; for  example ,Conor ...
Automatic Filter Options15 Mar 2007 07:20 GMT1
Is there a way to get rid of the "Top 10" and "Custom" options in the
automatic filter?
Automatic Filter Options15 Mar 2007 07:19 GMT1
Let me rephrase that:  Is there a way to get "Top 10" and "Custom" from not
appearing in the in the filtered list.  Or at least moving them to the bottom
of the list.
Creating a formula15 Mar 2007 06:06 GMT1
I'm trying to create a pricing calculator where I can just input the Paper
type and quantity and returns the pricing amount according to the pricing
bracket.
So for example I want to print 16 x 160gsm sheets, I want to formula to
Ranking Function15 Mar 2007 05:50 GMT4
I have a worksheet with data in column a1:a10 and a ranking column in b1:b10.
I need to skip ranking a3, a6 and a9 but I need to leave the data in the
cells the way they are. What function can I use to do this? The Ranking
function doesn't seem to like skipping cells.
vijay 515 Mar 2007 05:11 GMT2
Kindly advise some suggestion for the following:
My data is in 2 columns one column is brand code and other is number which
should be generated by excel with a condition that excel should check up for
the last existing number in sheet and add one number to that existing number.
Creating a sliding scale discount15 Mar 2007 04:58 GMT1
I am trying to work out a formula for creating a sliding scale discount. I'm
trying to create a pricing calculator spreadsheet for a printing company. If
you buy 1 -5 copies the price is X, 6-20 copies the price is Y, 21-50 copies
the price is W and so on. What is the best way of ...
Syntax for using variables in a cell formula to reference paths/fi15 Mar 2007 04:41 GMT4
Ok, I have data in several other exel files that I want to link to in several
formulas throughout my spreadsheet.
For example the data in the other worksheets I linking to are:
'H:\Financials\2007\January\[Plant1 Statistics.xls]Worksheet1'!B$26
 
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.