Display a list if count is >1

[gtd526]

Hello,
I have a list of upcoming birthdays (see below). I can list just 1, but 1+ ??
More than 1 birthday on same day.
How can I create a list of student names if count(D) is >1? ie Row 14, count of 2
Student names are listed: Kids!$B:$B
Next birthday: Kids!$J:$J

Thank you.

_Talentos SAH Artists_ - EXCELL.xlsm
	A	B	C	D	E
1	All Kids - Birthdays Coming
2	Sex	Student	Birthday	Count	In () Days
3				0	1
4				0	2
5	F	Naomy Suarez	9/24/2020	1	3
6				0	4
7				0	5
8				0	6
9				0	7
10				0	8
11				0	9
12				0	10
13				0	11
14	F	Gianna Diftereos	10/3/2020	2	12
15				0	13
16				0	14
17				0	15
Birthday List

Cell Formulas
Range	Formula
A3:A17	A3	=IFERROR(INDEX(Kids!L:L,MATCH($B3,Kids!B:B,0)),"")
B3:B17	B3	=IFERROR(INDEX(Kids!$B:$B,MATCH($E3,Kids!$K:$K,0)),"")
C3:C17	C3	=IFERROR(INDEX(Kids!$J:$J,MATCH($E3,Kids!$K:$K,0)),"")
D3	D3	=COUNTIF(Kids!$K$6:$K$22,"=1")
D4	D4	=COUNTIF(Kids!$K$6:$K$22,"=2")
D5	D5	=COUNTIF(Kids!$K$6:$K$22,"=3")
D6	D6	=COUNTIF(Kids!$K$6:$K$22,"=4")
D7	D7	=COUNTIF(Kids!$K$6:$K$22,"=5")
D8	D8	=COUNTIF(Kids!$K$6:$K$22,"=6")
D9	D9	=COUNTIF(Kids!$K$6:$K$22,"=7")
D10	D10	=COUNTIF(Kids!$K$6:$K$22,"=8")
D11	D11	=COUNTIF(Kids!$K$6:$K$22,"=9")
D12	D12	=COUNTIF(Kids!$K$6:$K$22,"=10")
D13	D13	=COUNTIF(Kids!$K$6:$K$22,"=11")
D14	D14	=COUNTIF(Kids!$K$6:$K$22,"=12")
D15	D15	=COUNTIF(Kids!$K$6:$K$22,"=13")
D16	D16	=COUNTIF(Kids!$K$6:$K$22,"=14")
D17	D17	=COUNTIF(Kids!$K$6:$K$22,"=15")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:A17	Expression	=$A3="M"	text	NO
A3:A17	Expression	=$A3="F"	text	NO

 

[kweaver]

It's confusing to me because your XL2BB doesn't show the J nor K columns.

 

[gtd526]

It's confusing to me because your XL2BB doesn't show the J nor K columns.

Sorry about that.
Its a different worksheet in the same workbook. I didn't create it, just adding a few things.

_Talentos SAH Artists_ - EXCELL.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1									MIN age:	8
2		KIDS							MAX age:	15
3		Legal Name							added column
4		NOMBRE	CASTING NETWORK	PADRE O REPRESENTANTE	FOTO	CONTRATO	BIRTHDAY	EDAD	AGE	Next Bday	Bday In:	SEX
5		GIRLS									Days
6	1	Any Dalay Rodriguez	SI	Dianele Gomez Lopez	si	Si	12/27/2007	11	12	12/27/2020	97	F
7	2	Gianna Diftereos	SI	Jordana Fernandez	si	Si	10/3/2011	7	8	10/3/2020	12	F
8	3	Brianny Pazmino	NO	Kennya	si	no	10/7/2011	6	8	10/7/2020	16	F
9	4	Naomy Suarez	SI	Nilde	si	si	9/24/2005	14	14	9/24/2020	3	F
10	5	Tamara Picones	NO	Lourdes	si	?	1/17/2007	12	13	1/17/2021	118	F
11	6	Valerie Cardella	SI	Kemia Marrero	si	si	10/25/2008	10	11	10/25/2020	34	F
12	7	Barbara Portales	SI	Barbara Rgz/Yosuani	si	?	10/3/2007	12	12	10/3/2020	12	F
13	8	Alejandra Garcia	NO	Yanisleidy Lara	si	SI	10/22/2010	8	9	10/22/2020	31	F
14	9	Adiley Tamayo	NO FOTO	Olga Santos	si	si	6/3/2005	14	15	6/3/2021	255	F
15	10	Katie Perez	NO	Yasmin Josende	si	si firmar	1/2/2007	12	13	1/2/2021	103	F
16	11	Sarah Marie Luis	SI	Denise Mesa	si	si	11/10/2006	13	13	11/10/2020	50	F
17	12	Talisa Justiniano	SI	Terely Justiniano	?	si	11/26/2009	10	10	11/26/2020	66	F
18	13	Geraldine Nuñez	NO	Talia/Alberto Ferreira	si	pendiente	3/16/2011	8	9	3/16/2021	176	F
19	14	Sofia Mirabal	SI	Gretchen Roig/Rolando Mirabal	si	si	1/25/2010	9	10	1/25/2021	126	F
20	15	Isabella Lauren Diaz	SI	Pavel Diaz/ elizabeth	si	si	11/7/2006	12	13	11/7/2020	47	F
21	16	Elizabeth Chinea	NO	Oscar Chinea/ Araceli Torres	?	si	7/11/2007	12	13	7/11/2021	293	F
22	17	Allison Garcia	NO	Brian Garcia/Maria	?	si	9/1/2010	9	10	9/1/2021	345	F
Kids

Cell Formulas
Range	Formula
J1	J1	=MIN(I6:I22)
J2	J2	=MAX(I6:I22)
I6:I22	I6	=INT(YEARFRAC($G6,TODAY()))
J6:J22	J6	=DATE(YEAR(G6)+DATEDIF(G6,TODAY(),"y")+1,MONTH(G6),DAY(G6))
K6:K22	K6	=DATEDIF(TODAY(),J6,"d")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I6:I22	Cell Value	top 1 bottom values	text	NO
I6:I22	Cell Value	top 1 values	text	NO

 

[kweaver]

I thought if you put the # Days in O1 (e.g., find all who have bdays less than or equal to O1's value days away), you could do a macro to filter your people:

Sub MyFilter()
    With ThisWorkbook.Worksheets("Sheet1")
        .Range("A7:L43").AutoFilter Field:=11, Criteria1:="<=" & Range("O1").Value
    End With
End Sub

There's probably another VBA approach if you wanted the people listed, but I haven't created that.

 

[gtd526]

It's confusing to me because your XL2BB doesn't show the J nor K columns.

I found the solution.
Thanks for the reply.

 

[gtd526]

I thought if you put the # Days in O1 (e.g., find all who have bdays less than or equal to O1's value days away), you could do a macro to filter your people:

Sub MyFilter()
    With ThisWorkbook.Worksheets("Sheet1")
        .Range("A7:L43").AutoFilter Field:=11, Criteria1:="<=" & Range("O1").Value
    End With
End Sub

There's probably another VBA approach if you wanted the people listed, but I haven't created that.

I found the solution. Using Index Match combo.
thx for the reply.