atl

  1. 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...
  2. R

    Pls help - vba for cell reference with file name..

    Hi all, > I have a file in my desktop wherein the name of the file is ATL and data contains inside file will have the same word ATL in any cell reference.. > I just need a macro to cross verify the data that the file name and the cell reference should be the same if it goes wrong then it...
  3. P

    Lookup up column and row header matches and return corresponding data

    I have a table on sheet1 that looks like the table below. On sheet2 cell A1 is "ATL" and cell B1 is "Yellow" How to I matchup the sheet2 values with sheet1 so that the formula would return "40" based on this example? Thanks! <tbody> A B C D 1 Orange Yellow Black 2 ATL 60 40 30 3...

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
Back
Top