pkg

  1. T

    Compare two rows for partial or full match

    Is there a way to have Excel compare cells in a row to cells in another row (on a different sheet or excel file) to look for a partial or full match and return the row “name”? Example below. One file lists the possible packages and what is contained in those packages (Package A has a nut, bolt...
  2. G

    Create list with VBA

    Hi, I would like a VBA code to: 1) Create a New sheet called "Ranking" 2) In this new sheet, I want to create a list. In A1 I want to have "Ranking", B1 I want to have "Category, C1 I want to have "ID", D1 I want to have "Name" From A2 till A1010 a list of numbers: A2 I want to have 1, A3 I...
  3. J

    vlookup - get value from filtered list

    Hi I have data in a table like below: <colgroup><col span="2"><col span="2"></colgroup><tbody> Pkg Type Pkg Name DEV01 DEV02 CP cp1 20-11-2017 00:00 21-11-2017 07:00 DP dp1 19-11-2017 00:00 20-11-2017 00:00 CP cp2 21-11-2017 00:00 21-11-2017 05:00 DP dp1 19-11-2017 09:00 20-11-2017...

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