Search:

Type: Posts; User: SirGruffles; Keyword(s):

Search: Search took 0.00 seconds.

  1. Pull GL Coding from Transaction Matrix of Cardholders and Shortened Vendor/Transaction Data

    Hello!

    I'm trying to create a "transaction matrix" of sorts for expediting the AMEX statement at the end of the month.

    I've got columns designated for my full employee's names, with rows going...
  2. Pull State from Non-Uniformly Formatted List of Addresses

    Hello!

    I have a massive list of addresses, and I'm looking to pull the state (and the state alone) out of it, and into a separate column.

    Here's a few rows as an example (not real addresses,...
  3. Re: How to Pull ALL matching values from a list/array

    Out of curiosity, if there was a requirement of 2 criteria, for a single column, would there be a way to insert both criteria into that one formula?
    For instance, this one report would be for...
  4. Re: How to Pull ALL matching values from a list/array

    Yes! This!
    This was what I was looking for!

    Thank you very much!
  5. Re: How to Pull ALL matching values from a list/array

    Yeah, its a bit more manual than I was hoping for.
    As to get the reports to my superiors quicker, I did the manual filtering and made 35 different tabs for the cost centers.

    I just thought...
  6. How to Pull ALL matching values from a list/array

    Hello,

    I have a list of account numbers in the format of "XXXX-YYY-ZZZ- -" in column A, specifically A6-A684.

    Is there a function in excel, similar to Vlookup, that would pull out any and all...
Results 1 to 6 of 6