preventing duplicates

  1. P

    Auto Text Filling a Cell and prevent it from being duplicated as per change of Status

    Hello, Is it possible to auto fill a chosen cell between cells in a row and prevent it to be duplicated from the previous/after cell, based on change of status? I want $I$7 to interact $C$7, therefore after filling $K$14, it will auto transfer from $I$7, and $I$7 will be blank & so on...
  2. A

    Prevent Duplicates in Drop Down List

    Not sure if this can be done but...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am aware how to prevent duplicates in Excel but is there any way that Excel can prevent duplicates being selected from the Drop Down List Function?<o:p></o:p>...
    • activeman
    • Thread
    • data validation drop down list duplicates excel preventing duplicates
    • Replies: 3
    • 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