try it ..... I've applied in column a, b & c . It will show 2nd and onwawrd equal items .....
=and(countif($a$2:$a$31,$a6)>1,countif($a$2:$a6,$a6)>=2,b6="y",c6="y")
try it ..... I've applied in column a, b & c . It will show 2nd and onwawrd equal items .....
=and(countif($a$2:$a$31,$a6)>1,countif($a$2:$a6,$a6)>=2,b6="y",c6="y")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks