Have 13 column by 10,000 row spred sheet. column A represents a salesmans number while column B thru M represent different products that the sales person can...

Need a formula for counting all the numbers starting with a 4 within a range of 1 to 100,000.

I have created a ranking sheet for sales performance that automatically ranks based on sales numbers. The rank formula works fine, but when ever I try to sort...

I want to reference the worksheet that is returned when I do a 3-D reference function. For example: If on worksheet "1" of 40 I have this...

I know this is probably the simplist thing, but I cannot figure it out. I put in the EXACT function via the tool, enter my values for cell1 and cell2. In...

Is it possible to print a worksheet within an excel document and show the comments that are generated within?

Have 3 wsheets for courier co. titled by name of driver. Need to enter delivery data in each wsheet and for it to show also in billing invoice worksheet. I...

Hi I get the following error message "Can't Find Project or Library" when I run the following code: Application.ScreenUpdating =...

Hi I have the following formula in cell B9 =INDEX(Sheet1!H:H,MATCH(B12,Sheet1!A:A,0),1) Which brings the result I need, but when I have other cells that link...

Thanks Biff that works fine, thanks for all your help it is appreciated. Bob "Biff" wrote in...

Hi I have the following...

I have a spreadsheet with a column of serial numbers comprised of both numbers and letters. I have formatted the column to "general" and am comparing it to...

I have 2 columns: names in column F and dates in column G. COL A COL B JET 4/1 JET 4/1 JET 4/1 FRED 4/1 I am trying...

Before in Office 2003 if I had a worksheet that I always used the same sort setup and I saved the worksheet it would always bring that sort criteria up when...

Howdy All, I am trying figure out a way to remove the front portions of a cell if the cell starts with numbers. If it doesn't I just want to copy...

I have a very long column 10K of numbers. I need to identify each cell which has a number before or after it which is equal to it.

How do I calculate a loan amortization schedule for a loan that changes interest rates after a few years?

Want the symbol to make the formula repeat in each new cell, but keep the second cell the same. Thought it was a karat, but that doesn't work.

I have several categories that are repeated numerous times. For example, most eaten fruit in the cafeteria... apples, oranges, bananas... I want to put in...

i have a list of scores with mutliple groups that i am trying to rank within each group. the RANK function only lets you rank by one range and not by the...