acct#

  1. T

    VBA - filtering multiple criteria from two workbooks

    I'm not sure this is even possible, but here goes, is there a way to put the below instructions into a macro. Use the takeover lists for rental from NRC to delete adjustments which $0.00 each other out. – filter on Takeover under Agreement field, copy Acct# and T/O from acct# (column C & P)...
  2. R

    Sumifs Maybe?

    Hi, if i have hundreds of lines all out of order that are set up like the first table; is there a way to sum the data by trips? A trip being consecutive days. <tbody> Acct# Date Cost 3005 10/24/18 50 3005 10/25/18 100 3038 9/1/18 25 3038 9/2/18 50 3005 11/13/18 25 3005 11/14/18...
  3. R

    Formula Help

    I have spreadsheet with the data set up like the first table. It runs across for 100's of columns, these are just the first 3 categories. Is there a way to pull the amounts based on the location and acct# in a set up like the second table? All of the Acct#'s in the data are not the same in...
  4. H

    Index Match function to find outliers

    Hi friends, I am working on a project where I would need below raw data to show expected results as shown below. Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!! I am looking for the formulae without {} brackets, it maybe combination of Index Match...
  5. H

    Outliers using Index Match function

    Hi friends, I am working on a project where I would need below raw data to show expected results as shown below. Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!! I am looking for the formulae without {} brackets, it maybe combination of Index Match...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top