lax

  1. R

    macro to copy out rows that have a start date, end date, and days of week into separate days

    Hi Everyone, New to this as a member but have referenced mrexcel.com for years. Great site and resource! I'm trying to create a macro that will copy out rows of data based on a start date, end date, and days of week into individuals single dates. I've found ways to break out the date range...
  2. E

    SUMIFS with multiple criteria in different rows

    Hi everyone, Apologies I seem to be stuck on what I thought would be a simple formula. I have a large dataset of customers taking flights (one ways in the dataset) and I am trying to calculate how many are 'most likely' round trip flights (matching by customer name then origin to destination...
  3. J

    Create a rank based on three fields in Excel

    <tbody> YEAR CLIENT STATION STATIONCNT STATIONCNT RANK 2019 A CHI 8 1 2019 A LAX 2 2 2018 A DAL 7 3 2018 A SFA 25 1 2018 A NYO 8 2 2018 B SFA 1 4 2018 B CHO 10 1 2018 B CHI 4 2 2019 B LAO 2 3 2019 B LAX 23 1...
  4. W

    Duplicate List items based on varying quantities?

    I'm having some issues figuring out if you can create a dynamic list of values in a range, based on separate quantities per item. I have seen it done via VBA, but I'm trying to avoid that if I can. This is an example of the Data:- Code Qty 1 Lax 3 2 SF 1 3 Tan 2 4...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    • Started by PabloFer
    • Replies: 32
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    • Started by Sleeplol
    • Replies: 24
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    • Started by johnsonk
    • Replies: 22
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    • Started by Dellboy
    • Replies: 26
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    • Started by ipbr21054
    • Replies: 22
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    • Started by Ramballah
    • Replies: 22
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top