suite

  1. L

    Excel Certification

    Hi Is there any certificate exam I need to do to get only Excel certification? Do you recommend any? I googled and found MOS but that is for the whole Office suite. I need the certification for job reason. Thank you very much.
  2. W

    Extract and Remove Level #, Unit #, in address Address

    <colgroup><col style="mso-width-source:userset;mso-width-alt:15908;width:326pt" width="435"> </colgroup><tbody> Hi All, I am just a beginner in Excel If some can assist me in extracting Level #, Unit #, in the sample table below? it would be a great help for me DATA: Column A...
  3. M

    Integrating Max into Index Match??

    Hi, I have a 12 month table (3 columns per month - Sales Value / Margin / No. of orders) - 36 columns in total. I have 3 columns in Columns A / B & C which are Product / Category and Suite/Component - table examples below. I want to be able to match the Category with Component and the Max...
  4. J

    How to Extract Number in Cell with Letters

    I am using VLOOKUP (trying to at least) to find out how many rooms a hotel suite has. So in A1, for example, is suite 3302F. On another tab with all 1,000 suites numbers, I see 3302F in A23 and in B23, it says "Twr 1B." This is a one-bedroom suite because of the 1 but how do I extract just...
  5. C

    CountIfs formula Issue

    hello Everyone, i have a probably a simple problem to the experienced, for me i have been rattling my brain for the past 3 hrs. i am using excel 2016 from Microsoft Suite. My Current Formula...
  6. O

    Char(10)

    Hi Geniuses, I need some help inserting line breaks where a cell contains a certain word. For example the address line "100 East King Way Suite 100" needs to have a line break so that "Suite 100" is on another line in the same cell. I would do it manually but I have ~40,000 rows to go...

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