I need to figure out a formula to be able to use a grade and a percentage of a grade to create points example: grade 80-weight 2% -Points1.6 So I need a...

I am new to vlookup. i have figured out the argument, but want to enter part of a name or an incomplete name and have vlookup find the name in the other...

I have cells that contain statements like ASL- Auto Selection Logic. I need to take that cell and break it into two cells. One cell would be ASL and hte...

I need to delete the row above if the value $c2 is less 2 minutes (0:02:00) Thanks for your help - Ian McDonald -- 602 952 2526

I have a spreadsheet with locations from a warehouse. We have 2 deep racks for each location, so multiple pallet id's can fit in those racks. I would like to...

I have a protected worksheet that needs to have the ability to add rows that will be identicle to the current rows in protection and formulas. All other cell...

I'm setting up a master worksheet to pull data from various external workbooks (some of which aren't yet populated). I am using the following formula to...

I received an xls file that has customized help text showing up in an animated help bubble when I move the cursor over the various columns. The creator of...

I want to look in two columns. I want to look in the first column for a cell that matches the data in another cell. And with that value, I want to find a...

A good day everybody I am looking for some changes in a formula , to get best speed for calculate it by excel application . My first formula was...

I am currently using the following formula to calculate work hours. As it happens on the time of measurement not all requests are finalised and I am getting...

I have been using a networkdays formula in my database eversince I started it, but now when I try to either copy or create an new networkdays formula in the...

Please help me with the following problem. I did try to read through several threads pertaining to IF and ISBLANK statements but none of them seem to have...

HI I transferred my Excel 2003 files to A Vista machine. When I make any changes to any of the workbooks and go to save them as normal it's saying that they...

I have a spreadsheet that is shared and there can be up to 12 people using it at the same time. The Column A is Work Order number and Column H is Submitted...

Hi I am working on a workbook with identical sheets formats for a project costing what i need is a summary sheet that allows me to know the total of working...

Hi Excel geniuses I cant figure this one out. Can you help pls? Imagine a time line left to right in monthly increments on a worksheet (A say) and rows...

HELP!!! I'm doing a formula and I'm trying to get it to look at the last row in column B every time I paste information in the worksheet I have included my...

Hi All, i am trying, without success to creat a formula to do the following: i have a series of values in a column and want to show how manay time a number...

What methodology will provide better performance (mainly speed) for returning a data from a table: Vlookup or Index/Match?. Many thank, Dan