Reset count of Rows Function based on cell information

[Mystix]

I am working on a schedule spreadsheet. In the example, there are job types which display information based on the job type. Some info types are the same (customer's name, address, phone numbers, etc). The problem comes is getting the Rows Function to reset when a new schedule time is entered in Column C.

			HOW IT SHOULD LOOK		WHAT HAPPENS CURRENTLY
FRIDAY 2/26/21			CREW1									CREW	ORDER	CUSTOMER	STORE1	PHONE1	PHONE2	NOTES	ADDRESS	JOB TYPE	JOB	AMOUNT
9:30 AM	-	9:45 AM	PICKUP AT STORE1		PICKUP AT STORE1							CREW1	3	CUSTOMER2	STORE1	CUSTOMER2 PHONE1	CUSTOMER2 PHONE2	CUSTOMER2 NOTES	CUSTOMER2 ADDRESS	SIDE JOB	INSTALL WINDOW
			STORE1 ADDRESS		STORE1 ADDRESS							CREW1	4	CUSTOMER3	STORE1	CUSTOMER3 PHONE1	CUSTOMER3 PHONE2	CUSTOMER3 NOTES	CUSTOMER3 ADDRESS	INSTALL	INSTALL DOOR
			PICKUP FOR:		PICKUP FOR:							CREW1	2	CUSTOMER1	STORE1	CUSTOMER1 PHONE1	CUSTOMER1 PHONE2	CUSTOMER1 NOTES	CUSTOMER1 ADDRESS	DETAIL	MEASURE DOOR
			#REF!		#REF!							CREW1	1	PICKUP AT STORE1		PICKUP FOR:			STORE1 ADDRESS	PICKUP	PICKUP WINDOW
			#REF!		#REF!
			#REF!		#REF!
10:15 AM	-	10:30 AM	CUSTOMER1		STORE1
			CUSTOMER1 ADDRESS		#REF!
			CUSTOMER1 PHONE1		#REF!
			CUSTOMER1 PHONE2		#REF!
			CUSTOMER1 NOTES		#REF!
			MEASURE DOOR		#REF!
			STORE1		#REF!
			#REF!		#REF!
12:00 PM	-	5:00 PM	CUSTOMER2		#REF!
			CUSTOMER2 ADDRESS		#REF!
			CUSTOMER2 PHONE1		#REF!
			CUSTOMER2 PHONE2		#REF!
			CUSTOMER2 NOTES		#REF!
			INSTALL WINDOW		#REF!				MY FORMULA
									=@INDEX(INDIRECT("fri"&@INDEX(JobTypeLists,
									ROWS($C3:C$3)+1,
									MATCH(INDEX(JobTypes,,MATCH(@INDEX(FriType,INDEX(MATCH(1,(FriCrew=FriRandy)*(FriOrder=COUNTA($C$3:C3)),0),0)),JobTypes,0)),JobTypes,0))),INDEX(MATCH(1,(FriCrew=FriRandy)*(FriOrder=COUNTA($C$3:C3)),0),0))

 

[jasonb75]

Try something like

=ROWS(C$3:C3)-MATCH(1e+100,C$3:C3)+1

 

[Mystix]

Try something like

=ROWS(C$3:C3)-MATCH(1e+100,C$3:C3)+1

YES! That's exactly what I needed. THANK YOU! I've been trying to get that right for the past week. Very much appreciated.