mike girvin

  1. A

    Lookup+sum+max

    On which country did the company spend the most money in Salaries in 2022? Employee ID Full Name Job Title Department Business Unit Gender Ethnicity Age Hire Date year Salary Per Month Bonus % Country City Exit Date BHR02002 Kai Le Controls Engineer Technology & Engineering Manufacturing...
  2. A

    Sumup and lookup(5 way lookup)

    if I select any thing in employee column and "All" in department column I should get the correct figure in sales column if I select ravi in employee column and "MIS" in department column I should get the correct figure in sales column for example if I select Arjun in employee column and in...
  3. A

    lookup value

    how to solve this puzzle
  4. S

    CONCATENATE function

    Hi All, There is a problem i am facing with CONCATENATE function. Here is in below table. <colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody> Harry AC DA PC KA Stu DA KA Neena PC...
  5. S

    Text formula

    Hi, Thanks for your videos. I have a question as below. I have a table containing some products. RCCO NK-3325 TRD 633 PL 1 KG NK IN RCCO NK-3325 TRD 633 PL 2 KG NK IN RCCO NK-5251 TRD 633 PL 1 KG NK IN RCCO NK-5251 TRD 633 PL 2 KG NK IN RCCO NK-6302 TRD 633 PL 1 KG NK IN Brand is NK-3325...
  6. mgirvin

    Array Formula Concept Questions from M Girvin for Holy Macro! Book

    Dear Smartest Excelers In The World. I am writing a book for Holy Macro! Books Publishing about Array Formulas. I am making this post in hopes that I could get some feedback about some array formula concepts. Below are five questions that I have for all of you, the smartest Excel people that I...

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