-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
mechanic
-
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...- Addictions
- Thread
- columns driver mechanic result skills
- Replies: 6
- Forum: Excel Questions
-
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...- Bal_Ocado
- Thread
- account conditional financials mechanic pack
- Replies: 0
- Forum: Excel Questions
-
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...- Aberdham
- Thread
- eur invoice mechanic summary usd
- Replies: 1
- Forum: Excel Questions
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.
