Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

#32

10-17-2019, 05:26 AM

p45cal

Windows 10 Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
New learner need help - convert tables in word format to ppt slides.	sas	Word VBA	5	09-21-2017 08:33 PM
Good morning/afternoon/evening based on time	dwirony	Word VBA	1	01-03-2017 01:01 PM
Need conditional formatting formula	namedujour	Excel	1	05-27-2016 08:58 AM
Conditional Formatting Formula	teza2k06	Excel	1	08-22-2014 02:49 AM
Conditional Formula	UICOMP	Excel	1	05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.