gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
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.
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 |