industry

  1. B

    VBA to capitalize every proper word in a sentence

    Is there any way using VBA to capitalize every proper word in a sentence? For example for the sentence: Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and...
  2. T

    Help with possible Index Match Match?

    Hi All, This may be an impossible task so bear with me. I have the following raw data: <tbody> Owner Account ID Industry Industry# Account # Joe 1 Plumber Primary Industry Primary Account Joe 2 HVAC Secondary Industry Secondary Account Bob 3 Plumber Primary Industry Primary Account...
  3. M

    INDEX MATCH MATCH or something else?

    Hello I have a table with the following: <tbody> 1991 1992 1993 1994 Industry A Place A x x x x Industry B Place A x x x x Industry C Place A x x x x Industry A Place B x x x x Industry B Place B x x x x Industry C Place B x x x x </tbody> In another sheet I need to...
  4. V

    Index/Match/Offset query

    Hi, I am doing a project that I'm struggling with a bit. I wondered if someone could help? I have one table which contains calculated data that I want to apply categories to another table. <tbody> A B C D Industry 1 2 3 Energy 25 40 50 Retail 20 57 55 Chemicals 15 25 50 </tbody> So...
  5. G

    Return Name of Category with Max Sum

    Hi guys, can you help with formula? Below is a list of Customer transactions & their values within Industries. Formula should Sum Up Prices in Industries for each Cust ID and return name of Max Sum Industry into Leading Industry. <tbody> Cust ID Industry Price Leading Industry 5...
    • gamerosko
    • Thread
    • cust excel formula formula industry max based on criteria
    • Replies: 7
    • Forum: Excel Questions

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