In L2, put the $ in front of your range reference to lock the table. =IF(COUNTIF($J$3:$J$18,J2)>1,"double","single") then fill the formula
In L2, put the $ in front of your range reference to lock the table. =IF(COUNTIF($J$3:$J$18,J2)>1,"double","single") then fill the formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks