record # if data in other columns in same row

[arnelgp]

you can also create a function in a Module:

Public Function ColumnData(ByVal rw As Long) As Long
    ColumnData = Cells(rw, Columns.Count).End(xlToLeft).Column
End Function

then use it in a Formula (see formula in Column B of Record sheet)