Thread: [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
View Single Post
 
Old 10-17-2019, 02:29 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by p45cal View Post
Untested:
Code:
If (InStr(1, UCase(Vals(rw, colm)), "X") > 0 Or InStr(1, UCase(Vals(rw, colm)), "K") > 0) Then ThisRowCount = ThisRowCount + 1 Else ThisRowCount = 0
Perfect. Thank you.
Reply With Quote