I am working on a spreadsheet which calcualtes a decrease in base wages, which is working fine: A1*(1-A2)= X or $15.00 *(1-8%) = $13.80. Howeever, when I...

I'm trying to count unique values based on muliple criteria. I tried using the formula...

Is it possible to use the Data Validation function with an if statement; then if the if statement is false limit the input value based on a drop down...

I have 13 sheets, Jan - Dec and a total sheet. I want to average cells in the Jan - Dec sheets. If I add my formula to the sheets then my average counts...

I have a workbook with 100 sheets, named by employee. I want to get a printout of the tab names so that I don't have to go through the entire list to see if...

Hi, I have one column of text imported into excel that looks like column A data...I want to use a function that would give me whats in Column B, that is,...

I have a formula that calculates time. The following cells contain the following data. Cell B381 contains 8:00 AM Cell C381 contains 4:45 PM Cell E381 contains...

I'm having trouble getting the formula below to work after adding the additional condition of: Additional Condition: IF(TODAY()EDATE(M4,3) Full...

I think I need to use goal seek but am not sure how to get to where I need to be. The scenerio is as follows: We currently pay personal car mileage. Last...

I am trying to set up a new tracking system for our Patient Satisfacion cards to be used in evaluation staff. I have a system now where I simply plug in the...

Hi, I created a formula that does not work for me. What did I do wrong? =INDEX(B4:B15,MATCH(F18,C4:G15,0)) Thanks, MrRJ

Hi, I’ve created a formula with nested IF & MAX functions, as...

HI! Expert I have data in Two Column Like This: Zone No. East 4 East 8 East 6 East 31 East 5 East 9 East 3

Hi Group... I have a spreadsheet that is up to about 8500 rows, and will continue to grow at about 40 rows per day.....filtering is slow (about 6 - 10...

Hello, I need formula or macro configuration help for Excel 2003. Within a spreadsheet, I want to compare the list of names in column A with the list of...

I have data arranged like this: No. Payment Date 1 1-Sep-08 2 1-Oct-08 3 1-Nov-08 4 1-Dec-08 5 1-Jan-09 6 1-Feb-09 7 1-Mar-09

I have read the instructions below (created by bj) for creating a new filtered table in a different location but cannot seem to fully understand the concept...

Hello, I have created a formula using the threads I have seen and I can not get rid of the #N/A value. The formula works ok if there is match or if the value...

I would like to transform my existing table A to table B. Therefore, I can sort table B by customers for the subtotal. Thanks. KS Table...

I need to gather some analysis from various different colleagues on a daily basis for a period of two weeks. I am looking for a simple way/format I can use. I...