So basically, if the "applied" column has a "yes" entry for a corresponding company, I want that same entry to be relayed if the same company comes up again as to not have to re-input the data. How would I do this?
1 Answers
No VBA Here. If what you're looking for is how to tell if the combination of all three columns is duplicated... For example, you are only checking if someone named bob, who is an accountant, at google is a duplicate, then here is how.
formula in cell F2 in my example
=IF(COUNTA(FILTER($C$2:$C$17,($A$2:$A$17&$B$2:$B$17&$C$2:$C$17)=A2&B2&C2))>1,"DUPLICATE","-")
You can use this to identify which lines to add a yes to or which line to delete depending on your expected outcome.
Related