I have a spread sheet in which laboratory results are entered. So of the results are less than numbers I do not want to include the less than results in the...

I have 2 columns one with a person ID and the other with various dates. The file is sorted by person ID. I need to count each unique date within each ID. So...

I have a column and I would like to fill the cells below it with the same data as above. Sometimes there are more than one blank row below the Policy...

Now that we are using the spreadsheet. I have been faced with the question: How do we stop the formula from processing if the patient has either had an...

I'm building a tracking program that monitors medical consults against time and urgency. Column A Column B Column C Column D Column E ...

Hey, are you getting free traffic to your site? I just discovered this website that has some pretty good content about generating targeted web traffic, with...

Excel 2007 I have an 8 x 8 grid in which I want to flag all cells that are not evenly divisible by .5. I can do this for a single cell with the following...

¦¿¥ý¥Í 24230092

I've used F5. special formulaserror ... 'no cells found'; but, continue to receive 'form. containing invalid data'. ? I've used win watch ... all...

I have a worksheet that takes inventory of units that i have available to rent. What i would like to achieve is to have excel give me a daily percentage of...

I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2...

Hello, I would like to find the most expedient way to enter a formula that simply returns the value from another cell... but when I copy it DOWN, the...

I have a sheet that contains a sheet where the user enters data(Sheet1=Query), another where it gathers information (Sheet2=Qualifications), and a sheet that...

Hi. I am trying to write a formula that will sum numbers across rows containing the last 4 characters of a...

How can I calculate time worked for different time zones from 1 cell entry e.g. 06:00 to 14:00 time worked (cell entry) 07:00-14:59 15:00-22:59 ...

I have two variables, i.e. two cells determine what is displayed... does anyone know the formula to this... Would be like "if A2 is = B2 AND if cell C2 = D2...

I have created a pivot table report summarizing 35000 rows of data. I want to add a formula into this pivot table report but Excel says there are too many...

I have A1 and A2 subtract A2 from A1 my problem lies when those numbers fall between 12 - 12.50 I need it to still subtract them but if it falls between there,...

I'm using Excel 2002 to generate commands using the Concatenate function to lookup reference info in other cells. I can't get the text strings from...

I have a spreadsheet with several columns. I have made a list of values that I would like to find in the spreadsheet from a specific column (Column D). I...