i have the following formula to give a 2 day cycle for production which will skip saturdays and sundays. can it be made to miss other days such as public...

I am trying to do something that seems impossible. I am a paramedic and use a mobile device during the course of my job. I am trying to write a spreadsheet...

I have been struggling with getting a formula to look at the input of one cell, decide where it falls within a range, and then determine where to go lookup...

I am doing a simple vlookup, but need to search another column and if I find a match change the lookup result. example vlookup(a2,tab1a2:b50,3). if A3 = 25,...

The CUMIPMT and CUMPRINC always result in too long an amort period so loan fee is not fully amortized by maturity.

I'm looking for a way to replace a SUMIFS formula to make a worksheet compatible with older versions of excel. I have a worksheet for data entry 6 columns...

Hi, Please could any one suggest how to do the following in excel sheet, I have two numbers in excel spread sheet 1 is target price and 2 in cost,

how do you 'partially' fill a cell with color ?

I am working in excel 2007. I have created a design for my pivot table. i want to be able to use this design/format in other spreadsheets. It appear that...

What I am trying to do is find a row in sheet 1 that matches my two reference cells and pulling the information from a specific colume for that row. All I...

I'm nowhere near the technical level as most of you on this site, so I'm hoping you can help me out. Isn't there a formula you can enter in Excel that will...

Hi All, If I use RANDBETWEEN function to generate random samples, how do I make sure that units are not repeate? For example- I have 1000 units and I have...

I am having a few problems trying to come up with a function that can satisfy this problem. Sometimes one employee may appear under more than one group...

Hi all, I would like to be able to fill a word form from an excel sheet by clicking on a cell and transferring the data from the different cells of the row in...

I have one sheet for data entry where entries include names and dates among other things. I want to create a second sheet that will search through the first...

I have the below formula to calulate benefit increases depending on various plan dates. It's working perfectly for what I need except that in some instances...

Hi Can I use SUMPRODUCT to lookup two criteria text values in sheet1, cell A2:A100 and B2:B100 and return the text from C2:C100? The formula will be in...

I need to get a sum from 2 different criteria in 2 different ranges. PLace Type $$ a 1 3.00 a 2 5.00 b 1 c 1 d ...

Dear Sir/Mdm, Can anyone please advice how to search for a specific worksheet tab based on a cell value (user input) on a worksheet. Eg, I have 50...

I've got a column of ten cells that I want multiplied together, i.e., =A1*A2*...*A9*A10. A couple of these cells are blank, and I want to ignore those...