i picked top10 values with the help of the large formula from an array of values, on that i wrote match function, with the help of the match function values...

I have a list of data that I download every week. Product code in col A, product starting date in col B (this is not a calendar date, it's a week number:...

Hello I have a question on how to execute what in my mind is easy to conceive but hard to execute. I have a Test Case spreadsheet and I want to implement a...

Is there anyway to click on a cell in an Excel Spreadsheet and bring up some sort of text box where one could list information about the item. After posting...

I am trying to create a formula that will identify the number of sales for a particular course on a monthly basis. This information will be fed to cells on...

Sheet 1 column a has sales reps Sheet 1 column b will contain formula that will add up all sales gather from sheet 2 Sheet 2 contains source data for entire...

I have no clue what the x "data point" is. Can someone please enlighten me in layman terms, maybe with a basic example? Thx -- Gator

I am trying to calculate a delivery date based on an vessel departure date on my worksheet (K512) and the location (N512), adding a specific number of day...

Help! How do I get a true sum? Ex: A1 - 78,661.23 A2 - 3,612.66 A3 - 15,732.25 Total 98,006.13

I am building a worksheet where I want to be able to create a number of copies of an existing sheet. The purpose of this is to create a detailed budget by...

Let's say the leftmost column of my pivot table is Months, the next column is Product and the data is dollars sold. If I have many products sold in the...

How do I change text to numbers then back to text? My file has 4 worksheets. Sheet 1 - Copy from the "copy sheet" - process type (text) check amt (numbers)...

I would like to know if there is a way to do the following: File #1 Product Key Count Red/12 1000 Red/24 2000 Green/36 3000 File#2

I am using the formula =(SUMIF('Tech Ops Data Base 2007.xls'!TechallDate,C$36&$A37,'Tech Ops Data Base 2007.xls'!sales))/SUMIF('Tech Ops Data Base...

I am currently working for a large client based in the UK. I have a workbook which has links to a number of other workbooks. The folder structure...

I am trying to calcualte number of years an employee has been with the company from today's date. I can't seem to find a formula that will help me with...

I have a 12 digit number in one area and doing the vlookup seems to be only looking at the first 6 and rouding at that point. I need the lookup to look at...

The logic of my statement is; IF N16$K$10, AND R160 then “Yes� Else “No� and I'm not sure how to write it in Excel. Can anyone help?

I have some 20000 data for lottery in sheet 1 like :- Sl No. Application No. Reg. No. Chque No. Name 01 17211 7552 ...

Hi, I have a worksheet with one tab for each day of the month (lets call it december). All tabs have the same template. I created another worksheet that...