mechanic

  1. A

    Index Match Countif Distinct unique values with two or more match columns with result in two different tables.

    Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...
  2. B

    Conditional formatting for different answers?

    Hey Guys, I've got a pivot table infront of me and just wondering if this is possible. Pivot table columns go as: Mechanic - Brand - Pack - Account I need all of these as they are. The next column is months. After this I have financials. I want to create a conditional format where...
  3. A

    Data summary - transfer certain columns of rows 2 criteria (VBA or Formula)

    Hi there, Recently I have received a payment workbook containing 2 Sheets (USD & EUR) and I would like to Transfer to a new workbook named purchase summary: Here is a selection of USD payment: <tbody> <tbody> Course type Month Description Invoice No. Lecturer Book Description Gross amount...

Watch MrExcel Video

This Week's Hot Topics

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