secretary

  1. T

    If Cell contains x, return x, if it contains y, return y, or if it contains z, return z.

    I have thousands of cells with text containing various descriptions. I'm trying to search the text and tell me if the description says x, y, or z and to return which one it says. The descriptions are all over the board, but contain certain key words that I need to categorize. Example Below...
  2. B

    Extract Multiple Leadership positions from a list for the same person

    I have a list of members where some hold more than one position. If I use a regular Vlookup or Index Match formula I will only get the first one and will be repeated. For Example, Jane Doe is a president , secretary and bargaining chair. I have 3 records in my list where I would expect to...
  3. M

    Auto email to outlook of worksheets

    I am running MsExcel 2016 and Outlook 2016 I have a large master worksheet that contains many members names and addresses and contact details, including email address. Members are in different groups (300) and members in a group are linked by a common ‘secretary’. e.g. 30 members are associated...
  4. B

    If this, then that

    Hi, I would like to auto-fill a cell based on conditions. For Example: We have "Sheet1" with text 'Brad' in B3, and 'Secretary' in F3. (Brad is the secretary). So when I enter 'Brad' in any row in "Sheet2" (eg. C4), then I want the same row, in column D (eg. D4), to auto fill with 'Secretary'...

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