Hi I currently have a problem with my Data Validation. I need to be able to copy paste (special - values) in the range of where my DV is, but by doing so it...

Looking for formula set up help. Current workbook I have for example, information in cell A1 from sheet one formulated to sheet 2 for same cell as...

'Hi, 'I got this simple code, I was wondering if anybody here can help me put the 'value of "_timestamp" (see below) as name of my worksheet. Private Sub...

Does anyone know how you can make a cell show a different drop down list to pick form depending on the contents of another cell. example i now have data...

A B C D 1 Kevin P 320 ME #1 10.0 2 Kevin 350 NVT ...

Hello, I need help with finding the last game that two teams played each other, either home or away. This is to decide who will have the home town advantage...

Hi, In Microsoft Works, to change the order of a rows of cells, I can cut a row of cells, paste it into another row, and it "bumps" all the rows beneath it...

How do I fix the following to sum the column & not get a #NAME? error? =SUMPRODUCT(--(IsNumeric($D$10:$D$500)), --($D$10:$D$500)) I appreciate your help,...

I have 2 columns with names I want to have a 3rd column with only the names that match Is there a function for doing this -- Carla Heimbigner

I need a formula to calculate redundancy payments in a table. The redundancy payment due to each employee depends on his or her age and length of service...

Workbook with 2 spreadsheets. I need to look up a part number in one column and have it give me the value in another column on the same row. PS# ...

I am trying to format pivot to better display of an Event Timeline. I have one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim,...

When I add color to cells in a worksheet, the gridlines disappear. How do I get them back?

How do I count the number of cells in a range that contain the character substring xxx? I know =COUNTIF($G$8:$G$11,"kkkk") counts cells that are exactly...

I do not want to use Pivot function I have a table of 5000 row with five column Division District Salesman Factor result If I want to recap the result...

Hey, folks, I am doing a key project at Beijing University on culture discrepancy, and I am honored to have you fill out the following questionnaire. Your help...

Hi, I need to apply the rounding rule below for conducting our business when dealing with a number that has a 0.5 ending: Example: If the average is 54.5, I...

I have a sumif calculation: =SUMIF($C$18:$C$99,"Management",F18:F99) I want to put filters in, and make the F18:F99 portion of the formula a subtotal, rather...

I've created a spreadsheet for my work to calculate the number of patrons and sales. I would like to protect only the cells that have formulas in them, so...

I am trying to use the COUNTIFS function w/multiple criteria in an Excel 2007 workbook to count sales for reps in a summary tab but want to remove 3...