I daily populate a sheet sent to me with answers (time & dates) of 1,2 or 3 star items, the 3 star items I manually fill with a certain colour. Is there any...

Is it possible to set up data validation to allow only numbers greater than or equal to zero OR text equal to n/a. I have check sheets for machine...

I am trying to total subtotals, but only if they are less than 1. I've tried doing...

Hi All, I hope someone can help with a tricky formula. Given this type of sample data: A B C D E F ...

I have multiple sheets with 3 columns of data each. The first col is ID info, the other two track hours and dollars, respectively. I want to add up all the...

ID # Document Date Comments 123456 Profile Statement 12/31/2009 Will be returned this week Can someone help with a match formula that will...

Hello, Please help. I have a columne A with department codes A, B, C, ... the department codes are multiple lines, column B with numbers when there are...

Hi there, is there any way to automatically update linked documents without opening the source document? When I leave them closed, my main worksheet shows...

I have reference data in Column "$Q$3:$Q$502" of "sheet1". For all cells in the reference column that contain "yes", I would like to average quantity in...

I have cells in a worksheet that are formatted as date but still show as date and time. How do I pull out the time. E.g. 04/07/2009 1:00:00 AM I have tried...

Any simple way to count how many 1s and how many 2s here? 2 1 2 2 2 1 2 1 1

I'm using office 2007, specifically excel. I cannot get the countif function to accurately count cells containing multiple numbers. For example below is a...

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How? Thanx

I have 10 years worth of monthly data and need to determine the best (or worst) three consecutive months for benchmarking purposes. How do I write a formula...

I need to use a formula to find out how many times the value in B2 appears in column B.

When I create a Pivot Table with a list of about 10 suppliers. Why does the feild I unselect disapear from the Pivot Table? If I want to view the suplier I...

Can you please help me to learn how to create an expense requisition form? thanks, ml

I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the...

I would like to have sheet1 list all rows in sheet2 matching "TEXT" in column sheet2,A. Big TIA! -JS

Hi, Not sure if this is function or programming? Question is: In column F, Row 4, Header is "Do You Require Training?" in row 5 is a validation list = Yes,...