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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top