name list

  1. F

    Return highest value across multiple sheets as well as sheet name

    Hi all! I've been trying to get this one to work for a while now to no avail. I've googled and searched forums, tried all sorts of formulas and just keep running into walls and errors :( I have a workbook with multiple sheets of staff performance figures. Each staff member's sheet is the same...
  2. C

    Is it possible to delete cells rather than rows/columns?

    Is it possible to delete cells rather than rows/columns? I will have 2 columns of data (peoples names) what im wanting to do is be left with the same 2 columns of data WITHOUT the duplications. eg Current Names List......New List of Names Bloggs, Joe ................Smith, John Brown, Jim...
  3. L

    Dynamic Named Range not listed as Named Range

    It is my understanding that dynamic named ranges using the OFFSET() Function are not listed in the named range drop-down list on the toolbar. Is there a way to get around this? I need to be able to select the dyanmic named range in order to clear the range and paste an updated list in its...
  4. C

    Rolling List in Excel

    Hi there I'm sure it's a nice simple piece of code but I can't find it! I have a list of names on a sheet and am trying to make it a rolling rota, i.e. there is a name in a cell, you click a button and the name in the cell changes to the next name in the list, and when it gets to the bottom of...

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