multiple records

  1. C

    Counting Unique Records

    I have an Excel Spreadsheet contains 8,000 rows by 30 columns. I am trying to count the number of National Insurance numbers in column F where column S = FAMC and column T = NP. I am trying to count the occurrence of National Insurance numbers that contain this criteria, however, if the nation...
  2. C

    Combine Records Extracted Using SumProduct

    I created a form where by using a COUNT:=SUMPRODUCT((TEXT(Order!A2:A65535,"m/dd/yy")=TEXT('Order Confirmation'!$J$34,"m/dd/yy"))*(((Order!J2:J65535>=1)+(Order!I2:I65535>=1))>0)*(Order!A2:A65535<>"")*(Order!J2:J65535<>"")*(Order!I2:I65535<>""))...
  3. Data Bender

    Double-Click PivotTable Item without Displaying Excess Records

    Thank you for reviewing my post. When double-clicking a PivotTable value, how does one limit the records displayed? For example, it makes intuitive sense to see only one record, when double-clicking the value of 1 in the following PivotTable: However, I get the following nine records...
  4. P

    Calculations using data from more than one record in a table

    I have a data table with many records each including an event date. I then use queries to extract and sort data that meets certain criteria. My question is how can I calculate the interval between the dates in successive records. What I need is to show the number of days since the previous...
  5. B

    Search duplicates, choose one in userform

    I have been working on this for a bit on my own and trying to figure out the best way to approach it, but I am going in circles, so here goes. I have a database of folks with some unique identifiers, but I want users to be able to search/lookup by last name, which obviously may not be unique...
  6. P

    Slow Macro to sort Multiple Records

    I'm having a bit of trouble getting a macro to run. I have a sheet with personnel No's UserID's and Email address as below: <TABLE style="WIDTH: 488pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=650 border=0 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top