santa

  1. N

    If cell contain any part of text

    Hello, Currently on my workbook I have a formula like: =SUMPRODUCT(COUNTIF(E2:E495,{"San Francisco CA";"Santa Rosa CA";"Los Angles CA";"Los Angeles";"Long Beach CA";"Long Beach"})) to add to a total when this specific cites are listed. However what I want to do is to mark them when any...
  2. S

    "Secret santa"

    Can excel be used to randomize a secret Santa draw? It needs to have functionality that it randomises a name and wither emails that person or puts onto a tab or hides the name from everyone else.. maybe only access with a password so the host doesn't see who has who either?

Watch MrExcel Video

This Week's Hot Topics

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
Top