Show duplicates within a column exclude blanks

wouldnt work, because if I split blanks it will remove the whole rows, in one column it may be blank but in another column its not blank and I will need that cell.