Data Validation W/ Auto Complete

Discussion in 'Mac Apps and Mac App Store' started by RockSolid101010, Feb 26, 2012.

  1. RockSolid101010 macrumors newbie

    Oct 28, 2009
    Is it possible to have Data Validation set up so that the person can type into the cell and have the text auto complete based on the range that the DV is pulling from?

    I'm making a sheet and the range I want to pull from has 500+ values. I can't sit and wait for the list to scroll it takes FOREVER I and am trying to find a solution.

    I've found a bunch of threads on other excel forums but they all either lead to a dead end (probably because the writer was on a PC) or the solution just didn't work.

    Any ideas?
  2. RockSolid101010 thread starter macrumors newbie

    Oct 28, 2009
    Anyone? This has been a tough problem to solve.

Share This Page