Functions
in [Excel]
|
Formula help I am trying to program excel to return rows and values based on criteria and need some help on which formula to use and how. I need a separate excel document to add part numbers and qty whose sales are over a certain amount for a given period of time. See below for example Part# Description 1st Qtr A... 27 Apr 2010 15:40
Worksheet relative reference Hi, I have created in a workbook a worksheet containing formulas with relative and absolute references to other worksheets in the same workbook. As I have a large number of workbooks with exactly the same structure (one workbook for each operating company), I tried to copy the worksheet with the formulas ... 27 Apr 2010 21:20
Counting dates within a range I have a large database of ~10,000 dated and timed entries. Each entry represents the date and time of a hospital admission. I would like to know for each entry, how many other events took place within 24 hours. I am trying to figure out how many hospital admission happened in the 12 hours prior to and after ea... 27 Apr 2010 13:21
Missing values from a pivot table field I am creating a pivot table from an access database containing 896426 records. The issue I am running into is that on one of the fields the pivot table is only pulling in one of two values, but the access table does contain the second value. When I click on the arrow associated with that field it does not con... 27 Apr 2010 15:40
Ctrl V paste coding was lost I wrote a macro and coded it to ctrl v which overwrote the paste function on the Ctrl V shortcut key, how do I replace the paste function coding? Or where can I find the coding? I am using Excel 2007. ... 27 Apr 2010 09:55
Date formula needed Hi I need a couple of date formulas for invoices recieved, eg. invoice date is 14/03/2010, payment terms are end of month following. so i need excel to calculate that the due date is in this case 1/05/2010 is the due date. ... 27 Apr 2010 14:30
Identifying the top five values in multiple groups I've got a spreadsheet of pay information for about eight hundred people. Each person is on one of eight salary scales I'd like to create a new worksheet that shows the details of just the 5 highest paid people in each scale (name, dept, salary, etc.) - and also the five lowest. Ideally, I'd like also to be ab... 27 Apr 2010 17:57
how do I double check that there are no formulas Hiding in an excel spreadsheet :o) Thanks ... 27 Apr 2010 08:47
Calendar Can anybody tell me why Any Year Calendar4 does not work from Microsoft website Thanks ... 28 Apr 2010 05:04 |