hi i try to define criteria for DMIN for the following problem: Sheet 1 contains the source data in two colums: "Milestone ID" and "Data", where "Milestone...

Hello experts, I've written a simple formula that populates one cell with today's date when the referenced cell is not null. The problem, however, is that...

I am linking data from another worksheet, but I want any value which is 0 to show a blank cell. What would be the easies way to do this?

I am going to be merging 2 sets of data, one of 2006 information and one from 2007. In each year there are different university names, which I have in my...

This seems to be something not covered on the Webpage on dependant lists http://www.contextures.com/xlDataVal02.html I notice with the dependant lists it...

I have used some formulas in Visual Basic which have worked very well, but I have come across a small, but still irritating problem. I have a column M which...

An issue I have is that in Columns D and E (E is dependant on D). At the moment in D the options are Analyst Summer, Associate Summer, Analyst Full Time,...

Hello experts, I'm trying to use the isBlank() function to in one cell to reference another directly to the right. Problem is, however, that said cell to the...

I want to be able to have all numbers in column a remain the same, no matter if rows are deleted, or re-sorted with the other corresponding columns. How do I...

I am trying to create a conditional format which will highlight the specific cell red when it brings up an error. If column O is filled in without column M...

My basic problem is I want SUMPRODUCT to have a value of 1 if all the below conditions are met (ie. if D10 is Analyst Full Time, E10 contains any text,and...

I need to sum the number of occurances of a problem based on a product code in the col. to the left. This also needs to only sum if it happened between two...

I would like to add a column based on a specific cell's value. For instance, say I type the number "10" into cell A1. I would then like to add the contents...

I am working on a population pyramid template for age, sex, and race. I use simple linking between worksheets to get the raw data into a usable form for the...

Hi New to Excel 2000 i have a worksheet in which i have 1500 rows of data. In Row 2 I want to add a function which will give me the sum of column G...

In Col A i need formula to count how many HMOs in Col B have EPO in Col C Col A Col B Col C 1 HMO EPO HMO UFO PPO ADP CEO EOP HOM TLC PPO EPO

How do you create dummy variables in Excel?

Does anyone know how to import and convert a signed over-punch text into Excel? I received a text file and its format includes signed over-punch...

I want to be able to allow an option on a drop down list only if another cell has a particular value. What I am trying to do is I have a list of people with...

Hello all, I am running the following code graciously given to me by a member of google groups: Private Sub Calendar1_Click() ActiveCell.Value =...