I'm trying to add up values in one row if the values in two other rows (in the same column) fall in the right values. In Sheet 1 I have a list of dates, Y or...

Hi all I have the following code to change the color of the cell( the cell underneath from where the data is). I have values from 0 to 100 in Range...

Thanks everyone Reference Thread preceding this text Background I need to show a minus figure in the total if the result is better than target ie target (c40)...

Hi, I have a sheet (sheet1) with 2 columns, column 1 has customer name with duplicates and column 2 has customer number with duplicates. I have removed using...

I am trying to find a way to create a workbook with many worksheets for our employees. I would like to limit access for each worksheet by password and only...

Using Excel 2000 is there a way to do the following: Copy collapsed subtotals to another location and paste them so they do NOT expand into the detail; only...

I have attached a small portion of my file. In worksheet 1 the only thing I want to have to change is the date (cell A1). I want cells B2,B5,B8 to select the...

i have office 2003. im trying to multiple a range of cells by a specific number dont know how to do it. im hoping anyone can help resolve this. i want all the...

Hi, Is there a way in Excel to find duplicate names or numbers in a list? Thanks, Dan

Is there a formula for rounding down numbers to nearest 100 after they have been added together? For example: $861,771 +$35,357 =$897,128 rounded to $897,100.

I have the following format in excel: Column A Column B Column C Books Alpha 2 Bravo 8 Cars Bravo ...

Hi all, How can I formulate excel so that upon entering a sing year like "2004", it provide 2 rows such that the first row reports the first day of each...

I would like the date in cell B1 on a weekly timesheet to always be the previous Sunday's date when I open it. (once a week to update for previous week's time)...

I have a checkbook register in Excel. I have some columns that contain both debit and credit items. I need to know how to tell Excel to find the difference...

If I have data beginning with cell A1 and want to 'count' every 14 rows and pick up the data in the next cell (e.g. A15) in my next line item, how do I put in...

I'm trying to create a formula on Sheet 2 but need to access a field from Sheet 1. Can't find how to do this via help. Can someone give me the formula. Thx.

I created a workbook which uses about 3000 cells that have conditional formatting. Basically, the cell uses a dropdown and if "A" is chosen, the cell turns...

We've done a search under help for a "left" function that will return the first word in a column (so theoretically, the funtion is searching for the first...

Hi. We have set up our staff scheduling on Excel at work and we have used simple Conditional Formatting to change the cells to green highlight working hours.....

Good evening, I need help again. I have 31 sheets labeled 1st, 2nd ... 31st. Data on column "e2:e15" on each sheet that I want to countif to a summary page...