Splitting the cells is not a lot of work, just create two columns and in the first column typeand in the second typeFormula:
=LEFT(C3,4)Drag both down and then plug in your CountIF.Formula:
=Right(C3,4)
Splitting the cells is not a lot of work, just create two columns and in the first column typeand in the second typeFormula:
=LEFT(C3,4)Drag both down and then plug in your CountIF.Formula:
=Right(C3,4)
Click the * to give Rep to a post you like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks