12. Switch to the Academic Groups worksheet. In cell A14, use the INDEX function and structured references to display th
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
12. Switch to the Academic Groups worksheet. In cell A14, use the INDEX function and structured references to display th
An Cell Styles- Format - bort & Find & Filter - Select - Alignment F Number 19 Styles Cells Fating Ana fx -VLOOKUP(Q2,Student Representatives[[Student ID] [Name]1,2,FALSE) D * G Age Post-Secondary Years Base Rate Class Finance Certified Grad Student Elected Qualified Driver Leadership Training Ma 24 Kay Colbert Michael Crozier 6 Yes NO YES 25 TEE 7 Yes Yes YES YES 21 3 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No No Yes YES YES Brandon Miles Michael Alvarez Ida Smith Betty Garza 4 No No YES 2 No Yes YES 6 16.50 16.50 15.75 15.75 15.75 16.50 17.50 15.00 16.50 15.75 16.50 2025 Yes Yes No YES Leroy Pirkle 2022 Yes Yes No YES 2026 No No No NO Yes Yes YES Warren Stewart Stacy Wiggins Billy Herald Margaret Cruz Chester Keese 2025 Yes 2022 No No No YES 2023 Yes No No YES 2024 No No No NO 2026 Yes No No NO Claudette Littell Florence Miller 15.00 15:25 15.75 2023 Yes 17.50 2023 Yes 15.75 2025 Yes No No YES Yes No VES Kimberly Gerace Roman Goble NO No YES 2022 Yes No Yes YES Jocelyn Allen Ron Morse YES 2022 Yes No No 15.75 15.75 15.75 15.25 TEC No 2025 No No 2022 Yes NO No Yes Roberta Ervin James Rusnak Con HEE M W 2016 Me Academic Pivottable All Group Documentation Student Representatives 03 X A 1 Student ID Name 2 G62918 3 P49234 4 W99035 5 V42056 6 159828 7 F72412 8 W20999 9 018870 10 W75774 11 N25220 12 094361 13 687578 14 868170 15 M89375 16563900 17 Y96036 18 C82505 19 Y75358 20160811 21 056783 35078301 S 223322975 19 24 28 18 24 21 18 19 26 20 21 10 0 6 3 5 0 1 3 8 4 4 2 3 1 Academic Groups 41 1 8 8 8 8 8 8 8 3 3 3 3 3 3 3 3 3 3 3 3 NO NO YES VES YES YES YES YES YES YES YES VES YES YES TES VES YES YES
45 fx VLOOKUP(Q2,StudentRepresentatives[[Student ID]:[Name]],2,FALSE) M N 0 1 Leadership Training Mentor Officer Qualified TIER Р 2 YES YES YES 2 3 YES YES ELECTED Student ID Student Name 4 YES YES ELECTED 5 YES YES YES 6 YES YES ELECTED 7 YES YES YES BYES YES YES Blected Students 9 NO YES NO All Students 10 YES YES ELECTED 11 YES YES NO 12 YES YES YES 13 NO YES NO Postsecondary Years Base Rate 14 NO YES YES 15 YES YES YES 16 YES YES YES 17 YES YES YES 18 YES YES ELECTED 19 YES YES YES 20 YES YES NO 21 NO YES ELECTED VEC ELECTED 33 VEE Academic CountTable Documentation. Student Representatives Academic denuns F Celli Q G62918 Kay Colbert Total Students Average Post-Secondary Years 7 15:25 All inne Styles 30 0 15 2 15,75 Editing