Hi, I am using the below formula to count how many employees are scheduled to work by hour but it is not counting if the shift starts in the PM and ends in...

This is difficult to ask... I want to create a form in excel on one tab with a spreadsheet of data in another tab. On form tab I would like to simply type in...

Excel 2007 has an excellent feature that makes the formulas automatically jump into new rows when you insert them into a "table". But sometimes these...

MICROSOFT QUERY 10/27/09: I am using Excel 2007. In the example below I need to return a count of "2" for each of the unique data elements in column "B" based...

I have a spreadsheet full of formulas and I need to convert each formulated cell to a single set number. (non-formulated number)

from a big file of +5000 rows i have sized down to 400 rows (result), now i want to rank them and show as main set1,set2,set3 & set4 (in one column/called...

What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)?

Each employee has a separate tab in the spreadsheet with their own details in it...I'm trying to put together a separate tab that has a one line summary for...

I have been reading for the better part of two hours trying all of your suggestions. I am still unable to get the following data to sort. I have formatted...

How do I addor average cell columns or rows? How do Iget anaverage minimum and average Maximum?

I have an excel sheet having invoice information about our project. on another sheet i have the clinet names and details . Is it possible to give a...

I have a 3000 row table that has three columns: Time, Sensor1 and Sensor2. I need to break this table up into sub tables. I would like each sub table to...

How can you remove "spaces" between numbers in one cell? (ie 1 000 000) I need to remove the space between the numbers over a large range of cells with...

i am using the weekly schedule from the microsoft templates at http://office.microsoft.com/en-us/templates/TC300023281033.aspx?pid=CT101172751033&WT.mc_id=42...

I’ve been struggling to figure out the proper formula in Excel 2003 and could use some help. The spreadsheet I’m working on has a column of city ward...

I need to write a macro to sum the same columns (ie.. G:O) in every worksheet within a workbook. I need to add it to a macro that I already have which...

how do i write a formula to do a variable sum calculation. ie i have a column of numbers in A from A5 going down to A25. in cell F1 i have a value between 1...

i have 2 cells (A&B), if i input to A i want B to equal this, Visa versa, if i input to B then i want A to equal this. Is this possible? (Text data)

Hi This is my first attempt at array formulas, and I'm not having much luck. My formula is: {=SUM(VLOOKUP(GOAFCF,RelImpact,9,FALSE))} (accepted with the CSE,...