How would I do it the vacations are a little different, i.e. after 1 year of work they receive 5 days vacations for the 2nd, 3rd, and 4th year, vacation days...

I have a range of numerical data in a column sorted. I ned to rank these for an "if" arguement. I need to know the top 5% rated (A), next 10% (B), next 60%...

I'm trying to create a formula to calcuate vacations days, onee cell has # of days worked and I want another cell to calculate # of vacations by # of days...

I want to create a popup message for orders over a certain amount. We can generally process purchase orders up to a certain value without a quote. Anything...

I want to use the IF function to auto-populate a 4th cell (A4 , worksheet 1) by using several Define Names (PARTNUM,PRICE, and SPECIAL) AND based on a YES or...

I need to average a row some cells have 0's but I need to include them in the function so it averages correctly. The formula I currently have is...

I want to do this formula only 18 months instead of 547.5 days so it gives me exact dates instead of ballpark? Does anyone know...

i want to filter cells for more than one value and i dont want to do every time manually. like currently from the filter drop down manue I am selecting each...

S.O.S, help needed badly…the following macro: For Each Worksheet In ActiveWorkbook.Worksheets i = i + 1 If i ActiveWorkbook.Worksheets.Count Then...

Dear Forum, I would be very grateful if anyone can provide a solution to the following problem; I have a dataset as per the example below that consists of...

I have a column of numbers, that grows one cell per day. I need to find the difference between the previous day's cell and today's cell. The formula I use...

Hey all, I have a list of dates that occur every other saturday for the next year in excel: 7/26/08 8/9/08 8/23/08 etc... I need to look at a cell that is...

Hi. What function would I use to look for specific text in a cell, i.e. Rescind or Cancel, and return the value R or C in a designated cell?

Hi, I am trying to use the networkdays function to open a previous day's file. I am receiving an error that the function is not defined. Why do I need to...

Hi... I'm making a summary worksheet for raw transactional sales data seperated across multiple worksheets by territory. - The worksheets are labelled by...

Hello, I would like to be able to sum numbers in column I based on conditions in A,B,C . The formula below...

I have 2 columns of date. One with text and another with related numeric figures. I am trying to craft a formula which will extract the largest nth figures...

I am using the following formula to search for a "" in a cell and then trip off all text after it is...

Hi Guys I am currently using office 2007 I have a large spreadsheet that uses the following formula: =IF(G5/51,F5/g5,g5/f5) This produces a "div/0" error...

I a worksheet i have a list of different alarms on column D. Then on column C it states if its an "In" or "Out" alarm. So, I want to count in a different...