eomonth formula returns #NAME? despite Analysis Tools Pak having been added

Hi, 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% -...

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...

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...

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'...

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...

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...

The 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...

Is there a way to get rid of the "Top 10" and "Custom" options in the automatic filter?

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...

Hi, 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...

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...

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...

Hi, 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...

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...

I am using the Vlookup function looking up values in a Pivot Table. The problem I have is the column that I want to return is continuously changing. i.e the...

Hey, I have several sheets that have different information. I need to update the sheets regularly to another sheet which contains all the data the others have...

Hi I have a workbook that creates a monthly task calendar in one of the spreadsheets. in that sheet, there is a list of tasks in Column A, while Column B...

i need to create a drop-down list using the name of the workbook existing in a folder, so i can select one of them and run a macro...i saw this action once...

Hi there, I'm trying to figure out a better way to do this - since the formula is already too long for the cell (and I don't want to split it between two...