| Thread | Last Post | Replies |
|
| eomonth | 15 Mar 2007 13:51 GMT | 3 |
eomonth formula returns #NAME? despite Analysis Tools Pak having been added
|
| Creating a formula calculates time impact on achieveing sales quota | 15 Mar 2007 13:35 GMT | 1 |
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 time | 15 Mar 2007 13:28 GMT | 2 |
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 GMT | 2 |
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 GMT | 1 |
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 GMT | 1 |
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 worksheet | 15 Mar 2007 10:53 GMT | 1 |
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 VLOOKUP | 15 Mar 2007 09:32 GMT | 1 |
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 Options | 15 Mar 2007 07:20 GMT | 1 |
Is there a way to get rid of the "Top 10" and "Custom" options in the automatic filter?
|
| Automatic Filter Options | 15 Mar 2007 07:19 GMT | 1 |
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 formula | 15 Mar 2007 06:06 GMT | 1 |
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 Function | 15 Mar 2007 05:50 GMT | 4 |
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 5 | 15 Mar 2007 05:11 GMT | 2 |
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 discount | 15 Mar 2007 04:58 GMT | 1 |
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/fi | 15 Mar 2007 04:41 GMT | 4 |
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
|