Forum Discussion

Misha Ayzenberg's avatar
Misha Ayzenberg
Copper Contributor
Sep 27, 2018

Data validation

Hello everyone,
I've done a data validation function from a list of 10 products, and I've replicated it to 10 cells. What function can I do on these 10 cells, if I choose one product from my list list inside the cell on another cell data validation I will no longer be able to select the same product and it will disappear from the list of data validation?

Thanks in advance.

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 27, 2018
    your query is not clear. I suggest you attach a 'dummy' file for people here to better understand you. indicate there what you need.
    thanks..
    • Misha Ayzenberg's avatar
      Misha Ayzenberg
      Copper Contributor
      Sep 27, 2018

      for example, i have list of cataloge num.

      if i choose 358151060715892 in A2, i want that its number will desapear from the next cells (A3-A7).

       

      attached the file.

       

Resources