Excel data validation by combining multiple conditions -


can excel validation formulas multiple conditions? have 1 column want 1) unique values 2) values have 10 characters(leading zeroes allowed) 3) have numbers

i can unique values below formula:

=countif($g:$g,g2)=1 

how add other 2 conditions?

if set type number, leading zeroes not displayed.

formula =and(countif(g:g,g2)=1,len(g2)=10,isnumber(value(g2)))

  1. countif(g:g,g2)=1 checks unique condition.
  2. len(g2)=10 checks length, including leading zeros i.e., number stored in text format.
  3. isnumber(value(g2)) checks value of cell.

and condition ensures above met.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -