extract a table

  1. M

    Stop a search/filter formula based on two columns from duplicating a row that has a hit in both columns

    Hi everyone! I have two reports that I merge based on a unique identifier from Report A (database) which is normally present in Report B (ticket system report), but not always. The Merge ends up with two columns with employee names (one from Report A and one from Report B). From this merged...
    • Marzatron
    • Thread
    • extract a table filter advance criteria index match 2 criterias merge tables
    • Replies: 1
    • Forum: Excel Questions
  2. A

    Extract All lines cotaining the last distinct value.

    Hi, I am currently relatively new to excel and I have an issue. I want to extract from a sheet all the lines that contain the last distinct value of a column. So have something like this 534 16 14 534 64 16 020 24 22 020 16 14 020 64 16 134 24 0 134 8...
  3. M

    Data Extraction from Website Using VBA

    I am trying to extract temperature data table based for the city that the user inputs. so far, i am stuck at writting the city into the website and then clicking search. after that I want to automate instead of fixed Cairo, i want the user input in excel to be the one in the toolbox after...

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