Return specified number of rows with "IF" or "IFS" formulas

[WhatTheF]

My workbook has two columns of dates, and Intake Date and a Disposition Date. There are only two possible dispositions, "RELEASED" or "EUTHANIZED". Unfortunately, in many of these circumstances, no one bothers to fill out this portion like the should have. However, they do enter the dates correctly. We also know how many, total, intakes and releases we have on the report.

What I'm looking for is a formula that will generate the number of rows for the amount of intakes (A1), with the results being, if the Intake Date is the same as the Disposition Date, "EUTHANIZED", if not, "RELEASED". Please see my mini Sheet below for my example.

Book1
	A	B	C
1	11
2	Intake Date	Disposition Date	Disposition
3	1/5/2023	5/15/2023	RELEASED
4	1/6/2023	5/27/2023	RELEASED
5	2/10/2023	5/21/2023	RELEASED
6	2/17/2023	4/18/2023	RELEASED
7	2/18/2023	2/18/2023	EUTHANIZED
8	3/6/2023	4/2/2023	RELEASED
9	3/8/2023	4/20/2023	RELEASED
10	3/13/2023	5/10/2023	RELEASED
11	3/16/2023	3/16/2023	EUTHANIZED
12	3/22/2023	3/24/2023	RELEASED
13	3/30/2023	3/30/2023	EUTHANIZED
Sheet1

 

[Eric W]

Try:

Book2
	A	B	C
1	11
2	Intake Date	Disposition Date	Disposition
3	1/5/2023	5/15/2023	RELEASED
4	1/6/2023	5/27/2023	RELEASED
5	2/10/2023	5/21/2023	RELEASED
6	2/17/2023	4/18/2023	RELEASED
7	2/18/2023	2/18/2023	EUTHANIZED
8	3/6/2023	4/2/2023	RELEASED
9	3/8/2023	4/20/2023	RELEASED
10	3/13/2023	5/10/2023	RELEASED
11	3/16/2023	3/16/2023	EUTHANIZED
12	3/22/2023	3/24/2023	RELEASED
13	3/30/2023	3/30/2023	EUTHANIZED
14
Sheet2

Cell Formulas
Range	Formula
C3:C13	C3	=IF(A3:A13=B3:B13,"EUTHANIZED","RELEASED")
Dynamic array formulas.

 

[WhatTheF]

Try:

Book2
	A	B	C
1	11
2	Intake Date	Disposition Date	Disposition
3	1/5/2023	5/15/2023	RELEASED
4	1/6/2023	5/27/2023	RELEASED
5	2/10/2023	5/21/2023	RELEASED
6	2/17/2023	4/18/2023	RELEASED
7	2/18/2023	2/18/2023	EUTHANIZED
8	3/6/2023	4/2/2023	RELEASED
9	3/8/2023	4/20/2023	RELEASED
10	3/13/2023	5/10/2023	RELEASED
11	3/16/2023	3/16/2023	EUTHANIZED
12	3/22/2023	3/24/2023	RELEASED
13	3/30/2023	3/30/2023	EUTHANIZED
14
Sheet2

Cell Formulas
Range	Formula
C3:C13	C3	=IF(A3:A13=B3:B13,"EUTHANIZED","RELEASED")
Dynamic array formulas.

I appreciate this, but the number in A1 will change, daily. I'm looking for something that will reference A1 as the number of rows to create.

EDIT:
It will reference A1 as the number of rows to create while executing the IF formula, without any additional input or drag-down.

 

[Peter_SSs]

Something like this then?

25 03 07.xlsm
	A	B	C
1	11
2	Intake Date	Disposition Date	Disposition
3	5/01/2023	15/05/2023	RELEASED
4	6/01/2023	27/05/2023	RELEASED
5	10/02/2023	21/05/2023	RELEASED
6	17/02/2023	18/04/2023	RELEASED
7	18/02/2023	18/02/2023	EUTHANIZED
8	6/03/2023	2/04/2023	RELEASED
9	8/03/2023	20/04/2023	RELEASED
10	13/03/2023	10/05/2023	RELEASED
11	16/03/2023	16/03/2023	EUTHANIZED
12	22/03/2023	24/03/2023	RELEASED
13	30/03/2023	30/03/2023	EUTHANIZED
14
15
Spill down

Cell Formulas
Range	Formula
C3:C13	C3	=LET(d,INDEX(A3:B1000,SEQUENCE(A1),{1,2}),IF(INDEX(d,0,1)=INDEX(d,0,2),"EUTHANIZED","RELEASED"))
Dynamic array formulas.

 

[Eric W]

You could do something like this:

Book2
	A	B	C
1	11
2	Intake Date	Disposition Date	Disposition
3	1/5/2023	5/15/2023	RELEASED
4	1/6/2023	5/27/2023	RELEASED
5	2/10/2023	5/21/2023	RELEASED
6	2/17/2023	4/18/2023	RELEASED
7	2/18/2023	2/18/2023	EUTHANIZED
8	3/6/2023	4/2/2023	RELEASED
9	3/8/2023	4/20/2023	RELEASED
10	3/13/2023	5/10/2023	RELEASED
11	3/16/2023	3/16/2023	EUTHANIZED
12	3/22/2023	3/24/2023	RELEASED
13	3/30/2023	3/30/2023	EUTHANIZED
14
Sheet2

Cell Formulas
Range	Formula
C3:C13	C3	=LET(f,FILTER(A3:B1000,A3:A1000<>""),IF(INDEX(f,0,1)=INDEX(f,0,2),"EUTHANIZED","RELEASED"))
Dynamic array formulas.

In this formula, you don't need a value in A1. The formula looks for how many rows in column A have data in them.