|You need to check each row individually. This will check Row 1. Drag it down your column and the 1 will increment row by row.|
It basically checks each cell (in order) to see if it contains data, returning YES as soon as it finds any cell that is not empty.
You could also use:
=IF(COUNTA(BD1, BG1, BJ1, BM1, BP1, BS1)>0,"YES","NO")
COUNTA returns the number of cells in a range that contain data, therefore if COUNTA returns any number greater than 0, there must be data in at least one of those cells.
BTW Neither of those functions will tell if the cells contain an actual contact number. They will simply tell you if any of those cells contain data. Checking for a phone number would be a bit more difficult.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.